Sort (Proc)

[ChuksManuel]

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!

[VDD · Accepted solution]

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.

[Shmuel]

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;

[ChuksManuel]

Thanks Shmuel!