{"id":3917,"date":"2023-07-14T18:49:49","date_gmt":"2023-07-14T18:49:49","guid":{"rendered":"https:\/\/statorials.org\/id\/sas-proc-sql-atau\/"},"modified":"2023-07-14T18:49:49","modified_gmt":"2023-07-14T18:49:49","slug":"sas-proc-sql-atau","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sas-proc-sql-atau\/","title":{"rendered":"Sas: cara menggunakan operator where di proc sql"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan operator <b>WHERE<\/b> dalam pernyataan <strong>PROC SQL<\/strong> di SAS untuk mengembalikan hanya baris yang kondisi tertentu terpenuhi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan operator <strong>WHERE<\/strong> dalam skenario berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Pilih baris yang kondisinya terpenuhi.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pilih baris yang salah satu dari beberapa kondisinya terpenuhi.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pilih baris yang beberapa kondisinya terpenuhi.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan operator <strong>WHERE<\/strong> di setiap skenario dengan kumpulan data berikut di SAS:<\/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;<\/span><\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31494 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ou1.jpg\" alt=\"\" width=\"164\" height=\"356\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <strong>Contoh 1: <span style=\"color: #000000;\">pilih baris yang kondisinya terpenuhi<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menggunakan operator <strong>WHERE<\/strong> dalam pernyataan <strong>SQL PROC<\/strong> untuk memilih semua baris dalam kumpulan data yang tim sama dengan A:<\/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 equal to A*\/\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 = 'A';\n<span style=\"color: #800080;\">quit<\/span> ;\n<\/strong><\/span><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31496 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ou2.jpg\" alt=\"\" width=\"128\" height=\"149\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Satu-satunya baris yang dikembalikan adalah baris yang timnya sama dengan A.<\/span><\/p>\n<h2> <strong>Contoh 2: <span style=\"color: #000000;\">Pilih baris yang salah satu dari beberapa kondisinya terpenuhi<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menggunakan operator <strong>WHERE<\/strong> dalam pernyataan <strong>SQL PROC<\/strong> untuk memilih semua baris dalam kumpulan data yang timnya sama dengan A <em>atau<\/em> poinnya lebih besar dari 30:<\/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 equal to A or points is greater than 30*\/\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 = 'A' <span style=\"color: #3366ff;\">or<\/span> points &gt; <span style=\"color: #008000;\">30<\/span> ;\n<span style=\"color: #800080;\">quit<\/span> ;\n<\/strong><\/span><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31497 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ou3.jpg\" alt=\"\" width=\"145\" height=\"293\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Satu-satunya baris yang dikembalikan adalah baris yang timnya sama dengan A <em>atau<\/em> poinnya lebih besar dari 30:<\/span><\/p>\n<h2> <strong>Contoh 3: <span style=\"color: #000000;\">pilih baris yang beberapa kondisinya terpenuhi<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menggunakan operator <strong>WHERE<\/strong> dalam pernyataan <strong>SQL PROC<\/strong> untuk memilih semua baris dalam kumpulan data dengan tim sama dengan A <i>dan<\/i> poin lebih besar dari 13:<\/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 equal to A and points is greater than 13*\/\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 = 'A' <span style=\"color: #3366ff;\">and<\/span> points &gt; <span style=\"color: #008000;\">13<\/span> ;\n<span style=\"color: #800080;\">quit<\/span> ;\n<\/strong><\/span><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31498 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ou4.jpg\" alt=\"\" width=\"138\" height=\"106\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Satu-satunya garis yang dikembalikan adalah garis yang timnya sama dengan A <i>dan<\/i> poinnya lebih besar dari 13:<\/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-sql-masuk\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan operator IN di PROC SQL<\/a><br \/> <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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan operator WHERE dalam pernyataan PROC SQL di SAS untuk mengembalikan hanya baris yang kondisi tertentu terpenuhi. Contoh berikut menunjukkan cara menggunakan operator WHERE dalam skenario berikut: Pilih baris yang kondisinya terpenuhi. Pilih baris yang salah satu dari beberapa kondisinya terpenuhi. Pilih baris yang beberapa kondisinya terpenuhi. Contoh berikut menunjukkan cara menggunakan operator [&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 WHERE di PROC SQL - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan operator WHERE di PROC SQL di SAS untuk memilih baris dalam kumpulan data berdasarkan kondisi.\" \/>\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-atau\/\" \/>\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 WHERE di PROC SQL - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan operator WHERE di PROC SQL di SAS untuk memilih baris dalam kumpulan data berdasarkan kondisi.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sas-proc-sql-atau\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T18:49:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ou1.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=\"2 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-atau\/\",\"url\":\"https:\/\/statorials.org\/id\/sas-proc-sql-atau\/\",\"name\":\"SAS: Cara menggunakan operator WHERE di PROC SQL - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T18:49:49+00:00\",\"dateModified\":\"2023-07-14T18:49:49+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan operator WHERE di PROC SQL di SAS untuk memilih baris dalam kumpulan data berdasarkan kondisi.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-atau\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sas-proc-sql-atau\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-atau\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sas: cara menggunakan operator where 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 WHERE di PROC SQL - Statologi","description":"Tutorial ini menjelaskan cara menggunakan operator WHERE di PROC SQL di SAS untuk memilih baris dalam kumpulan data berdasarkan kondisi.","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-atau\/","og_locale":"id_ID","og_type":"article","og_title":"SAS: Cara menggunakan operator WHERE di PROC SQL - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan operator WHERE di PROC SQL di SAS untuk memilih baris dalam kumpulan data berdasarkan kondisi.","og_url":"https:\/\/statorials.org\/id\/sas-proc-sql-atau\/","og_site_name":"Statorials","article_published_time":"2023-07-14T18:49:49+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ou1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/sas-proc-sql-atau\/","url":"https:\/\/statorials.org\/id\/sas-proc-sql-atau\/","name":"SAS: Cara menggunakan operator WHERE di PROC SQL - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T18:49:49+00:00","dateModified":"2023-07-14T18:49:49+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan operator WHERE di PROC SQL di SAS untuk memilih baris dalam kumpulan data berdasarkan kondisi.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sas-proc-sql-atau\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sas-proc-sql-atau\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sas-proc-sql-atau\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Sas: cara menggunakan operator where 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\/3917"}],"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=3917"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3917\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}