{"id":3916,"date":"2023-07-14T19:01:55","date_gmt":"2023-07-14T19:01:55","guid":{"rendered":"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/"},"modified":"2023-07-14T19:01:55","modified_gmt":"2023-07-14T19:01:55","slug":"sas-proc-sql-masuk","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/","title":{"rendered":"Sas: cara menggunakan operator in di proc sql"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan operator <b>IN<\/b> dalam pernyataan <strong>PROC SQL<\/strong> di SAS untuk hanya mengembalikan baris yang variabelnya dalam kumpulan data berisi nilai dalam daftar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan operator <b>IN<\/b> dalam praktiknya.<\/span><\/p>\n<h2> <strong>Contoh: Menggunakan Operator IN di PROC SQL di SAS<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di SAS yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create dataset*\/\n<\/span><span style=\"color: #000000;\"><span style=\"color: #800080;\">data<\/span> my_data;\n    <span style=\"color: #3366ff;\">input<\/span> team $points;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\nAT 12\nAt 14\nAt 15\nAt 18\nB 31\nB 32\nC 35\nC 36\nC40\nD 28\nE20\nE 21\n;\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view dataset*\/\n<\/span><span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> =my_data;\n<\/span><\/strong><\/span><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31488 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/en-1.jpg\" alt=\"\" width=\"164\" height=\"351\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan operator <strong>IN<\/strong> di <strong>PROC SQL<\/strong> untuk memilih hanya baris yang timnya sama dengan A, B, atau E:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*select all rows where team is A, B, or E*\/\n<\/span><span style=\"color: #800080;\">proc sql<\/span> ;\n   <span style=\"color: #3366ff;\">select<\/span> *\n   <span style=\"color: #3366ff;\">from<\/span> my_data\n   <span style=\"color: #3366ff;\">where<\/span> team <span style=\"color: #3366ff;\">in<\/span> ('A', 'B', 'E');\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31489 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/en-2.jpg\" alt=\"\" width=\"138\" height=\"268\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya baris dengan tim yang sama dengan A, B, atau E yang dikembalikan.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kebalikan dari operator <strong>IN<\/strong> di <strong>PROC SQL<\/strong> adalah <strong>NOT IN<\/strong> , yang memilih baris di mana beberapa variabel dalam kumpulan data <em>tidak<\/em> berisi nilai dalam daftar.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menggunakan operator <strong>NOT IN<\/strong> untuk memilih semua baris yang timnya tidak sama dengan A, B, atau E:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*select all rows where team is not A, B, or E*\/\n<\/span><span style=\"color: #800080;\">proc sql<\/span> ;\n   <span style=\"color: #3366ff;\">select<\/span> *\n   <span style=\"color: #3366ff;\">from<\/span> my_data\n   <span style=\"color: #3366ff;\">where<\/span> team <span style=\"color: #3366ff;\">not in<\/span> ('A', 'B', 'E');\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31490 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/en3.jpg\" alt=\"\" width=\"133\" height=\"154\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya baris yang timnya tidak sama dengan A, B, atau E yang dikembalikan.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di SAS:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/sas-proc-serikat-sql\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan UNION di PROC SQL<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sas-proc-sql-kecuali\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan KECUALI di PROC SQL<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sas-proc-univariat-berdasarkan-grup\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan Proc Univariate berdasarkan grup<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan operator IN dalam pernyataan PROC SQL di SAS untuk hanya mengembalikan baris yang variabelnya dalam kumpulan data berisi nilai dalam daftar. Contoh berikut menunjukkan cara menggunakan operator IN dalam praktiknya. Contoh: Menggunakan Operator IN di PROC SQL di SAS Misalkan kita memiliki kumpulan data berikut di SAS yang berisi informasi tentang berbagai [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SAS: Cara menggunakan operator IN di PROC SQL - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan operator IN di PROC SQL di SAS untuk memilih baris di mana variabel tertentu berisi nilai dalam daftar.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS: Cara menggunakan operator IN di PROC SQL - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan operator IN di PROC SQL di SAS untuk memilih baris di mana variabel tertentu berisi nilai dalam daftar.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T19:01:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/en-1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/\",\"url\":\"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/\",\"name\":\"SAS: Cara menggunakan operator IN di PROC SQL - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T19:01:55+00:00\",\"dateModified\":\"2023-07-14T19:01:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan operator IN di PROC SQL di SAS untuk memilih baris di mana variabel tertentu berisi nilai dalam daftar.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sas: cara menggunakan operator in di proc sql\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAS: Cara menggunakan operator IN di PROC SQL - Statorials","description":"Tutorial ini menjelaskan cara menggunakan operator IN di PROC SQL di SAS untuk memilih baris di mana variabel tertentu berisi nilai dalam daftar.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/","og_locale":"id_ID","og_type":"article","og_title":"SAS: Cara menggunakan operator IN di PROC SQL - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan operator IN di PROC SQL di SAS untuk memilih baris di mana variabel tertentu berisi nilai dalam daftar.","og_url":"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/","og_site_name":"Statorials","article_published_time":"2023-07-14T19:01:55+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/en-1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/","url":"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/","name":"SAS: Cara menggunakan operator IN di PROC SQL - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T19:01:55+00:00","dateModified":"2023-07-14T19:01:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan operator IN di PROC SQL di SAS untuk memilih baris di mana variabel tertentu berisi nilai dalam daftar.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Sas: cara menggunakan operator in di proc sql"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3916"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=3916"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3916\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3916"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3916"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}