{"id":4581,"date":"2023-07-09T22:20:38","date_gmt":"2023-07-09T22:20:38","guid":{"rendered":"https:\/\/statorials.org\/id\/kunci-udara-masuk\/"},"modified":"2023-07-09T22:20:38","modified_gmt":"2023-07-09T22:20:38","slug":"kunci-udara-masuk","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kunci-udara-masuk\/","title":{"rendered":"Cara menggunakan antara operator di sas (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan operator <strong>BETWEEN<\/strong> di SAS untuk memilih baris yang nilai kolomnya berada di antara dua nilai tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Operator <strong>BETWEEN<\/strong> sering digunakan dalam pernyataan <strong>PROC SQL<\/strong> dengan cara berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #800080;\">proc sql<\/span> <span style=\"color: #000000;\">;\n   <\/span><span style=\"color: #3366ff;\">select<\/span> <span style=\"color: #000000;\">*\n   <\/span><span style=\"color: #3366ff;\">from<\/span> <span style=\"color: #000000;\">my_data\n   <\/span><span style=\"color: #3366ff;\">where<\/span> <span style=\"color: #000000;\">points <span style=\"color: #3366ff;\">between<\/span> <span style=\"color: #008000;\">15<\/span> <span style=\"color: #3366ff;\">and<\/span> <span style=\"color: #008000;\">35<\/span><\/span> <span style=\"color: #3366ff;\"><span style=\"color: #000000;\">;<\/span><\/span>\n<span style=\"color: #800080;\">quit<\/span> <span style=\"color: #000000;\">;<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini memilih semua baris dari kumpulan data yang disebut <strong>my_data<\/strong> dengan nilai di kolom <strong>points<\/strong> antara <strong>15<\/strong> dan <strong>35<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan operator <strong>BETWEEN<\/strong> dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara menggunakan operator ANTARA di SAS<\/strong><\/span><\/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: #800080;\">data<\/span> my_data;\n    <span style=\"color: #3366ff;\">input<\/span> team $points;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\nCavs 12\nCavs 14\nWarriors 15\nHawks 18\nMavs 31\nMavs 32\nMavs 35\nCeltics 36\nCeltics 40\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<\/strong><\/span><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31502 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comme1.jpg\" alt=\"\" width=\"187\" height=\"275\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan operator <b>BETWEEN<\/b> di <strong>PROC SQL<\/strong> untuk memilih hanya baris yang nilainya di kolom <strong>poin<\/strong> antara 15 dan 35:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">\/*select all rows where value in points column is between 15 and 35*\/ \n<\/span><span style=\"color: #800080;\">proc sql<\/span> <span style=\"color: #000000;\">;\n   <\/span><span style=\"color: #3366ff;\">select<\/span> <span style=\"color: #000000;\">*\n   <\/span><span style=\"color: #3366ff;\">from<\/span> <span style=\"color: #000000;\">my_data\n   <span style=\"color: #3366ff;\">where<\/span> points <span style=\"color: #3366ff;\">between<\/span> <span style=\"color: #008000;\">15<\/span> <span style=\"color: #3366ff;\">and<\/span> <span style=\"color: #008000;\">35<\/span><\/span> <span style=\"color: #3366ff;\"><span style=\"color: #000000;\">;<\/span><\/span>\n<span style=\"color: #800080;\">quit<\/span> <span style=\"color: #000000;\">;<\/span><\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35765 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/entre1-1.png\" alt=\"\" width=\"145\" height=\"170\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa satu-satunya baris yang dikembalikan adalah baris dengan nilai di kolom <strong>poin<\/strong> antara 15 dan 35.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa Anda dapat menggunakan operator <strong>BETWEEN<\/strong> dengan ketentuan tambahan dalam pernyataan <strong>WHERE<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda bisa menggunakan sintaks berikut untuk mengembalikan hanya baris yang nilai di kolom <strong>poinnya<\/strong> antara 15 dan 35 <em>dan<\/em> nilai di kolom <strong>tim<\/strong> adalah &#8220;Mavs&#8221;:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">\/*select rows where points is between 15 and 35 <em>and<\/em> team is Mavs*\/ \n<\/span><span style=\"color: #800080;\">proc sql<\/span> <span style=\"color: #000000;\">;\n   <\/span><span style=\"color: #3366ff;\">select<\/span> <span style=\"color: #000000;\">*\n   <\/span><span style=\"color: #3366ff;\">from<\/span> <span style=\"color: #000000;\">my_data\n   <span style=\"color: #3366ff;\">where<\/span> (points <span style=\"color: #3366ff;\">between<\/span> <span style=\"color: #008000;\">15<\/span> <span style=\"color: #3366ff;\">and<\/span> <span style=\"color: #008000;\">35<\/span><\/span> <span style=\"color: #3366ff;\"><span style=\"color: #000000;\">) <span style=\"color: #3366ff;\">and<\/span> team='Mavs';<\/span><\/span>\n<span style=\"color: #800080;\">quit<\/span> <span style=\"color: #000000;\">;<\/span><\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35766 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/entre2-1.png\" alt=\"\" width=\"127\" height=\"124\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hanya baris yang nilainya di kolom <strong>poin<\/strong> antara 15 dan 35 <em>dan<\/em> nilai di kolom <strong>tim<\/strong> adalah &#8220;Mavs&#8221; yang dikembalikan.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap operator <strong>ANTARA<\/strong> di SAS <a href=\"https:\/\/go.documentation.sas.com\/doc\/en\/pgmsascdc\/9.4_3.5\/sqlproc\/n0ir3fmhicpfo7n11bfqjn471qkz.htm\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/tidak-berbeda\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan operator NOT EQUAL di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sas-proc-sql-berisi\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan operator CONTAINS di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kunci-udara-tidak-termasuk\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan operator \u201cNOT IN\u201d di SAS<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan operator BETWEEN di SAS untuk memilih baris yang nilai kolomnya berada di antara dua nilai tertentu. Operator BETWEEN sering digunakan dalam pernyataan PROC SQL dengan cara berikut: proc sql ; select * from my_data where points between 15 and 35 ; quit ; Contoh khusus ini memilih semua baris dari kumpulan data [&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>Cara Menggunakan ANTARA Operator di SAS (Dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan operator BETWEEN di SAS untuk memilih baris yang nilai kolomnya berada di antara dua nilai tertentu.\" \/>\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\/kunci-udara-masuk\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan ANTARA Operator di SAS (Dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan operator BETWEEN di SAS untuk memilih baris yang nilai kolomnya berada di antara dua nilai tertentu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kunci-udara-masuk\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T22:20:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comme1.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\/kunci-udara-masuk\/\",\"url\":\"https:\/\/statorials.org\/id\/kunci-udara-masuk\/\",\"name\":\"Cara Menggunakan ANTARA Operator di SAS (Dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T22:20:38+00:00\",\"dateModified\":\"2023-07-09T22:20:38+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan operator BETWEEN di SAS untuk memilih baris yang nilai kolomnya berada di antara dua nilai tertentu.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kunci-udara-masuk\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kunci-udara-masuk\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kunci-udara-masuk\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan antara operator di sas (dengan contoh)\"}]},{\"@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":"Cara Menggunakan ANTARA Operator di SAS (Dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menggunakan operator BETWEEN di SAS untuk memilih baris yang nilai kolomnya berada di antara dua nilai tertentu.","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\/kunci-udara-masuk\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan ANTARA Operator di SAS (Dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan operator BETWEEN di SAS untuk memilih baris yang nilai kolomnya berada di antara dua nilai tertentu.","og_url":"https:\/\/statorials.org\/id\/kunci-udara-masuk\/","og_site_name":"Statorials","article_published_time":"2023-07-09T22:20:38+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comme1.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\/kunci-udara-masuk\/","url":"https:\/\/statorials.org\/id\/kunci-udara-masuk\/","name":"Cara Menggunakan ANTARA Operator di SAS (Dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T22:20:38+00:00","dateModified":"2023-07-09T22:20:38+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan operator BETWEEN di SAS untuk memilih baris yang nilai kolomnya berada di antara dua nilai tertentu.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kunci-udara-masuk\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kunci-udara-masuk\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kunci-udara-masuk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan antara operator di sas (dengan contoh)"}]},{"@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\/4581"}],"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=4581"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4581\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4581"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4581"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4581"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}