{"id":4576,"date":"2023-07-09T23:45:28","date_gmt":"2023-07-09T23:45:28","guid":{"rendered":"https:\/\/statorials.org\/pt\/sas-proc-sql-ordenar-por\/"},"modified":"2023-07-09T23:45:28","modified_gmt":"2023-07-09T23:45:28","slug":"sas-proc-sql-ordenar-por","status":"publish","type":"post","link":"https:\/\/statorials.org\/pt\/sas-proc-sql-ordenar-por\/","title":{"rendered":"Sas: como usar order by no proc sql"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Voc\u00ea pode usar a instru\u00e7\u00e3o <b>ORDER BY<\/b> no <strong>PROC SQL<\/strong> no SAS para classificar os resultados de uma consulta com base nos valores de uma ou mais vari\u00e1veis.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Aqui est\u00e3o tr\u00eas maneiras comuns de usar a instru\u00e7\u00e3o <strong>ORDER BY<\/strong> na pr\u00e1tica:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>M\u00e9todo 1: ordenar por uma vari\u00e1vel crescente<\/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>M\u00e9todo 2: ordenar por uma vari\u00e1vel decrescente<\/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>M\u00e9todo 3: ordenar por m\u00faltiplas vari\u00e1veis<\/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;\">Os exemplos a seguir mostram como usar cada m\u00e9todo na pr\u00e1tica com o seguinte conjunto de dados no SAS que cont\u00e9m informa\u00e7\u00f5es sobre v\u00e1rios jogadores de basquete:<\/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>Exemplo 1: <span style=\"color: #000000;\">Ordenar por uma vari\u00e1vel crescente<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">O c\u00f3digo a seguir mostra como retornar cada linha do conjunto de dados em ordem crescente com base nos valores da coluna <strong>da equipe<\/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;\">Observe que os resultados s\u00e3o exibidos em ordem crescente pelos valores da coluna <strong>Equipe<\/strong> .<\/span><\/p>\n<h2> <strong>Exemplo 2: <span style=\"color: #000000;\">Ordenar por uma vari\u00e1vel decrescente<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">O c\u00f3digo a seguir mostra como retornar cada linha do conjunto de dados em ordem decrescente com base nos valores da coluna <strong>da equipe<\/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;\">Observe que os resultados s\u00e3o exibidos em ordem decrescente com base nos valores da coluna <strong>Equipe<\/strong> .<\/span><\/p>\n<h2> <strong>Exemplo 3: <span style=\"color: #000000;\">Ordenar por diversas vari\u00e1veis<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">O c\u00f3digo a seguir mostra como retornar cada linha do conjunto de dados primeiro em ordem crescente por <strong>equipe<\/strong> e depois em ordem decrescente por <strong>pontos<\/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=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Observe que os resultados s\u00e3o exibidos primeiro em ordem crescente por <strong>equipe<\/strong> e depois em ordem decrescente por <strong>pontos<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Recursos adicionais<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Os tutoriais a seguir explicam como executar outras tarefas comuns no SAS:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/pt\/sas-proc-uniao-sql\/\" target=\"_blank\" rel=\"noopener\">SAS: Como usar UNION no PROC SQL<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/sas-proc-sql-exceto\/\" target=\"_blank\" rel=\"noopener\">SAS: Como usar EXCEPT no PROC SQL<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/sas-proc-sql-em\/\" target=\"_blank\" rel=\"noopener\">SAS: Como usar o operador IN no PROC SQL<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/sas-proc-sql-ou\/\" target=\"_blank\" rel=\"noopener\">SAS: Como usar o operador WHERE no PROC SQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Voc\u00ea pode usar a instru\u00e7\u00e3o ORDER BY no PROC SQL no SAS para classificar os resultados de uma consulta com base nos valores de uma ou mais vari\u00e1veis. Aqui est\u00e3o tr\u00eas maneiras comuns de usar a instru\u00e7\u00e3o ORDER BY na pr\u00e1tica: M\u00e9todo 1: ordenar por uma vari\u00e1vel crescente \/*display results in ascending order by value [&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-4576","post","type-post","status-publish","format-standard","hentry","category-guia"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SAS: Como usar ORDER BY em PROC SQL - Estatologia<\/title>\n<meta name=\"description\" content=\"Este tutorial explica como usar a instru\u00e7\u00e3o ORDER BY no PROC SQL no SAS para classificar os resultados de uma consulta, com v\u00e1rios exemplos.\" \/>\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\/pt\/sas-proc-sql-ordenar-por\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS: Como usar ORDER BY em PROC SQL - Estatologia\" \/>\n<meta property=\"og:description\" content=\"Este tutorial explica como usar a instru\u00e7\u00e3o ORDER BY no PROC SQL no SAS para classificar os resultados de uma consulta, com v\u00e1rios exemplos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pt\/sas-proc-sql-ordenar-por\/\" \/>\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. benjamim anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr. benjamim anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/pt\/sas-proc-sql-ordenar-por\/\",\"url\":\"https:\/\/statorials.org\/pt\/sas-proc-sql-ordenar-por\/\",\"name\":\"SAS: Como usar ORDER BY em PROC SQL - Estatologia\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pt\/#website\"},\"datePublished\":\"2023-07-09T23:45:28+00:00\",\"dateModified\":\"2023-07-09T23:45:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\"},\"description\":\"Este tutorial explica como usar a instru\u00e7\u00e3o ORDER BY no PROC SQL no SAS para classificar os resultados de uma consulta, com v\u00e1rios exemplos.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pt\/sas-proc-sql-ordenar-por\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pt\/sas-proc-sql-ordenar-por\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pt\/sas-proc-sql-ordenar-por\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/statorials.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sas: como usar order by no proc sql\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/pt\/#website\",\"url\":\"https:\/\/statorials.org\/pt\/\",\"name\":\"Statorials\",\"description\":\"O seu guia para a literacia estat\u00edstica!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/pt\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\",\"name\":\"Dr. benjamim anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr. benjamim anderson\"},\"description\":\"Ol\u00e1, sou Benjamin, um professor aposentado de estat\u00edstica que se tornou professor dedicado na Statorials. Com vasta experi\u00eancia e conhecimento na \u00e1rea de estat\u00edstica, estou empenhado em compartilhar meu conhecimento para capacitar os alunos por meio de Statorials. Saber mais\",\"sameAs\":[\"https:\/\/statorials.org\/pt\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAS: Como usar ORDER BY em PROC SQL - Estatologia","description":"Este tutorial explica como usar a instru\u00e7\u00e3o ORDER BY no PROC SQL no SAS para classificar os resultados de uma consulta, com v\u00e1rios exemplos.","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\/pt\/sas-proc-sql-ordenar-por\/","og_locale":"pt_PT","og_type":"article","og_title":"SAS: Como usar ORDER BY em PROC SQL - Estatologia","og_description":"Este tutorial explica como usar a instru\u00e7\u00e3o ORDER BY no PROC SQL no SAS para classificar os resultados de uma consulta, com v\u00e1rios exemplos.","og_url":"https:\/\/statorials.org\/pt\/sas-proc-sql-ordenar-por\/","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. benjamim anderson","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dr. benjamim anderson","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/pt\/sas-proc-sql-ordenar-por\/","url":"https:\/\/statorials.org\/pt\/sas-proc-sql-ordenar-por\/","name":"SAS: Como usar ORDER BY em PROC SQL - Estatologia","isPartOf":{"@id":"https:\/\/statorials.org\/pt\/#website"},"datePublished":"2023-07-09T23:45:28+00:00","dateModified":"2023-07-09T23:45:28+00:00","author":{"@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666"},"description":"Este tutorial explica como usar a instru\u00e7\u00e3o ORDER BY no PROC SQL no SAS para classificar os resultados de uma consulta, com v\u00e1rios exemplos.","breadcrumb":{"@id":"https:\/\/statorials.org\/pt\/sas-proc-sql-ordenar-por\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pt\/sas-proc-sql-ordenar-por\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pt\/sas-proc-sql-ordenar-por\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/statorials.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Sas: como usar order by no proc sql"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/pt\/#website","url":"https:\/\/statorials.org\/pt\/","name":"Statorials","description":"O seu guia para a literacia estat\u00edstica!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/pt\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666","name":"Dr. benjamim anderson","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr. benjamim anderson"},"description":"Ol\u00e1, sou Benjamin, um professor aposentado de estat\u00edstica que se tornou professor dedicado na Statorials. Com vasta experi\u00eancia e conhecimento na \u00e1rea de estat\u00edstica, estou empenhado em compartilhar meu conhecimento para capacitar os alunos por meio de Statorials. Saber mais","sameAs":["https:\/\/statorials.org\/pt"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/4576","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/comments?post=4576"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/4576\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/media?parent=4576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/categories?post=4576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/tags?post=4576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}