{"id":4598,"date":"2023-07-09T18:39:44","date_gmt":"2023-07-09T18:39:44","guid":{"rendered":"https:\/\/statorials.org\/id\/sas-proc-sql-pilih-berbeda\/"},"modified":"2023-07-09T18:39:44","modified_gmt":"2023-07-09T18:39:44","slug":"sas-proc-sql-pilih-berbeda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sas-proc-sql-pilih-berbeda\/","title":{"rendered":"Sas: cara menggunakan select distinct di proc sql"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan pernyataan SELECT DISTINCT<\/b> di PROC SQL<\/strong> di SAS untuk memilih hanya baris unik dalam kumpulan data.<\/span><\/p>\n

Contoh berikut menunjukkan bagaimana menggunakan pernyataan ini dalam praktik.<\/span><\/p>\n

Contoh: Menggunakan SELECT DISTINCT di SAS<\/strong><\/h2>\n

Misalkan kita memiliki kumpulan data berikut di SAS yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n

 \/*create dataset*\/\n<\/span>data<\/span> my_data;\n    input<\/span> team $position $points;\n    datalines<\/span> ;\nA Guard 14\nA Guard 14\nA Guard 24\nA Forward 13\nA Forward 13\nB Guard 22\nB Guard 22\nB Forward 34\nC Forward 15\nC Forward 18\n;\nrun<\/span> ;\n\n\/*view dataset*\/\n<\/span>proc print<\/span> data<\/span> =my_data;\n<\/strong><\/span><\/pre>\n
\"\"<\/p>\n
 Kita dapat menggunakan pernyataan SELECT DISTINCT<\/b> di PROC SQL<\/strong> untuk memilih semua baris unik dalam kumpulan data:<\/span> <\/p>\n
 \/*select all unique rows*\/\n<\/span>proc sql<\/span> ;\n    select distinct<\/span> *\nfrom<\/span> my_data;\nquit<\/span> ;<\/strong><\/span> <\/pre>\n
\"\"<\/p>\n
 Catatan<\/strong> : Simbol bintang ( *<\/strong> ) setelah SELECT DISTINCT<\/strong> memberitahu SAS untuk memilih semua<\/em> kolom dalam dataset.<\/span><\/p>\n
 Perhatikan bahwa semua baris unik ditampilkan di output.<\/span><\/p>\n
 Misalnya, beberapa baris memiliki nilai tim A<\/strong> , nilai posisi Forward<\/strong> , dan nilai poin 13<\/strong> , namun hanya satu dari baris tersebut yang ditampilkan.<\/span><\/p>\n
 Perhatikan bahwa kita juga dapat menentukan kolom mana yang ingin kita pilih:<\/span> <\/p>\n
 \/*select all unique combinations of team and position*\/\n<\/span>proc sql<\/span> ;\n    select distinct<\/span> team, position\nfrom<\/span> my_data;\nquit<\/span> ;<\/strong><\/span> <\/pre>\n
\"\"<\/p>\n
 Perhatikan bahwa hanya kombinasi unik dari pergeseran dan posisi yang ditampilkan dalam hasil.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di SAS:<\/span><\/p>\n
 SAS: Cara menggunakan ORDER BY di PROC SQL<\/a>
 SAS: Cara menggunakan CONTAIN dalam PROC SQL<\/a>
 SAS: Cara menggunakan operator WHERE di PROC SQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan pernyataan SELECT DISTINCT di PROC SQL di SAS untuk memilih hanya baris unik dalam kumpulan data. Contoh berikut menunjukkan bagaimana menggunakan pernyataan ini dalam praktik. Contoh: Menggunakan SELECT DISTINCT di SAS Misalkan kita memiliki kumpulan data berikut di SAS yang berisi informasi tentang berbagai pemain bola basket: \/*create dataset*\/ data my_data; input […]<\/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":"\nSAS: Cara menggunakan SELECT DISTINCT di PROC SQL - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan SELECT DISTINCT di PROC SQL 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\/sas-proc-sql-pilih-berbeda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS: Cara menggunakan SELECT DISTINCT di PROC SQL - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan SELECT DISTINCT di PROC SQL di SAS, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sas-proc-sql-pilih-berbeda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T18:39:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/distinct11.png\" \/>\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-sql-pilih-berbeda\/\",\"url\":\"https:\/\/statorials.org\/id\/sas-proc-sql-pilih-berbeda\/\",\"name\":\"SAS: Cara menggunakan SELECT DISTINCT di PROC SQL - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T18:39:44+00:00\",\"dateModified\":\"2023-07-09T18:39:44+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan SELECT DISTINCT di PROC SQL di SAS, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-pilih-berbeda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sas-proc-sql-pilih-berbeda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-pilih-berbeda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sas: cara menggunakan select distinct 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 SELECT DISTINCT di PROC SQL - Statologi","description":"Tutorial ini menjelaskan cara menggunakan SELECT DISTINCT di PROC SQL 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\/sas-proc-sql-pilih-berbeda\/","og_locale":"id_ID","og_type":"article","og_title":"SAS: Cara menggunakan SELECT DISTINCT di PROC SQL - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan SELECT DISTINCT di PROC SQL di SAS, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/sas-proc-sql-pilih-berbeda\/","og_site_name":"Statorials","article_published_time":"2023-07-09T18:39:44+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/distinct11.png"}],"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-sql-pilih-berbeda\/","url":"https:\/\/statorials.org\/id\/sas-proc-sql-pilih-berbeda\/","name":"SAS: Cara menggunakan SELECT DISTINCT di PROC SQL - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T18:39:44+00:00","dateModified":"2023-07-09T18:39:44+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan SELECT DISTINCT di PROC SQL di SAS, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sas-proc-sql-pilih-berbeda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sas-proc-sql-pilih-berbeda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sas-proc-sql-pilih-berbeda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Sas: cara menggunakan select distinct 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\/4598"}],"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=4598"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4598\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4598"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4598"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}