Hi all, this is probably relatively simple, but appreciate the help.
data I have
id event value
1 a x
1 b y
1 c z
2 a q
2 b r
2 c s
2 d t
...
data i want
Use BY groups and first/last in SAS.
data want; set have; by id; if last.id; run;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Register Now
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.
Browse our catalog!