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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.