Dear Experts,
let's assume there is the following data set with one variable (country) and severa observations.
country
BU
JA
US
…
KR
How can I create a data set where I still have the variable but all the observations are compressed in one?
Expected output:
County
BU, JA, US,...,KR
Hi,
You can use a retain cating each item onto one long varaible then output at the end:
data have; country="BU"; output; country="JA"; output; country="US"; output; run; data want (drop=country rename=(tmp=country)); length tmp $2000; set have end=last; retain tmp; tmp=catx(",",tmp,country); if last then output; run;
Hi,
You can use a retain cating each item onto one long varaible then output at the end:
data have; country="BU"; output; country="JA"; output; country="US"; output; run; data want (drop=country rename=(tmp=country)); length tmp $2000; set have end=last; retain tmp; tmp=catx(",",tmp,country); if last then output; run;
many thanks
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.