topic Create a new data set concatenating the observations in SAS Programming

Create a new data set concatenating the observations

Sir_Highbury — Fri, 08 Apr 2016 14:07:58 GMT

Dear Experts,

let's assume there is the following data set with one variable (country) and severa observations.

country

…

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

Re: Create a new data set concatenating the observations

RW9 — Fri, 08 Apr 2016 14:16:21 GMT

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;

Re: Create a new data set concatenating the observations

Sir_Highbury — Fri, 08 Apr 2016 14:59:20 GMT

many thanks