Proc Sort Output

[BTAinRVA]

Hello All!

Am I correct in saying that, with the code below, the dataset check will be sorted and deduped but the dataset kicks will not be sorted or deduped?

proc sort data = kicks nodupkey out=check; by edipn; run;

Thanks,

Brian

[mkeintz · Accepted solution]

This is an excellent opportunity for experimentation:

data class;
  set sashelp.class;
run;

proc sort data = class nodupkey out=class2;
  by age;
run;

Data set class, a clone of sashelp.class is sorted by name.   So the above uses your programming logic.  Compare the CLASS2 data set (proc print data=class2;run;) to data set CLASS.  They are only 19 observations long.  You will have used SAS to answer your SAS question.

[ballardw]

Almost. The code will not change the sort order of the kicks data set. If it were already sorted that order would remain. No records should be removed either.

[Reeza]

You can think of this, as a situation, where the input data set is not modified in any manner. Any modifications are on the out data set.