{"id":2554,"date":"2023-07-21T18:30:31","date_gmt":"2023-07-21T18:30:31","guid":{"rendered":"https:\/\/statorials.org\/id\/jangan-hapus-duplikat\/"},"modified":"2023-07-21T18:30:31","modified_gmt":"2023-07-21T18:30:31","slug":"jangan-hapus-duplikat","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jangan-hapus-duplikat\/","title":{"rendered":"Cara menghapus duplikat di sas (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan proc sort<\/strong> di SAS untuk menghapus baris duplikat dengan cepat dari kumpulan data.<\/span><\/p>\n

Prosedur ini menggunakan sintaks dasar berikut:<\/span><\/p>\n

 proc sort<\/span> data<\/span> =original_data out<\/span> =no_dups_data nodupkey<\/span> ;\n<\/span>by<\/span> _all_;<\/span><\/span>\nrun;\n<\/span><\/span><\/strong><\/pre>\n
 Perhatikan bahwa argumen by<\/strong> menentukan kolom mana yang akan dipindai saat menghapus duplikat.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menghapus duplikat dari kumpulan data berikut di SAS:<\/span> <\/p>\n
 \/*create dataset*\/\n<\/span>data<\/span> original_data;\n    input<\/span> team $position $points;\n    datalines<\/span> ;\nA Guard 12\nA Guard 20\nA Guard 20\nA Guard 24\nA Forward 15\nA Forward 15\nA Forward 19\nA Forward 28\nB Guard 10\nB Guard 12\nB Guard 12\nB Guard 26\nB Forward 10\nB Forward 10\nB Forward 10\nB Forward 19\n;\nrun<\/span> ;\n\n\/*view dataset*\/\n<\/span>proc print<\/span> data<\/span> = original_data;<\/span><\/span><\/strong> <\/pre>\n
\"\"<\/p>\n
 Contoh 1: Hapus duplikat dari semua kolom<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan kode berikut untuk menghapus baris yang memiliki nilai duplikat di semua kolom pada dataset:<\/span> <\/p>\n
 \/*create dataset with no duplicate rows*\/\n<\/span>proc sort data<\/span> =original_data out<\/span> =no_dups_data nodupkey<\/span> ;\n    by<\/span> _all_;\nrun<\/span> ;\n\n\/*view dataset with no duplicate rows*\/\n<\/span>proc print<\/span> data<\/span> =no_dups_data;<\/span><\/span><\/strong><\/span> <\/pre>\n
\"\"<\/p>\n
 Perhatikan bahwa total lima baris duplikat telah dihapus dari kumpulan data asli.<\/span><\/p>\n
 Contoh 2:<\/strong><\/span> Hapus duplikat dari kolom tertentu<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan argumen by<\/strong> untuk menentukan kolom mana yang akan diperiksa saat menghapus duplikat.<\/span><\/p>\n
 Misalnya, kode berikut menghapus baris dengan nilai duplikat di kolom tim<\/strong> dan posisi<\/strong> :<\/span> <\/p>\n
 \/*create dataset with no duplicate rows in team and position columns*\/\n<\/span>proc sort<\/span> data<\/span> =original_data out<\/span> =no_dups_data nodupkey<\/span> ;\n    by<\/span> team position;\nrun<\/span> ;\n\n\/*view dataset with no duplicate rows in team and position columns*\/\n<\/span>proc print<\/span> data<\/span> =no_dups_data;<\/span><\/span><\/strong><\/span> <\/pre>\n
\"\"<\/p>\n
 Hanya empat baris yang tersisa di kumpulan data setelah menghapus baris dengan nilai duplikat di kolom tim<\/strong> dan posisi<\/strong> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di SAS:<\/span><\/p>\n
 Cara menormalkan data di SAS<\/a>
 Cara mengidentifikasi outlier di SAS<\/a>
 Cara menggunakan ringkasan prosedur di SAS<\/a>
 Cara membuat tabel frekuensi di SAS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan proc sort di SAS untuk menghapus baris duplikat dengan cepat dari kumpulan data. Prosedur ini menggunakan sintaks dasar berikut: proc sort data =original_data out =no_dups_data nodupkey ; by _all_; run; Perhatikan bahwa argumen by menentukan kolom mana yang akan dipindai saat menghapus duplikat. Contoh berikut menunjukkan cara menghapus duplikat dari kumpulan data […]<\/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":"\nCara Menghapus Duplikat di SAS (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus duplikat 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\/jangan-hapus-duplikat\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghapus Duplikat di SAS (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus duplikat di SAS, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jangan-hapus-duplikat\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T18:30:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dups1.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\/jangan-hapus-duplikat\/\",\"url\":\"https:\/\/statorials.org\/id\/jangan-hapus-duplikat\/\",\"name\":\"Cara Menghapus Duplikat di SAS (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T18:30:31+00:00\",\"dateModified\":\"2023-07-21T18:30:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus duplikat di SAS, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jangan-hapus-duplikat\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jangan-hapus-duplikat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jangan-hapus-duplikat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus duplikat 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 Menghapus Duplikat di SAS (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghapus duplikat 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\/jangan-hapus-duplikat\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghapus Duplikat di SAS (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghapus duplikat di SAS, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/jangan-hapus-duplikat\/","og_site_name":"Statorials","article_published_time":"2023-07-21T18:30:31+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dups1.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\/jangan-hapus-duplikat\/","url":"https:\/\/statorials.org\/id\/jangan-hapus-duplikat\/","name":"Cara Menghapus Duplikat di SAS (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T18:30:31+00:00","dateModified":"2023-07-21T18:30:31+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus duplikat di SAS, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jangan-hapus-duplikat\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jangan-hapus-duplikat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jangan-hapus-duplikat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus duplikat 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\/2554"}],"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=2554"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2554\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}