{"id":11807,"date":"2018-03-26T11:05:15","date_gmt":"2018-03-26T05:35:15","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=11807"},"modified":"2021-05-09T13:16:43","modified_gmt":"2021-05-09T07:46:43","slug":"sas-proc-sort","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sas-proc-sort\/","title":{"rendered":"SAS Proc Sort Data Sets – Ascending, Descending & BY Statements"},"content":{"rendered":"

Today we will be learning about SAS PROC Sort Data Sets. We will then be looking at two ways of PROC sorting a dataset in SAS: SAS Default Sort and Reverse Sorting in SAS. We will also learn the BY statement that is very important while PROC Sorting data values in SAS Programming Language<\/strong>.<\/p>\n

So let us begin with PROC Sorting Data Sets in SAS.<\/p>\n

Sorting in SAS<\/h2>\n

Sorting in SAS is a\u00a0process of a simple arrangement where data arranges in ascending or descending sort order. The default order of sorting is ascending (SAS Sort in ascending). The sorting of variable results in better analysis.<\/p>\n

Now let us look at the syntax of a SAS PROC SORT statement:<\/p>\n

proc sort\u00a0data=<name of data>;\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 by\u00a0<name of variable>;\r\nrun;<\/pre>\n
SAS PROC Sort Ascending Order<\/h2>\n
The SAS Sorting by a single variable (default: Ascending Order).<\/p>\n
data\u00a0one;\r\n\u00a0\u00a0\u00a0\u00a0 input\u00a0studyid name $ sex $ age weight height;\r\ncards;\r\n1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Carol\u00a0 \u00a0 \u00a0 \u00a0  \u00a0f\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a022\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0120\u00a0 \u00a0 \u00a0 64;\r\n6\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Julie\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 f\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a055\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0125\u00a0 \u00a0 \u00a0 63;\r\n2\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Joe\u00a0 \u00a0 \u00a0 \u00a0 \u00a0  \u00a0m\u00a0 \u00a0 \u00a0 \u00a0 \u00a0  34\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0130\u00a0 \u00a0 \u00a0 68;\r\n7\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Kelsey\u00a0 \u00a0 \u00a0   \u00a0f\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a043\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0130\u00a0 \u00a0 \u00a0 64;\u00a0\u00a0\r\n4\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Ann\u00a0 \u00a0 \u00a0 \u00a0 \u00a0  \u00a0f\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a029\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 .\u00a0 \u00a0 \u00a0 \u00a065;\r\n11\u00a0 \u00a0 \u00a0  \u00a0 Tracee\u00a0 \u00a0 \u00a0 \u00a0  f\u00a0 \u00a0 \u00a0 \u00a0 \u00a0  21\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0110\u00a0 \u00a0  \u00a0 .;\r\n9\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Bob\u00a0 \u00a0 \u00a0 \u00a0 \u00a0  \u00a0m\u00a0 \u00a0 \u00a0 \u00a0   \u00a032\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0155\u00a0 \u00a0 \u00a0 71;\u00a0\u00a0\r\n3\u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0Ed\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0m\u00a0 \u00a0 \u00a0 \u00a0   \u00a040\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0120\u00a0 \u00a0 \u00a0 69;\r\n8\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Karl\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0m\u00a0 \u00a0 \u00a0 \u00a0   \u00a035\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0160\u00a0 \u00a0 \u00a0 68;\r\n10\u00a0 \u00a0 \u00a0  \u00a0 Gayla\u00a0 \u00a0 \u00a0 \u00a0  \u00a0f\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a040\u00a0 \u00a0 \u00a0 \u00a0  \u00a0 130\u00a0 \u00a0 \u00a0 68;\r\n5\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 John\u00a0 \u00a0 \u00a0 \u00a0 \u00a0  m\u00a0 \u00a0 \u00a0 \u00a0   \u00a017\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0175\u00a0 \u00a0  \u00a073;\u00a0\r\nrun;\u00a0\u00a0\r\nproc sort\u00a0data=one;\r\n\u00a0\u00a0\u00a0 by\u00a0weight;\r\nrun;\r\n\/*will sort data one by the variable weight in ascending order *\/\r\nproc print\u00a0data=one;\r\nrun;<\/pre>\n
\""<yoastmark\"<\/a><\/p>\n
SAS PROC Sort Descending Order<\/h2>\n
Sorting in Descending Order (reverse sorting)<\/p>\n
Example:<\/strong><\/p>\n
\u00a0proc sort\u00a0data=one;\r\nby\u00a0 descending\u00a0height;\r\nrun;\r\nproc print\u00a0data=one;\r\nid\u00a0studyid;\r\nvar\u00a0name age height;\r\nrun;<\/pre>\n
\"SAS<\/a>
SAS PROC Sorting in Descending Order<\/p><\/div>\n
BY Statement<\/h2>\n
This statement instructs SAS to apply the procedure for each subset of data and can be applied to more than one SAS variable<\/strong>.<\/p>\n
Syntax:<\/strong><\/p>\n
proc <name of SAS Procedure>\u00a0data=<name of data>;\r\n<SAS Statements>\r\nby\u00a0<variable name>;\r\nrun;<\/pre>\n
Example:<\/strong><\/p>\n
\/* First sort the data *\/\r\nproc sort\u00a0data=one;\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 by\u00a0sex;\r\nrun;\r\nproc print\u00a0data=one;\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 by\u00a0sex;\r\nrun;<\/pre>\n
\"BY<\/a>
BY Statement<\/p><\/div>\n
Summary<\/h2>\n
So, today we looked at the two ways by which we can sort our data, which is either in ascending or in descending order.<\/p>\n
We then looked at the BY statement in SAS through which we can apply sorting on multiple variables and it is an important statement in the proc sort statement. Furthermore, if you have any query feel free to ask in a comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"
Today we will be learning about SAS PROC Sort Data Sets. We will then be looking at two ways of PROC sorting a dataset in SAS: SAS Default Sort and Reverse Sorting in SAS....<\/p>\n","protected":false},"author":6,"featured_media":11812,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[59],"tags":[109,19290,19291,12189,12256],"class_list":["post-11807","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sas","tag-by-statement","tag-proc-sort-ascending-order","tag-proc-sort-descending-order","tag-sas-proc-sort-data-sets","tag-sas-sorting"],"yoast_head":"\nSAS Proc Sort Data Sets - Ascending, Descending & BY Statements - DataFlair<\/title>\n<meta name=\"description\" content=\"SAS Proc Sort Data Sets comprises what is sorting in SAS, SAS PROC Sort Ascending Order and Descending Order with syntax and SAS By statement.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/sas-proc-sort\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS Proc Sort Data Sets - Ascending, Descending & BY Statements - DataFlair\" \/>\n<meta property=\"og:description\" content=\"SAS Proc Sort Data Sets comprises what is sorting in SAS, SAS PROC Sort Ascending Order and Descending Order with syntax and SAS By statement.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sas-proc-sort\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-26T05:35:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-09T07:46:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/sort-datasets-in-SAS-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAS Proc Sort Data Sets - Ascending, Descending & BY Statements - DataFlair","description":"SAS Proc Sort Data Sets comprises what is sorting in SAS, SAS PROC Sort Ascending Order and Descending Order with syntax and SAS By statement.","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:\/\/data-flair.training\/blogs\/sas-proc-sort\/","og_locale":"en_US","og_type":"article","og_title":"SAS Proc Sort Data Sets - Ascending, Descending & BY Statements - DataFlair","og_description":"SAS Proc Sort Data Sets comprises what is sorting in SAS, SAS PROC Sort Ascending Order and Descending Order with syntax and SAS By statement.","og_url":"https:\/\/data-flair.training\/blogs\/sas-proc-sort\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-03-26T05:35:15+00:00","article_modified_time":"2021-05-09T07:46:43+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/sort-datasets-in-SAS-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sas-proc-sort\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sas-proc-sort\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"SAS Proc Sort Data Sets – Ascending, Descending & BY Statements","datePublished":"2018-03-26T05:35:15+00:00","dateModified":"2021-05-09T07:46:43+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sas-proc-sort\/"},"wordCount":274,"commentCount":3,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sas-proc-sort\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/sort-datasets-in-SAS-01.jpg","keywords":["'BY' Statement","Proc Sort Ascending Order","Proc Sort Descending Order","SAS Proc Sort Data Sets","SAS Sorting"],"articleSection":["SAS Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sas-proc-sort\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sas-proc-sort\/","url":"https:\/\/data-flair.training\/blogs\/sas-proc-sort\/","name":"SAS Proc Sort Data Sets - Ascending, Descending & BY Statements - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sas-proc-sort\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sas-proc-sort\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/sort-datasets-in-SAS-01.jpg","datePublished":"2018-03-26T05:35:15+00:00","dateModified":"2021-05-09T07:46:43+00:00","description":"SAS Proc Sort Data Sets comprises what is sorting in SAS, SAS PROC Sort Ascending Order and Descending Order with syntax and SAS By statement.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sas-proc-sort\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sas-proc-sort\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sas-proc-sort\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/sort-datasets-in-SAS-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/sort-datasets-in-SAS-01.jpg","width":1200,"height":628,"caption":"SAS Sorting- Sort Datasets"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sas-proc-sort\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAS Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sas\/"},{"@type":"ListItem","position":3,"name":"SAS Proc Sort Data Sets – Ascending, Descending & BY Statements"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11807","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=11807"}],"version-history":[{"count":11,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11807\/revisions"}],"predecessor-version":[{"id":93367,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11807\/revisions\/93367"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/11812"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=11807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=11807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=11807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}