Transposing 2 columns into multiple rows

suhwan — Tue, 02 Oct 2018 22:32:21 GMT

I have a one column data which contains information about multiple observations.

Each observation starts with a first column value of "notes".

I.E.

notes

name A1

code B1

...

notes

name A2

code B2

...

notes

name A200

code B200

...

Is there a good way to transpose this into 200 rows?

PS. I would like to have name, code, ..., as my column variables after transposing.

Re: Transposing 2 columns into multiple rows

ChrisNZ — Wed, 03 Oct 2018 01:33:00 GMT

Like this?

data HAVE;
  input COL1 $16.;
  cards;
notes
name A1
code B1
..
notes
name A2
code B2
;
run;
data WANT;
  set HAVE;
  length NAME CODE  $8;
  retain NAME;
  if COL1=:'name' then NAME=substr(COL1,6);
  if COL1=:'code' then do ;
    CODE=substr(COL1,6);
    output;
    call missing(NAME, CODE);
  end;
run;

topic Re: Transposing 2 columns into multiple rows in SAS Programming

Transposing 2 columns into multiple rows

Re: Transposing 2 columns into multiple rows