{"id":4577,"date":"2023-07-09T23:45:28","date_gmt":"2023-07-09T23:45:28","guid":{"rendered":"https:\/\/statorials.org\/nl\/sas-proc-sql-bestellen-op\/"},"modified":"2023-07-09T23:45:28","modified_gmt":"2023-07-09T23:45:28","slug":"sas-proc-sql-bestellen-op","status":"publish","type":"post","link":"https:\/\/statorials.org\/nl\/sas-proc-sql-bestellen-op\/","title":{"rendered":"Sas: order by gebruiken in proc sql"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Je kunt de <b>ORDER BY-<\/b> instructie in <strong>PROC SQL<\/strong> in SAS gebruiken om de resultaten van een query te sorteren op basis van de waarden van een of meer variabelen.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hier zijn drie veelvoorkomende manieren om de <strong>ORDER BY-<\/strong> instructie in de praktijk te gebruiken:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Methode 1: Sorteer op een stijgende variabele<\/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>Methode 2: Sorteer op een afnemende variabele<\/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>Methode 3: Sorteer op meerdere variabelen<\/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;\">De volgende voorbeelden laten zien hoe u elke methode in de praktijk kunt gebruiken met de volgende gegevensset in SAS die informatie bevat over verschillende basketbalspelers:<\/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=\"auto, \"><\/p>\n<h2> <strong>Voorbeeld 1: <span style=\"color: #000000;\">Sorteer op een stijgende variabele<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">De volgende code laat zien hoe u elke rij in de gegevensset in oplopende volgorde retourneert op basis van de <strong>teamkolomwaarden<\/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=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Houd er rekening mee dat de resultaten in oplopende volgorde worden weergegeven op basis van de waarden in de kolom <strong>Team<\/strong> .<\/span><\/p>\n<h2> <strong>Voorbeeld 2: <span style=\"color: #000000;\">Sorteer op een afnemende variabele<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">De volgende code laat zien hoe u elke rij in de gegevensset in aflopende volgorde retourneert op basis van de <strong>teamkolomwaarden<\/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=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Houd er rekening mee dat de resultaten in aflopende volgorde worden weergegeven op basis van de waarden in de kolom <strong>Team<\/strong> .<\/span><\/p>\n<h2> <strong>Voorbeeld 3: <span style=\"color: #000000;\">Sorteer op verschillende variabelen<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">De volgende code laat zien hoe u elke rij in de gegevensset eerst in oplopende volgorde per <strong>team<\/strong> en vervolgens in aflopende volgorde op basis van <strong>punten<\/strong> kunt retourneren:<\/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=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Houd er rekening mee dat de resultaten eerst in oplopende volgorde per <strong>team<\/strong> worden weergegeven, en vervolgens in aflopende volgorde van <strong>punten<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Aanvullende bronnen<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">In de volgende zelfstudies wordt uitgelegd hoe u andere veelvoorkomende taken in SAS kunt uitvoeren:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/nl\/sas-proc-sql-unie\/\" target=\"_blank\" rel=\"noopener\">SAS: UNION gebruiken in PROC SQL<\/a><br \/> <a href=\"https:\/\/statorials.org\/nl\/sas-proc-sql-behalve\/\" target=\"_blank\" rel=\"noopener\">SAS: Hoe te gebruiken BEHALVE in PROC SQL<\/a><br \/> <a href=\"https:\/\/statorials.org\/nl\/sas-proc-sql-in\/\" target=\"_blank\" rel=\"noopener\">SAS: Hoe de IN-operator in PROC SQL te gebruiken<\/a><br \/> <a href=\"https:\/\/statorials.org\/nl\/sas-proc-sql-of\/\" target=\"_blank\" rel=\"noopener\">SAS: Hoe de WHERE-operator in PROC SQL te gebruiken<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Je kunt de ORDER BY- instructie in PROC SQL in SAS gebruiken om de resultaten van een query te sorteren op basis van de waarden van een of meer variabelen. Hier zijn drie veelvoorkomende manieren om de ORDER BY- instructie in de praktijk te gebruiken: Methode 1: Sorteer op een stijgende variabele \/*display results in [&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":[],"class_list":["post-4577","post","type-post","status-publish","format-standard","hentry","category-gids"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SAS: ORDER BY gebruiken in PROC SQL - Statorials<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie wordt uitgelegd hoe u de ORDER BY-instructie in PROC SQL in SAS gebruikt om de resultaten van een query te sorteren, met verschillende voorbeelden.\" \/>\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\/nl\/sas-proc-sql-bestellen-op\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS: ORDER BY gebruiken in PROC SQL - Statorials\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie wordt uitgelegd hoe u de ORDER BY-instructie in PROC SQL in SAS gebruikt om de resultaten van een query te sorteren, met verschillende voorbeelden.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/nl\/sas-proc-sql-bestellen-op\/\" \/>\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=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/nl\/sas-proc-sql-bestellen-op\/\",\"url\":\"https:\/\/statorials.org\/nl\/sas-proc-sql-bestellen-op\/\",\"name\":\"SAS: ORDER BY gebruiken in PROC SQL - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/nl\/#website\"},\"datePublished\":\"2023-07-09T23:45:28+00:00\",\"dateModified\":\"2023-07-09T23:45:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/nl\/#\/schema\/person\/d4b8842173cca1bb62cdec41860e4219\"},\"description\":\"In deze zelfstudie wordt uitgelegd hoe u de ORDER BY-instructie in PROC SQL in SAS gebruikt om de resultaten van een query te sorteren, met verschillende voorbeelden.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/nl\/sas-proc-sql-bestellen-op\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/nl\/sas-proc-sql-bestellen-op\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/nl\/sas-proc-sql-bestellen-op\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/statorials.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sas: order by gebruiken in proc sql\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/nl\/#website\",\"url\":\"https:\/\/statorials.org\/nl\/\",\"name\":\"Statorials\",\"description\":\"Uw gids voor statistische competentie\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/nl\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/nl\/#\/schema\/person\/d4b8842173cca1bb62cdec41860e4219\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/statorials.org\/nl\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/nl\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/nl\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Ik ben Benjamin, een gepensioneerde hoogleraar statistiek die nu een toegewijde Statorials-lesgever is. Ik heb uitgebreide ervaring en expertise op het gebied van statistiek en ik ben vastbesloten om mijn kennis te delen met studenten via Statorials. Lees verder\",\"sameAs\":[\"http:\/\/statorials.org\/nl\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAS: ORDER BY gebruiken in PROC SQL - Statorials","description":"In deze zelfstudie wordt uitgelegd hoe u de ORDER BY-instructie in PROC SQL in SAS gebruikt om de resultaten van een query te sorteren, met verschillende voorbeelden.","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\/nl\/sas-proc-sql-bestellen-op\/","og_locale":"de_DE","og_type":"article","og_title":"SAS: ORDER BY gebruiken in PROC SQL - Statorials","og_description":"In deze zelfstudie wordt uitgelegd hoe u de ORDER BY-instructie in PROC SQL in SAS gebruikt om de resultaten van een query te sorteren, met verschillende voorbeelden.","og_url":"https:\/\/statorials.org\/nl\/sas-proc-sql-bestellen-op\/","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":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"Dr.benjamin anderson","Gesch\u00e4tzte Lesezeit":"2\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/nl\/sas-proc-sql-bestellen-op\/","url":"https:\/\/statorials.org\/nl\/sas-proc-sql-bestellen-op\/","name":"SAS: ORDER BY gebruiken in PROC SQL - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/nl\/#website"},"datePublished":"2023-07-09T23:45:28+00:00","dateModified":"2023-07-09T23:45:28+00:00","author":{"@id":"https:\/\/statorials.org\/nl\/#\/schema\/person\/d4b8842173cca1bb62cdec41860e4219"},"description":"In deze zelfstudie wordt uitgelegd hoe u de ORDER BY-instructie in PROC SQL in SAS gebruikt om de resultaten van een query te sorteren, met verschillende voorbeelden.","breadcrumb":{"@id":"https:\/\/statorials.org\/nl\/sas-proc-sql-bestellen-op\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/nl\/sas-proc-sql-bestellen-op\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/nl\/sas-proc-sql-bestellen-op\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/statorials.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Sas: order by gebruiken in proc sql"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/nl\/#website","url":"https:\/\/statorials.org\/nl\/","name":"Statorials","description":"Uw gids voor statistische competentie","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/nl\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de"},{"@type":"Person","@id":"https:\/\/statorials.org\/nl\/#\/schema\/person\/d4b8842173cca1bb62cdec41860e4219","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/statorials.org\/nl\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/nl\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/nl\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Ik ben Benjamin, een gepensioneerde hoogleraar statistiek die nu een toegewijde Statorials-lesgever is. Ik heb uitgebreide ervaring en expertise op het gebied van statistiek en ik ben vastbesloten om mijn kennis te delen met studenten via Statorials. Lees verder","sameAs":["http:\/\/statorials.org\/nl"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/posts\/4577","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/comments?post=4577"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/posts\/4577\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/media?parent=4577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/categories?post=4577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/tags?post=4577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}