{"id":4223,"date":"2023-07-12T17:47:26","date_gmt":"2023-07-12T17:47:26","guid":{"rendered":"https:\/\/statorials.org\/id\/sas-menghapus-baris-dengan-nilai-yang-hilang\/"},"modified":"2023-07-12T17:47:26","modified_gmt":"2023-07-12T17:47:26","slug":"sas-menghapus-baris-dengan-nilai-yang-hilang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sas-menghapus-baris-dengan-nilai-yang-hilang\/","title":{"rendered":"Cara menghapus baris dengan nilai yang hilang di sas"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menghapus baris dengan nilai yang hilang dari kumpulan data di SAS:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\">data<\/span> new_data;\n    <span style=\"color: #3366ff;\">set<\/span> my_data;\n    <span style=\"color: #3366ff;\">if<\/span> cmiss(of _all_) <span style=\"color: #3366ff;\">then<\/span> delete;\n<span style=\"color: #800080;\">run<\/span> ;\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini membuat kumpulan data baru bernama <strong>new_data<\/strong> yang semua baris dengan nilai yang hilang di kumpulan data asli bernama <strong>my_data<\/strong> telah dihapus.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Hapus baris dengan nilai yang hilang di SAS<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di SAS yang berisi informasi tentang berbagai tim 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;\"><span style=\"color: #000000;\"><span style=\"color: #800080;\">data<\/span> my_data;\n    <span style=\"color: #3366ff;\">input<\/span> team $points assists;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\nMavs 113 22\nPacers 95.\nCavs. .\nLakers 114 20\nHeat 123 39\nKings. 22\nRaptors 105 11\nHawks 95 25\nMagic 103 26\nSpurs 119.\n;\n<span style=\"color: #800080;\">run<\/span> ;<\/span>\n\n<span style=\"color: #008000;\">\/*view dataset*\/\n<\/span><span style=\"color: #000000;\"><span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> =my_data;<\/span><\/span><\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33410 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cmmiss1.jpg\" alt=\"\" width=\"225\" height=\"279\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa ada beberapa baris dengan nilai yang hilang.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk membuat kumpulan data baru di mana kita menghapus semua baris dari kumpulan data yang ada yang memiliki nilai yang hilang di kolom:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">\/*create new dataset that removes rows with missing values from existing dataset*\/\n<span style=\"color: #000000;\"><span style=\"color: #800080;\">data<\/span> new_data;\n    <span style=\"color: #3366ff;\">set<\/span> my_data;\n    <span style=\"color: #3366ff;\">if<\/span> cmiss(of _all_) <span style=\"color: #3366ff;\">then<\/span> delete;\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;\n<\/span><\/span><\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-33411 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cmmiss2.jpg\" alt=\"\" width=\"242\" height=\"191\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita dapat melihat bahwa semua baris dengan nilai yang hilang telah dihapus dari kumpulan data.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan #1<\/strong> : Argumen <strong>_all_<\/strong> dalam fungsi <strong>CMISS<\/strong> menetapkan bahwa SAS harus mencari nilai yang hilang di <em>semua<\/em> kolom di setiap baris.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan #2<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <strong>CMISS<\/strong> <a href=\"https:\/\/documentation.sas.com\/doc\/en\/pgmsascdc\/9.4_3.2\/lefunctionsref\/p1tth4ltf640din1ey86ubo2lky2.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> <a href=\"https:\/\/statorials.org\/id\/jangan-hapus-duplikat\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus duplikat di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sas-menghitung-nilai-yang-hilang\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung nilai yang hilang 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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menghapus baris dengan nilai yang hilang dari kumpulan data di SAS: data new_data; set my_data; if cmiss(of _all_) then delete; run ; Contoh khusus ini membuat kumpulan data baru bernama new_data yang semua baris dengan nilai yang hilang di kumpulan data asli bernama my_data telah dihapus. Contoh berikut [&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 menghapus baris dengan nilai yang hilang di SAS - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus baris dengan nilai yang hilang 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-menghapus-baris-dengan-nilai-yang-hilang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghapus baris dengan nilai yang hilang di SAS - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus baris dengan nilai yang hilang di SAS, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sas-menghapus-baris-dengan-nilai-yang-hilang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T17:47:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cmmiss1.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\/sas-menghapus-baris-dengan-nilai-yang-hilang\/\",\"url\":\"https:\/\/statorials.org\/id\/sas-menghapus-baris-dengan-nilai-yang-hilang\/\",\"name\":\"Cara menghapus baris dengan nilai yang hilang di SAS - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T17:47:26+00:00\",\"dateModified\":\"2023-07-12T17:47:26+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus baris dengan nilai yang hilang di SAS, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sas-menghapus-baris-dengan-nilai-yang-hilang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sas-menghapus-baris-dengan-nilai-yang-hilang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sas-menghapus-baris-dengan-nilai-yang-hilang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus baris dengan nilai yang hilang di sas\"}]},{\"@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 menghapus baris dengan nilai yang hilang di SAS - Statorials","description":"Tutorial ini menjelaskan cara menghapus baris dengan nilai yang hilang 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-menghapus-baris-dengan-nilai-yang-hilang\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghapus baris dengan nilai yang hilang di SAS - Statorials","og_description":"Tutorial ini menjelaskan cara menghapus baris dengan nilai yang hilang di SAS, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/sas-menghapus-baris-dengan-nilai-yang-hilang\/","og_site_name":"Statorials","article_published_time":"2023-07-12T17:47:26+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cmmiss1.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\/sas-menghapus-baris-dengan-nilai-yang-hilang\/","url":"https:\/\/statorials.org\/id\/sas-menghapus-baris-dengan-nilai-yang-hilang\/","name":"Cara menghapus baris dengan nilai yang hilang di SAS - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T17:47:26+00:00","dateModified":"2023-07-12T17:47:26+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus baris dengan nilai yang hilang di SAS, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sas-menghapus-baris-dengan-nilai-yang-hilang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sas-menghapus-baris-dengan-nilai-yang-hilang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sas-menghapus-baris-dengan-nilai-yang-hilang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus baris dengan nilai yang hilang di sas"}]},{"@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\/4223"}],"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=4223"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4223\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}