topic Re: Sort (Proc) in SAS Programming

Sort (Proc)

ChuksManuel — Sun, 28 Oct 2018 22:09:54 GMT

Hello guys,

I have 2 problems and i will appreciate appropriate codes for each case.

1. The data set i attached here is called "Chuck1" and i want to sort this data so that the observations are listed (grouped) by state with the first observation having a value of 'TX' and the youngest person in that state.

2. I also want to write a second code that will help me sort "chuck1" so that there is only one observation per person (Subj_no identifies each person in the data set). I don't want to overwrite the original data set, but rather to put the sorted data into a new data set called 'Chuck2".

Help is needed!

Re: Sort (Proc)

VDD — Sun, 28 Oct 2018 22:15:29 GMT

Please post your sample data in the form of a SAS datastep with datalines to represent the data so that we can read you sample data into a SAS dataset.

Otherwise we have to enter all your sample from a snapshot to get an understanding of the data and the data types.

Re: Sort (Proc)

Shmuel — Mon, 29 Oct 2018 02:09:11 GMT

A simple sort will be:

proc sort data=chuck1;
   by descending state age;
run;

without duplicates:

proc sort data=chuck1 out=chuck2 nodupkey;
   by subj_no;
run;

Re: Sort (Proc)

ChuksManuel — Mon, 29 Oct 2018 03:45:28 GMT

Thanks Shmuel!