Create a new data set concatenating the observations

[Sir_Highbury]

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

[RW9 · Accepted solution]

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;

[Sir_Highbury]

many thanks