I have the following data:
ID Flag Date Details
1 N 1/1 abc
1 N 1/2 efg
1 Y 1/1 hij
2 N 1/3 lmo
This dataset is already sorted by ID, flag and date (ascending order) using proc sort. I want to now only output the last row in every ID, flag combination as follows:
ID Flag Date Details
1 N 1/2 efg
1 Y 1/1 hij
2 N 1/3 lmo
Just use BY group processing. You want the last one per ID FLAG group.
data want;
set have;
by ID Flag Date;
if last.flag;
run;
Just use BY group processing. You want the last one per ID FLAG group.
data want;
set have;
by ID Flag Date;
if last.flag;
run;
that was easier than I thought. Thanks!
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.