topic Re: proc sort in SAS Programming

proc sort default output data set

HeatherNewton — Tue, 22 Mar 2022 10:17:52 GMT

proc sort data=apple;
by colour weight;
run;

for proc sort, input data is dataset apple, is the output data set after sorting is also apple?

Re: proc sort

BrahmanandaRao — Tue, 22 Mar 2022 09:14:17 GMT

Proc sort data = apple out=sort_apple;
By variable;
run;

Re: proc sort

Amir — Tue, 22 Mar 2022 09:46:03 GMT

Hi,

In answer to your question, yes the sorted data set would also be called apple.

If you want to create a new sorted data set and leave the input data set unchanged then the solution posted by @BrahmanandaRao should be fine.

For more information on the proc sort syntax you can see the documentation.

Kind regards,

Amir.

Re: proc sort

ballardw — Tue, 22 Mar 2022 09:48:18 GMT

How about reading the documentation at https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/proc/p0ha9ymifyaqldn14m2xlqw252wa.htm

which clearly states

In the following example, the original data set was in alphabetical order by last name. PROC SORT replaces the original data set with a data set that is sorted by employee identification number. The following log shows the results from running this PROC SORT step. Observations Sorted by the Values of One Variable shows the results of the PROC PRINT step. The statements that produce the output follow:

proc sort data=employee;
   by idnumber;
run;

proc print data=employee;
run;

proc sort data=employee;
   by idnumber;
run;

proc print data=employee;
run;

You can provide another data set as an OUT= option, as @BrahmanandaRao shows, if you want to create a different data set which is highly recommended if you use any of the options that remove observations.

Re: proc sort default output data set

Kurt_Bremser — Tue, 22 Mar 2022 11:57:29 GMT

Maxim 2: Read the Log.

It will tell you the answer right there on the spot.

BIG hint: reading the log is always quicker than posting here. Only when you have trouble interpreting the log, come here for guidance.

Re: proc sort default output data set

HeatherNewton — Wed, 23 Mar 2022 03:49:04 GMT

thanks for your hint, you are so right