{"id":3895,"date":"2023-07-14T22:11:53","date_gmt":"2023-07-14T22:11:53","guid":{"rendered":"https:\/\/statorials.org\/id\/sas-proc-sortir-nodupkey\/"},"modified":"2023-07-14T22:11:53","modified_gmt":"2023-07-14T22:11:53","slug":"sas-proc-sortir-nodupkey","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sas-proc-sortir-nodupkey\/","title":{"rendered":"Sas: cara menggunakan proc sort dengan nodupkey"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan <strong>PROC SORT<\/strong> di SAS dengan <strong>NODUPKEY<\/strong> untuk mengurutkan pengamatan dalam kumpulan data berdasarkan satu atau lebih variabel dan menghapus duplikat apa pun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan prosedur ini dengan kumpulan data berikut di SAS:<\/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> original_data;\n    <span style=\"color: #3366ff;\">input<\/span> team $pointsrebounds;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\nAt 12 8\nAt 12 8\nAt 12 8\nAt 23 9\nAt 20 12\nAt 14 7\nAt 14 7\nB 20 2\nB 20 5\nB 29 4\nB 14 7\nB 20 2\nB 20 2\nB 20 5\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;\n<\/strong><\/span><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31374 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trier1.jpg\" alt=\"\" width=\"224\" height=\"376\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menggunakan PROC SORT dengan NODUPKEY di SAS<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita cukup menggunakan <strong>proc sort<\/strong> untuk mengurutkan pengamatan dalam kumpulan data dalam urutan menaik (terkecil hingga terbesar) berdasarkan nilai di kolom <strong>poin<\/strong> :<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*sort by points ascending*\/\n<\/span><span style=\"color: #800080;\">proc sort<\/span> <span style=\"color: #3366ff;\">data<\/span> =original_data <span style=\"color: #3366ff;\">out<\/span> =data2;\n    <span style=\"color: #3366ff;\">by<\/span> points;\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view sorted dataset*\/\n<\/span><span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> =data2;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31375 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trier2.jpg\" alt=\"\" width=\"249\" height=\"398\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa observasi diurutkan dalam urutan menaik berdasarkan nilai di kolom <strong>poin<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, beberapa observasi merupakan duplikat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengurutkan pengamatan berdasarkan nilai di kolom <strong>poin<\/strong> dan menghapus semua duplikat, kita dapat menambahkan <strong>nodupkey<\/strong> setelah pernyataan <strong>proc sort<\/strong> :<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*sort by points ascending and remove duplicates*\/\n<\/span><span style=\"color: #800080;\">proc sort<\/span> <span style=\"color: #3366ff;\">data<\/span> =original_data <span style=\"color: #3366ff;\">out<\/span> =data3 <span style=\"color: #3366ff;\">nodupkey<\/span> ;\n    <span style=\"color: #3366ff;\">by<\/span> points;\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view sorted dataset*\/\n<\/span><span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> =data3;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31376 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trier3.jpg\" alt=\"\" width=\"254\" height=\"171\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pengamatan sekarang diurutkan dalam urutan menaik berdasarkan nilai di kolom <strong>poin<\/strong> dan setiap pengamatan duplikat telah dihapus.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita juga dapat menambahkan argumen <strong>menurun<\/strong> untuk mengurutkan observasi berdasarkan nilai di kolom <strong>poin<\/strong> dalam urutan menurun dan menghapus semua duplikat:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*sort by points descending and removing duplicates*\/\n<\/span><span style=\"color: #800080;\">proc sort<\/span> <span style=\"color: #3366ff;\">data<\/span> =original_data <span style=\"color: #3366ff;\">out<\/span> =data4 <span style=\"color: #3366ff;\">nodupkey<\/span> ;\n    <span style=\"color: #3366ff;\">by<\/span> <span style=\"color: #3366ff;\">descending<\/span> points;\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view sorted dataset*\/\n<\/span><span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> =data4;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31377 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trier4.jpg\" alt=\"\" width=\"239\" height=\"166\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pengamatan sekarang diurutkan dalam urutan menurun berdasarkan nilai di kolom <strong>poin<\/strong> dan semua pengamatan duplikat telah dihapus.<\/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-menambahkan\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan Proc Append di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/proc-tabulasi-sas\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan Proc Tabulate di SAS<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sas-peringkat-proc\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan pemeriksaan Proc di SAS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan PROC SORT di SAS dengan NODUPKEY untuk mengurutkan pengamatan dalam kumpulan data berdasarkan satu atau lebih variabel dan menghapus duplikat apa pun. Contoh berikut menunjukkan cara menggunakan prosedur ini dengan kumpulan data berikut di SAS: \/*create dataset*\/ data original_data; input team $pointsrebounds; datalines ; At 12 8 At 12 8 At 12 [&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 PROC SORT dengan NODUPKEY - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan PROC SORT di SAS dengan NODUPKEY untuk mengurutkan observasi dalam kumpulan data dan menghapus duplikat.\" \/>\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-sortir-nodupkey\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS: Cara menggunakan PROC SORT dengan NODUPKEY - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan PROC SORT di SAS dengan NODUPKEY untuk mengurutkan observasi dalam kumpulan data dan menghapus duplikat.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sas-proc-sortir-nodupkey\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T22:11:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trier1.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-proc-sortir-nodupkey\/\",\"url\":\"https:\/\/statorials.org\/id\/sas-proc-sortir-nodupkey\/\",\"name\":\"SAS: Cara menggunakan PROC SORT dengan NODUPKEY - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T22:11:53+00:00\",\"dateModified\":\"2023-07-14T22:11:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan PROC SORT di SAS dengan NODUPKEY untuk mengurutkan observasi dalam kumpulan data dan menghapus duplikat.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sortir-nodupkey\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sas-proc-sortir-nodupkey\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sortir-nodupkey\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sas: cara menggunakan proc sort dengan nodupkey\"}]},{\"@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 PROC SORT dengan NODUPKEY - Statologi","description":"Tutorial ini menjelaskan cara menggunakan PROC SORT di SAS dengan NODUPKEY untuk mengurutkan observasi dalam kumpulan data dan menghapus duplikat.","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-sortir-nodupkey\/","og_locale":"id_ID","og_type":"article","og_title":"SAS: Cara menggunakan PROC SORT dengan NODUPKEY - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan PROC SORT di SAS dengan NODUPKEY untuk mengurutkan observasi dalam kumpulan data dan menghapus duplikat.","og_url":"https:\/\/statorials.org\/id\/sas-proc-sortir-nodupkey\/","og_site_name":"Statorials","article_published_time":"2023-07-14T22:11:53+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/trier1.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-proc-sortir-nodupkey\/","url":"https:\/\/statorials.org\/id\/sas-proc-sortir-nodupkey\/","name":"SAS: Cara menggunakan PROC SORT dengan NODUPKEY - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T22:11:53+00:00","dateModified":"2023-07-14T22:11:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan PROC SORT di SAS dengan NODUPKEY untuk mengurutkan observasi dalam kumpulan data dan menghapus duplikat.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sas-proc-sortir-nodupkey\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sas-proc-sortir-nodupkey\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sas-proc-sortir-nodupkey\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Sas: cara menggunakan proc sort dengan nodupkey"}]},{"@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\/3895"}],"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=3895"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3895\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}