topic Re: Reshape wide tables to long tables in SAS Enterprise Guide

Reshape wide tables to long tables

ayin — Mon, 19 Jun 2017 08:10:55 GMT

data have;
  input ID1 ID2 $ Value1 Value2;
  cards;
1 A 2 3
2 A 4 5
;
run;

data want;
  input ID1 ID2 $ Type $ Value;
  cards;
1 A Value1 2
1 A Value2 3
2 A Value1 4
2 A Value2 5
;
run;

Basically keep ID1 and ID2, and then reshape column 3 and column 4.

How to achieve it? Thanks!

Re: Reshape wide tables to long tables

BrunoMueller — Mon, 19 Jun 2017 08:21:05 GMT

You can use Proc TRANSPOSE to do this.

Use BY statement for your id vars and the VAR statement for the vars to you want to transpose.

Re: Reshape wide tables to long tables

ChrisBrooks — Mon, 19 Jun 2017 10:40:03 GMT

As Bruno says you need Proc Transpose for this but you'll also want to do some renaming e.g.

proc transpose data=have out=want(rename=(_name_=type col1=value));
by id1 id2;
var value1 value2;
run;