Hi,
I am using SAS V9.4 to work with a dataset where there are more than one observations for a person. I am interested in a single observation for a person; however when I sort by descending order and select the first observation per case ID, I get a dataset much smaller than the dataset I get if I sort by the SAS default of ascending order. The two numbers aren't even close. Any ideas as to why this could be happening?
PROC SORT data=temp1;
BY case_number value;
DATA TEMP2;
SET TEMP1;
BY case_number value;
if FIRST.case_number;
PROC SORT data=temp1;
BY case_number descending value;
DATA TEMP2;
SET TEMP1;
BY case_number descending value;
if FIRST.case_number;
Please show the log, including its report on the number of observations in TEMP2 -- for both orderings.
Please show the log, including its report on the number of observations in TEMP2 -- for both orderings.
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.