topic Re: Proc Sort Output in SAS Programming

Proc Sort Output

BTAinRVA — Wed, 09 Jan 2019 20:35:57 GMT

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

Re: Proc Sort Output

mkeintz — Wed, 09 Jan 2019 20:44:01 GMT

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.

Re: Proc Sort Output

ballardw — Wed, 09 Jan 2019 20:46:11 GMT

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.

Re: Proc Sort Output

Reeza — Wed, 09 Jan 2019 21:02:08 GMT

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.