{"id":2637,"date":"2023-07-21T09:51:07","date_gmt":"2023-07-21T09:51:07","guid":{"rendered":"https:\/\/statorials.org\/id\/tidak-bergabung\/"},"modified":"2023-07-21T09:51:07","modified_gmt":"2023-07-21T09:51:07","slug":"tidak-bergabung","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tidak-bergabung\/","title":{"rendered":"Cara menggunakan fungsi coalesce di sas (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <b>COALESCE<\/b> di SAS untuk mengembalikan nilai pertama yang tidak hilang di setiap baris dalam kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><b>Contoh: <strong>Cara menggunakan COALESCE di SAS<\/strong><\/b><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di SAS yang berisi nilai yang hilang:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create dataset*\/\n<span style=\"color: #800080;\">data<\/span><\/span> original_data;\n    <span style=\"color: #3366ff;\">input<\/span> team $points rebounds assists;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\nWarriors 25 8 7\nWizards. 12 6\nRockets. . 5\nCeltics 24. 5\nThunder. 14 5\nSpurs 33 19 .\nNets. . .\nMavericks. 8 10\nKings. . 9\nPelicans. 23 6\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> = original_data;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23251 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/coa1.jpg\" alt=\"\" width=\"322\" height=\"289\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita dapat menggunakan fungsi <strong>COALESCE<\/strong> untuk membuat kolom baru yang mengembalikan nilai pertama yang tidak hilang di setiap baris di antara kolom poin, rebound, dan assist:<\/span><\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create new dataset*\/\n<\/span><span style=\"color: #800080;\">data<\/span> new_data;\n    <span style=\"color: #3366ff;\">set<\/span> original_data;\n    first_non_missing = <span style=\"color: #3366ff;\">coalesce<\/span> (points, rebounds, assists);\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view new dataset*\/\n<\/span><span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> =new_data;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-23252\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/coa2.jpg\" alt=\"Contoh Fungsi Penggabungan SAS\" width=\"454\" height=\"292\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut adalah cara memilih nilai kolom <b>first_non_missing<\/b> :<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Baris pertama: Nilai pertama yang tidak hilang antara poin, rebound, dan assist adalah <strong>25<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris kedua: Nilai pertama yang tidak hilang antara poin, rebound, dan assist adalah <strong>12<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Baris ketiga: Nilai pertama yang tidak hilang antara poin, rebound, dan assist adalah <strong>5<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan #1<\/strong> : Jika semua nilai hilang (seperti pada baris 7), maka fungsi <strong>COALESCE<\/strong> hanya akan mengembalikan nilai yang hilang.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan #2<\/strong> : Fungsi <strong>COALESCE<\/strong> hanya bekerja dengan variabel numerik. Jika Anda ingin mengembalikan nilai pertama yang tidak hilang di antara daftar variabel karakter, gunakan fungsi <strong>COALESCEC<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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\/menormalkan-data-di-airlock\/\" target=\"_blank\" rel=\"noopener\">Cara menormalkan data di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rantai-pengganti-airlock\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti karakter dalam string di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tanpa-mengganti-nilai-yang-hilang-dengan-nol\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti nilai yang hilang dengan nol di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jangan-hapus-duplikat\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus duplikat di SAS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi COALESCE di SAS untuk mengembalikan nilai pertama yang tidak hilang di setiap baris dalam kumpulan data. Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Contoh: Cara menggunakan COALESCE di SAS Misalkan kita memiliki kumpulan data berikut di SAS yang berisi nilai yang hilang: \/*create dataset*\/ data original_data; input team $points [&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 Fungsi COALESCE di SAS (Dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi COALESCE di SAS, dengan beberapa 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\/tidak-bergabung\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menggunakan Fungsi COALESCE di SAS (Dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi COALESCE di SAS, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tidak-bergabung\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T09:51:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/coa1.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\/tidak-bergabung\/\",\"url\":\"https:\/\/statorials.org\/id\/tidak-bergabung\/\",\"name\":\"Cara Menggunakan Fungsi COALESCE di SAS (Dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T09:51:07+00:00\",\"dateModified\":\"2023-07-21T09:51:07+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi COALESCE di SAS, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tidak-bergabung\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tidak-bergabung\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tidak-bergabung\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan fungsi coalesce 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 Fungsi COALESCE di SAS (Dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi COALESCE di SAS, dengan beberapa 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\/tidak-bergabung\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menggunakan Fungsi COALESCE di SAS (Dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi COALESCE di SAS, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/tidak-bergabung\/","og_site_name":"Statorials","article_published_time":"2023-07-21T09:51:07+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/coa1.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\/tidak-bergabung\/","url":"https:\/\/statorials.org\/id\/tidak-bergabung\/","name":"Cara Menggunakan Fungsi COALESCE di SAS (Dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T09:51:07+00:00","dateModified":"2023-07-21T09:51:07+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi COALESCE di SAS, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tidak-bergabung\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tidak-bergabung\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tidak-bergabung\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan fungsi coalesce 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\/2637"}],"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=2637"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2637\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}