topic Re: creating one continuous column from multiple rows in SAS Data Management

creating one continuous column from multiple rows

cdvdc — Fri, 17 Mar 2017 14:26:03 GMT

Good day! My data looks like this:

ID B1 B2 B3

1 1 2 3

2 4 5 6

3 7 8 9

I would like it to look like this:

ID B# Content

1 1 1

1 2 2

1 3 3

2 1 4

2 2 5

2 3 6

3 1 7

3 2 8

3 4 9

Could you pls help me. Thanks!

Re: creating one continuous column from multiple rows

RW9 — Fri, 17 Mar 2017 14:53:10 GMT

Without test data in the form of a datastep, this is just a guess:

proc transpose data=have out=want;
  by id;
  var b:;
run;

Re: creating one continuous column from multiple rows

collinelliot — Fri, 17 Mar 2017 14:59:57 GMT

In addition to transposing, you could do it in a data step. I assume your last row is a typo, though. I don't know where the b# = 4 would come from.

data have;
    input ID B1 B2 B3;
datalines;
1 1   2   3
2 4   5   6
3 7   8   9
;

data want(drop = b:);
    set have;
    array b{3};
    do num_b = 1 to 3;
        content = b(num_b);
        output;
    end;
run;

Re: creating one continuous column from multiple rows

cdvdc — Fri, 17 Mar 2017 15:12:54 GMT

thank you so much! the last one was a typo

Re: creating one continuous column from multiple rows

collinelliot — Fri, 17 Mar 2017 15:21:17 GMT

You're welcome. @RW9' s solution would probably work for you, too, and you should probably get familiar with how proc transpose works since there are times when it will be far easier than a data step approach.