{"id":4578,"date":"2023-07-09T23:45:28","date_gmt":"2023-07-09T23:45:28","guid":{"rendered":"https:\/\/statorials.org\/it\/sas-proc-sql-ordina-per\/"},"modified":"2023-07-09T23:45:28","modified_gmt":"2023-07-09T23:45:28","slug":"sas-proc-sql-ordina-per","status":"publish","type":"post","link":"https:\/\/statorials.org\/it\/sas-proc-sql-ordina-per\/","title":{"rendered":"Sas: come utilizzare order by in proc sql"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">\u00c8 possibile utilizzare l&#8217;istruzione <b>ORDER BY<\/b> in <strong>PROC SQL<\/strong> in SAS per ordinare i risultati di una query in base ai valori di una o pi\u00f9 variabili.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ecco tre modi comuni per utilizzare nella pratica l&#8217;istruzione <strong>ORDER BY<\/strong> :<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metodo 1: ordine in base a una variabile 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>Metodo 2: ordinamento per variabile 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>Metodo 3: ordine per pi\u00f9 variabili<\/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;\">I seguenti esempi mostrano come utilizzare ciascun metodo nella pratica con il seguente set di dati in SAS che contiene informazioni su vari giocatori di 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>Esempio 1: <span style=\"color: #000000;\">ordine in base a una variabile crescente<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Il codice seguente mostra come restituire ciascuna riga nel set di dati in ordine crescente in base ai valori della colonna <strong>del team<\/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;\">Tieni presente che i risultati vengono visualizzati in ordine crescente in base ai valori nella colonna <strong>Squadra<\/strong> .<\/span><\/p>\n<h2> <strong>Esempio 2: <span style=\"color: #000000;\">Ordine per una variabile decrescente<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Il codice seguente mostra come restituire ogni riga nel set di dati in ordine decrescente in base ai valori delle colonne <strong>del team<\/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;\">Tieni presente che i risultati vengono visualizzati in ordine decrescente in base ai valori nella colonna <strong>Team<\/strong> .<\/span><\/p>\n<h2> <strong>Esempio 3: <span style=\"color: #000000;\">ordine per pi\u00f9 variabili<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Il codice seguente mostra come restituire ciascuna riga nel set di dati prima in ordine crescente per <strong>squadra<\/strong> e poi in ordine decrescente per <strong>punti<\/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;\">Tieni presente che i risultati vengono visualizzati prima in ordine crescente per <strong>squadra<\/strong> , poi in ordine decrescente per <strong>punti<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Risorse addizionali<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">I seguenti tutorial spiegano come eseguire altre attivit\u00e0 comuni in SAS:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/it\/sas-proc-sql-unione\/\" target=\"_blank\" rel=\"noopener\">SAS: come utilizzare UNION in PROC SQL<\/a><br \/> <a href=\"https:\/\/statorials.org\/it\/sas-proc-sql-eccetto\/\" target=\"_blank\" rel=\"noopener\">SAS: come utilizzare EXCEPT in PROC SQL<\/a><br \/> <a href=\"https:\/\/statorials.org\/it\/sas-proc-sql-in\/\" target=\"_blank\" rel=\"noopener\">SAS: come utilizzare l&#8217;operatore IN in PROC SQL<\/a><br \/> <a href=\"https:\/\/statorials.org\/it\/sas-proc-sql-o\/\" target=\"_blank\" rel=\"noopener\">SAS: come utilizzare l&#8217;operatore WHERE in PROC SQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00c8 possibile utilizzare l&#8217;istruzione ORDER BY in PROC SQL in SAS per ordinare i risultati di una query in base ai valori di una o pi\u00f9 variabili. Ecco tre modi comuni per utilizzare nella pratica l&#8217;istruzione ORDER BY : Metodo 1: ordine in base a una variabile 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":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SAS: Come utilizzare ORDER BY in PROC SQL - Stology<\/title>\n<meta name=\"description\" content=\"Questo tutorial spiega come utilizzare l&#039;istruzione ORDER BY in PROC SQL in SAS per ordinare i risultati di una query, con diversi esempi.\" \/>\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\/it\/sas-proc-sql-ordina-per\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS: Come utilizzare ORDER BY in PROC SQL - Stology\" \/>\n<meta property=\"og:description\" content=\"Questo tutorial spiega come utilizzare l&#039;istruzione ORDER BY in PROC SQL in SAS per ordinare i risultati di una query, con diversi esempi.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/it\/sas-proc-sql-ordina-per\/\" \/>\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=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuti\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/it\/sas-proc-sql-ordina-per\/\",\"url\":\"https:\/\/statorials.org\/it\/sas-proc-sql-ordina-per\/\",\"name\":\"SAS: Come utilizzare ORDER BY in PROC SQL - Stology\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/it\/#website\"},\"datePublished\":\"2023-07-09T23:45:28+00:00\",\"dateModified\":\"2023-07-09T23:45:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/it\/#\/schema\/person\/0896f191fb9fb019f2cd8623112cb3ae\"},\"description\":\"Questo tutorial spiega come utilizzare l&#39;istruzione ORDER BY in PROC SQL in SAS per ordinare i risultati di una query, con diversi esempi.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/it\/sas-proc-sql-ordina-per\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/it\/sas-proc-sql-ordina-per\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/it\/sas-proc-sql-ordina-per\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Casa\",\"item\":\"https:\/\/statorials.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sas: come utilizzare order by in proc sql\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/it\/#website\",\"url\":\"https:\/\/statorials.org\/it\/\",\"name\":\"Statorials\",\"description\":\"La tua guida all&#039;alfabetizzazione statistica!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/it\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/it\/#\/schema\/person\/0896f191fb9fb019f2cd8623112cb3ae\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/statorials.org\/it\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/it\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/it\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Ciao, sono Benjamin, un professore di statistica in pensione diventato insegnante dedicato di Statorials. Con una vasta esperienza e competenza nel campo della statistica, sono ansioso di condividere le mie conoscenze per potenziare gli studenti attraverso Statorials. Scopri di pi\u00f9\",\"sameAs\":[\"https:\/\/statorials.org\/it\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAS: Come utilizzare ORDER BY in PROC SQL - Stology","description":"Questo tutorial spiega come utilizzare l&#39;istruzione ORDER BY in PROC SQL in SAS per ordinare i risultati di una query, con diversi esempi.","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\/it\/sas-proc-sql-ordina-per\/","og_locale":"it_IT","og_type":"article","og_title":"SAS: Come utilizzare ORDER BY in PROC SQL - Stology","og_description":"Questo tutorial spiega come utilizzare l&#39;istruzione ORDER BY in PROC SQL in SAS per ordinare i risultati di una query, con diversi esempi.","og_url":"https:\/\/statorials.org\/it\/sas-proc-sql-ordina-per\/","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":{"Written by":"Benjamin anderson","Est. reading time":"2 minuti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/it\/sas-proc-sql-ordina-per\/","url":"https:\/\/statorials.org\/it\/sas-proc-sql-ordina-per\/","name":"SAS: Come utilizzare ORDER BY in PROC SQL - Stology","isPartOf":{"@id":"https:\/\/statorials.org\/it\/#website"},"datePublished":"2023-07-09T23:45:28+00:00","dateModified":"2023-07-09T23:45:28+00:00","author":{"@id":"https:\/\/statorials.org\/it\/#\/schema\/person\/0896f191fb9fb019f2cd8623112cb3ae"},"description":"Questo tutorial spiega come utilizzare l&#39;istruzione ORDER BY in PROC SQL in SAS per ordinare i risultati di una query, con diversi esempi.","breadcrumb":{"@id":"https:\/\/statorials.org\/it\/sas-proc-sql-ordina-per\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/it\/sas-proc-sql-ordina-per\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/it\/sas-proc-sql-ordina-per\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Casa","item":"https:\/\/statorials.org\/it\/"},{"@type":"ListItem","position":2,"name":"Sas: come utilizzare order by in proc sql"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/it\/#website","url":"https:\/\/statorials.org\/it\/","name":"Statorials","description":"La tua guida all&#039;alfabetizzazione statistica!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/it\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"it-IT"},{"@type":"Person","@id":"https:\/\/statorials.org\/it\/#\/schema\/person\/0896f191fb9fb019f2cd8623112cb3ae","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/statorials.org\/it\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/it\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/it\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Ciao, sono Benjamin, un professore di statistica in pensione diventato insegnante dedicato di Statorials. Con una vasta esperienza e competenza nel campo della statistica, sono ansioso di condividere le mie conoscenze per potenziare gli studenti attraverso Statorials. Scopri di pi\u00f9","sameAs":["https:\/\/statorials.org\/it"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/posts\/4578"}],"collection":[{"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/comments?post=4578"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/posts\/4578\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/media?parent=4578"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/categories?post=4578"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/it\/wp-json\/wp\/v2\/tags?post=4578"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}