topic Merging columns in SAS Programming

Merging columns

yoyong — Wed, 01 Aug 2018 03:23:13 GMT

Hi.

I have the following variables from a subset data:

Obs A1 A2 A3 B1 B2 B3 C1 C2 C3 ....

How do I merge all A variables to become one column, similarly for B and C?

Some rows maybe totally empty e.g. (Row 3) . How do I exclude such rows in the code?

The output will look like:

Obs A B C ....

Thank you.

Re: Merging columns

PeterClemmensen — Wed, 01 Aug 2018 05:41:37 GMT

Something like this?

data have;
input A1 A2 A3 B1 B2 B3 C1 C2 C3;
datalines;
1 2 3 4 5 6 7 8 9
2 3 4 5 6 7 8 9 6
5 7 2 0 8 6 5 8 6
4 6 3 9 7 1 6 9 7
4 8 3 5 8 3 1 6 9
;

data want(keep= A B C);
   set have;
   array As{*} A:;
   array Bs{*} B:;
   array Cs{*} C:;
   do i=1 to dim(As);
      A=As[i];B=Bs[i];C=Cs[i];
      output;
   end;
run;