{"id":3976,"date":"2023-07-14T09:49:24","date_gmt":"2023-07-14T09:49:24","guid":{"rendered":"https:\/\/statorials.org\/id\/sas-proc-sql-jika-pernyataan\/"},"modified":"2023-07-14T09:49:24","modified_gmt":"2023-07-14T09:49:24","slug":"sas-proc-sql-jika-pernyataan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sas-proc-sql-jika-pernyataan\/","title":{"rendered":"Sas: cara menggunakan pernyataan if di proc sql"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Meskipun tidak mungkin menggunakan pernyataan <strong>IF<\/strong> dalam <strong>PROC SQL<\/strong> di SAS, Anda dapat menggunakan operator <strong>CASE<\/strong> untuk menentukan nilai yang harus diambil suatu variabel berdasarkan kondisi tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan operator <b>CASE<\/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: Menggunakan operator CASE dengan hanya dua hasil<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan operator <strong>CASE<\/strong> di <strong>PROC SQL<\/strong> untuk menghasilkan kolom baru di dataset bernama <strong>points_flag<\/strong> yang mengambil nilai 0 jika nilai di kolom <strong>poin<\/strong> kurang dari 20 atau bernilai 1 sebaliknya:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create new column called points_flag using case operator*\/ \n<\/span><span style=\"color: #000000;\"><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;\">box<\/span> \n      <span style=\"color: #3366ff;\">when<\/span> <span style=\"color: #000000;\">points &lt;<\/span> <span style=\"color: #008000;\">20<\/span> <span style=\"color: #3366ff;\">then<\/span> <span style=\"color: #008000;\">0<\/span> <span style=\"color: #3366ff;\">else<\/span> <span style=\"color: #008000;\">1<\/span>\n      <span style=\"color: #3366ff;\">end<\/span> <span style=\"color: #3366ff;\">as<\/span> <span style=\"color: #000000;\">points_flag\n<\/span><span style=\"color: #3366ff;\">from<\/span> <span style=\"color: #000000;\">my_data;\n<\/span><span style=\"color: #800080;\">quit<\/span> <span style=\"color: #000000;\">;<\/span><\/span><\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31854 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifsql1.jpg\" alt=\"\" width=\"236\" height=\"280\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kolom <strong>points_flag<\/strong> mengambil nilai 0 jika nilai kolom <strong>points<\/strong> kurang dari 20 atau nilai 1 sebaliknya.<\/span><\/p>\n<h2> <strong>Contoh 2: Menggunakan operator CASE dengan lebih dari dua hasil<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Kita juga bisa menggunakan operator <strong>CASE<\/strong> di <strong>PROC SQL<\/strong> untuk menghasilkan kolom baru di dataset bernama <strong>points_flag<\/strong> yang bernilai 0 jika nilai di kolom <strong>poin<\/strong> kurang dari 20, bernilai 1 jika <strong>poinnya<\/strong> kurang dari 35, atau nilai 2 sebaliknya:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create new column called points_flag using case operator*\/ \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;\">box<\/span> \n      <span style=\"color: #3366ff;\">when<\/span> <span style=\"color: #000000;\">points &lt;<\/span> <span style=\"color: #008000;\">20<\/span> <span style=\"color: #3366ff;\">then<\/span> <span style=\"color: #008000;\">0\n<\/span><span style=\"color: #000000;\"><span style=\"color: #3366ff;\">when<\/span> points &lt;<\/span> <span style=\"color: #000000;\"><span style=\"color: #008000;\">35<\/span> <span style=\"color: #3366ff;\">then<\/span> <span style=\"color: #008000;\">1<\/span> <span style=\"color: #3366ff;\">else<\/span> <span style=\"color: #008000;\">2<\/span><\/span>\n      <span style=\"color: #3366ff;\">end<\/span> <span style=\"color: #3366ff;\">as<\/span> <span style=\"color: #000000;\">points_flag\n      <\/span><span style=\"color: #3366ff;\">from<\/span> <span style=\"color: #000000;\">my_data;\n<\/span><span style=\"color: #800080;\">quit<\/span> <span style=\"color: #000000;\">;<\/span><\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31855 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ifsql2.jpg\" alt=\"\" width=\"241\" height=\"290\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kolom <strong>points_flag<\/strong> mengambil nilai 0, 1, atau 2 bergantung pada nilai terkait di kolom <strong>poin<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jangan ragu untuk menggunakan pernyataan <strong>while<\/strong> sebanyak yang Anda inginkan untuk menghasilkan nilai berbeda sebanyak yang Anda inginkan di kolom baru.<\/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-atau\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan operator WHERE 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\/pembaruan-sas-proc-sql\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan UPDATE di PROC SQL<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sas-proc-sql-berisi\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan CONTAIN dalam PROC SQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Meskipun tidak mungkin menggunakan pernyataan IF dalam PROC SQL di SAS, Anda dapat menggunakan operator CASE untuk menentukan nilai yang harus diambil suatu variabel berdasarkan kondisi tertentu. Contoh berikut menunjukkan cara menggunakan operator CASE dalam praktik dengan kumpulan data berikut di SAS yang berisi informasi tentang berbagai pemain bola basket: \/*create dataset*\/ data my_data; input [&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 pernyataan IF di PROC SQL - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan pernyataan IF dalam PROC SQL di SAS, dengan sebuah contoh.\" \/>\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-jika-pernyataan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS: Cara menggunakan pernyataan IF di PROC SQL - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan pernyataan IF dalam PROC SQL di SAS, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sas-proc-sql-jika-pernyataan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T09:49:24+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-jika-pernyataan\/\",\"url\":\"https:\/\/statorials.org\/id\/sas-proc-sql-jika-pernyataan\/\",\"name\":\"SAS: Cara menggunakan pernyataan IF di PROC SQL - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T09:49:24+00:00\",\"dateModified\":\"2023-07-14T09:49:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan pernyataan IF dalam PROC SQL di SAS, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-jika-pernyataan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sas-proc-sql-jika-pernyataan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-jika-pernyataan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sas: cara menggunakan pernyataan if 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 pernyataan IF di PROC SQL - Statorials","description":"Tutorial ini menjelaskan cara menggunakan pernyataan IF dalam PROC SQL di SAS, dengan sebuah contoh.","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-jika-pernyataan\/","og_locale":"id_ID","og_type":"article","og_title":"SAS: Cara menggunakan pernyataan IF di PROC SQL - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan pernyataan IF dalam PROC SQL di SAS, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/sas-proc-sql-jika-pernyataan\/","og_site_name":"Statorials","article_published_time":"2023-07-14T09:49:24+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-jika-pernyataan\/","url":"https:\/\/statorials.org\/id\/sas-proc-sql-jika-pernyataan\/","name":"SAS: Cara menggunakan pernyataan IF di PROC SQL - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T09:49:24+00:00","dateModified":"2023-07-14T09:49:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan pernyataan IF dalam PROC SQL di SAS, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sas-proc-sql-jika-pernyataan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sas-proc-sql-jika-pernyataan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sas-proc-sql-jika-pernyataan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Sas: cara menggunakan pernyataan if 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\/3976"}],"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=3976"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3976\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}