topic Transposing data in SAS Procedures

Transposing data

JasonL — Tue, 05 May 2020 20:19:51 GMT

Hi there,

I have data like this:

ID V1 V2 V3 ...... V20

01 A1 B2 C3 ......

02 O1 P2 Q3 ......

03 X1 Y2 Z3 ......

......

and need to convert it into something like this:

ID TheVar

01 A1

01 B2

01 C3

......

02 O1

02 P2

02 Q3

......

03 X1

03 Y2

03 Z3

......

Is there an efficient way to do that? Thank you!

Jason

Re: Transposing data

ballardw — Tue, 05 May 2020 20:32:11 GMT

Proc transpose:

data have;
input iD $   V1 $ v2 $  V3 $;
datalines;
01   A1  B2  C3 
02  O1  P2  Q3  
03  X1  Y2  Z3  
;

proc transpose data=have out=trans (drop=_name_)
  prefix=TheVar
;
by id;
var v1 - v3;
run;

If there are other variables that need to be carried along you need to show a better example.

Please provide data in the form of a data step as shown above and post into a code box opened on the forum using the </> or "running man" icon. Posting the main message window will usually result in text being reformatted and data steps may not run after the forum gets through with them.

Re: Transposing data

JasonL — Tue, 05 May 2020 20:37:05 GMT

Great! That does it!

Thank you very much!