{"id":3975,"date":"2023-07-14T09:57:48","date_gmt":"2023-07-14T09:57:48","guid":{"rendered":"https:\/\/statorials.org\/id\/sas-proc-sql-berisi\/"},"modified":"2023-07-14T09:57:48","modified_gmt":"2023-07-14T09:57:48","slug":"sas-proc-sql-berisi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sas-proc-sql-berisi\/","title":{"rendered":"Sas: cara menggunakan contain dalam proc sql"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan operator <b>CONTAINS<\/b> dalam pernyataan <strong>SQL PROC<\/strong> di SAS untuk hanya mengembalikan baris yang variabelnya dalam kumpulan data berisi pola string.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan operator <b>CONTAINS<\/b> dalam praktik<\/span> <span style=\"color: #000000;\">dengan 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<h2> <strong>Contoh 1: pilih baris yang variabelnya berisi pola<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan operator <strong>CONTAINS<\/strong> di <strong>PROC SQL<\/strong> untuk memilih hanya baris yang timnya berisi pola &#8220;avs&#8221; di suatu tempat di namanya:<\/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 contains 'avs'*\/ \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;\">contains<\/span> 'avs';\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31503 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comme2.jpg\" alt=\"\" width=\"124\" height=\"179\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya baris di mana tim berisi &#8220;avs&#8221; di suatu tempat di namanya yang dikembalikan.<\/span><\/p>\n<h2> <strong>Contoh 2: Pilih baris yang variabelnya berisi salah satu dari beberapa pola<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan operator <strong>CONTAINS<\/strong> di <strong>PROC SQL<\/strong> untuk memilih hanya baris yang timnya berisi pola &#8220;avs&#8221; <em>atau<\/em> pola &#8220;ics&#8221; di suatu tempat di namanya:<\/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 contains 'avs' or 'ics'*\/ \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;\">contains<\/span> 'avs' <span style=\"color: #3366ff;\">or<\/span> team <span style=\"color: #3366ff;\">contains<\/span> 'ics';\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31849 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/contient4.jpg\" alt=\"\" width=\"130\" height=\"219\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hanya baris di mana tim berisi &#8220;avs&#8221; <em>atau<\/em> &#8220;ics&#8221; di suatu tempat di namanya yang dikembalikan.<\/span><\/p>\n<h2> <strong>Contoh 3: pilih baris yang variabelnya tidak mengandung pola<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Kebalikan dari operator <strong>CONTAINS<\/strong> di <strong>PROC SQL<\/strong> adalah <strong>NOT CONTAINS<\/strong> , yang memilih baris di mana variabel tertentu dalam kumpulan data <em>tidak<\/em> mengandung pola string tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menggunakan operator <strong>NOT CONTAINS<\/strong> untuk memilih semua baris yang nama timnya tidak mengandung &#8220;avs&#8221;:<\/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 does not contain 'avs'*\/\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 contains<\/span> 'avs';\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31504 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comme3.jpg\" alt=\"\" width=\"149\" height=\"150\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya baris di mana tim tidak mengandung &#8220;avs&#8221; di suatu tempat dalam namanya 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-sql-masuk\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan operator IN di PROC SQL<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sas-proc-sql-atau\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan operator WHERE di PROC SQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan operator CONTAINS dalam pernyataan SQL PROC di SAS untuk hanya mengembalikan baris yang variabelnya dalam kumpulan data berisi pola string. Contoh berikut menunjukkan cara menggunakan operator CONTAINS dalam praktik dengan kumpulan data berikut di SAS yang berisi informasi tentang berbagai pemain bola basket: \/*create dataset*\/ data my_data; input team $points; datalines ; [&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 CONTAINS di PROC SQL - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan caranya\" \/>\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-berisi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS: Cara menggunakan CONTAINS di PROC SQL - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan caranya\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sas-proc-sql-berisi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T09:57:48+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\/sas-proc-sql-berisi\/\",\"url\":\"https:\/\/statorials.org\/id\/sas-proc-sql-berisi\/\",\"name\":\"SAS: Cara menggunakan CONTAINS di PROC SQL - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T09:57:48+00:00\",\"dateModified\":\"2023-07-14T09:57:48+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan caranya\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-berisi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sas-proc-sql-berisi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-berisi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sas: cara menggunakan contain dalam 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 CONTAINS di PROC SQL - Statologi","description":"Tutorial ini menjelaskan caranya","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-berisi\/","og_locale":"id_ID","og_type":"article","og_title":"SAS: Cara menggunakan CONTAINS di PROC SQL - Statologi","og_description":"Tutorial ini menjelaskan caranya","og_url":"https:\/\/statorials.org\/id\/sas-proc-sql-berisi\/","og_site_name":"Statorials","article_published_time":"2023-07-14T09:57:48+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\/sas-proc-sql-berisi\/","url":"https:\/\/statorials.org\/id\/sas-proc-sql-berisi\/","name":"SAS: Cara menggunakan CONTAINS di PROC SQL - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T09:57:48+00:00","dateModified":"2023-07-14T09:57:48+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan caranya","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sas-proc-sql-berisi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sas-proc-sql-berisi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sas-proc-sql-berisi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Sas: cara menggunakan contain dalam 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\/3975"}],"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=3975"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3975\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3975"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3975"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3975"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}