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!
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.
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.
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;
Thanks Shmuel!
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.