Hi
for the following id's,
id type
1234 old
1234 new
2345 old
4567 old
4567 old
5678 new
5678 new
I would like to categorize the id's like
result:
id type
1234 old
2345 old
4567 old
5678 new
Hi,
Assuming the logic s to just take the first occurence (and its sorted):
data want;
set have;
by id;
if first.id;
run;
This will get you the result you want, but based on the way you ask your question I'm not sure that you don't want to use proc format:
data have;
infile cards dsd;
input id$ type$;
cards;
1234,old
1234,new
2345,old
4567,old
4567,old
5678,new
5678,new
;
proc sort data=have;by id type;
data want;
set have;
by id;
if last.id;
run;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.