{"id":4575,"date":"2023-07-09T23:45:28","date_gmt":"2023-07-09T23:45:28","guid":{"rendered":"https:\/\/statorials.org\/id\/sas-proc-sql-dipesan-oleh\/"},"modified":"2023-07-09T23:45:28","modified_gmt":"2023-07-09T23:45:28","slug":"sas-proc-sql-dipesan-oleh","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sas-proc-sql-dipesan-oleh\/","title":{"rendered":"Sas: cara menggunakan order by di proc sql"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan pernyataan <b>ORDER BY<\/b> di <strong>PROC SQL<\/strong> di SAS untuk mengurutkan hasil kueri berdasarkan nilai satu atau lebih variabel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut adalah tiga cara umum untuk menggunakan pernyataan <strong>ORDER BY<\/strong> dalam praktiknya:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Urutkan berdasarkan variabel yang meningkat<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\"><span style=\"color: #008000;\">\/*display results in ascending order by value in team column*\/<\/span>\nproc sql<\/span> <span style=\"color: #000000;\">;\n   <\/span><span style=\"color: #3366ff;\">select<\/span> <span style=\"color: #000000;\">*\n   <\/span><span style=\"color: #3366ff;\">from<\/span> <span style=\"color: #000000;\">my_data\n   <\/span><span style=\"color: #3366ff;\">order by<\/span> <span style=\"color: #000000;\">team<\/span> <span style=\"color: #000000;\">;\n<\/span><span style=\"color: #800080;\">quit<\/span> <span style=\"color: #000000;\">;<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Urutkan berdasarkan variabel menurun<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\"><span style=\"color: #008000;\">\/*display results in descending order by value in team column*\/<\/span>\nproc sql<\/span> ;\n   <span style=\"color: #3366ff;\">select<\/span> *\n   <span style=\"color: #3366ff;\">from<\/span> my_data\n   <span style=\"color: #3366ff;\">order by<\/span> team <span style=\"color: #3366ff;\">desc<\/span> ;\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: Urutkan berdasarkan beberapa variabel<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\"><span style=\"color: #008000;\">\/*display results in ascending order by team, then descending order by points*\/<\/span>\nproc sql<\/span> ;\n   <span style=\"color: #3366ff;\">select<\/span> *\n   <span style=\"color: #3366ff;\">from<\/span> my_data\n   <span style=\"color: #3366ff;\">order by<\/span> team, points <span style=\"color: #3366ff;\">desc<\/span> ;\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dalam praktik dengan kumpulan data berikut di SAS yang berisi informasi tentang berbagai pemain 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;\">data<\/span> my_data;\n    <span style=\"color: #3366ff;\">input<\/span> team $position $points assists;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\nA Guard 14 4\nB Guard 22 6\nB Guard 24 9\nA Forward 13 8\nC Forward 13 9\nA Guard 10 5\nB Guard 24 4\nC Guard 22 6\nD Forward 34 2\nD Forward 15 5\nB Forward 23 5\nB Guard 10 4\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> =my_data;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35716 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/commande-par1.png\" alt=\"\" width=\"306\" height=\"349\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <strong>Contoh 1: <span style=\"color: #000000;\">Urutkan berdasarkan variabel yang meningkat<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengembalikan setiap baris dalam kumpulan data dalam urutan menaik berdasarkan nilai kolom <strong>tim<\/strong> :<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\"><span style=\"color: #008000;\">\/*display results in ascending order by value in team column*\/<\/span>\nproc sql<\/span> ;\n   <span style=\"color: #3366ff;\">select<\/span> *\n   <span style=\"color: #3366ff;\">from<\/span> my_data\n   <span style=\"color: #3366ff;\">order by<\/span> team;\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35717 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/commande-par2.png\" alt=\"\" width=\"260\" height=\"357\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hasilnya ditampilkan dalam urutan menaik berdasarkan nilai di kolom <strong>Tim<\/strong> .<\/span><\/p>\n<h2> <strong>Contoh 2: <span style=\"color: #000000;\">Diurutkan berdasarkan variabel menurun<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengembalikan setiap baris dalam kumpulan data dalam urutan menurun berdasarkan nilai kolom <strong>tim<\/strong> :<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\"><span style=\"color: #008000;\">\/*display results in descending order by value in team column*\/<\/span>\nproc sql<\/span> ;\n   <span style=\"color: #3366ff;\">select<\/span> *\n   <span style=\"color: #3366ff;\">from<\/span> my_data\n   <span style=\"color: #3366ff;\">order by<\/span> team <span style=\"color: #3366ff;\">desc<\/span> ;\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35718 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/commande-par3.png\" alt=\"\" width=\"261\" height=\"365\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hasilnya ditampilkan dalam urutan menurun berdasarkan nilai di kolom <strong>Tim<\/strong> .<\/span><\/p>\n<h2> <strong>Contoh 3: <span style=\"color: #000000;\">Diurutkan berdasarkan beberapa variabel<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengembalikan setiap baris dalam kumpulan data terlebih dahulu dalam urutan menaik berdasarkan <strong>tim<\/strong> dan kemudian dalam urutan menurun berdasarkan <strong>poin<\/strong> :<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\"><span style=\"color: #008000;\">\/*display results in ascending order by team, then descending order by points*\/<\/span>\nproc sql<\/span> ;\n   <span style=\"color: #3366ff;\">select<\/span> *\n   <span style=\"color: #3366ff;\">from<\/span> my_data\n   <span style=\"color: #3366ff;\">order by<\/span> team, points <span style=\"color: #3366ff;\">desc<\/span> ;\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35719 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/commande-par4.png\" alt=\"\" width=\"247\" height=\"340\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hasil ditampilkan terlebih dahulu dalam urutan menaik berdasarkan <strong>tim<\/strong> , kemudian dalam urutan menurun berdasarkan <strong>poin<\/strong> .<\/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-serikat-sql\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan UNION di PROC SQL<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sas-proc-sql-kecuali\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan KECUALI di PROC SQL<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sas-proc-sql-masuk\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan operator IN di PROC SQL<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sas-proc-sql-atau\/\" target=\"_blank\" rel=\"noopener\">SAS: Cara menggunakan operator WHERE di PROC SQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan pernyataan ORDER BY di PROC SQL di SAS untuk mengurutkan hasil kueri berdasarkan nilai satu atau lebih variabel. Berikut adalah tiga cara umum untuk menggunakan pernyataan ORDER BY dalam praktiknya: Metode 1: Urutkan berdasarkan variabel yang meningkat \/*display results in ascending order by value in team column*\/ proc sql ; select * [&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 ORDER BY di PROC SQL - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan pernyataan ORDER BY di PROC SQL di SAS untuk mengurutkan hasil kueri, 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-dipesan-oleh\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS: Cara menggunakan ORDER BY di PROC SQL - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan pernyataan ORDER BY di PROC SQL di SAS untuk mengurutkan hasil kueri, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sas-proc-sql-dipesan-oleh\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T23:45:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/commande-par1.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=\"2 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-dipesan-oleh\/\",\"url\":\"https:\/\/statorials.org\/id\/sas-proc-sql-dipesan-oleh\/\",\"name\":\"SAS: Cara menggunakan ORDER BY di PROC SQL - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T23:45:28+00:00\",\"dateModified\":\"2023-07-09T23:45:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan pernyataan ORDER BY di PROC SQL di SAS untuk mengurutkan hasil kueri, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-dipesan-oleh\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sas-proc-sql-dipesan-oleh\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sas-proc-sql-dipesan-oleh\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sas: cara menggunakan order by 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 ORDER BY di PROC SQL - Statologi","description":"Tutorial ini menjelaskan cara menggunakan pernyataan ORDER BY di PROC SQL di SAS untuk mengurutkan hasil kueri, 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-dipesan-oleh\/","og_locale":"id_ID","og_type":"article","og_title":"SAS: Cara menggunakan ORDER BY di PROC SQL - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan pernyataan ORDER BY di PROC SQL di SAS untuk mengurutkan hasil kueri, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/sas-proc-sql-dipesan-oleh\/","og_site_name":"Statorials","article_published_time":"2023-07-09T23:45:28+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/commande-par1.png"}],"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\/sas-proc-sql-dipesan-oleh\/","url":"https:\/\/statorials.org\/id\/sas-proc-sql-dipesan-oleh\/","name":"SAS: Cara menggunakan ORDER BY di PROC SQL - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T23:45:28+00:00","dateModified":"2023-07-09T23:45:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan pernyataan ORDER BY di PROC SQL di SAS untuk mengurutkan hasil kueri, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sas-proc-sql-dipesan-oleh\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sas-proc-sql-dipesan-oleh\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sas-proc-sql-dipesan-oleh\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Sas: cara menggunakan order by 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\/4575"}],"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=4575"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4575\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4575"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}