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
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.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.