topic Re: Transposing table in SAS Programming

Transposing table

ursula — Mon, 18 Dec 2017 22:40:52 GMT

Hi there,

I tried to transpose a table, see below example:

I want:

Any help will be very appreciated.

Thanks,

novinosrin — Mon, 18 Dec 2017 22:48:14 GMT

data have;
input ID $ Age1 Age2;
datalines;
A 10 20
C 30 40
D 50 60
E 70 80
;

proc transpose data=have out=want;
id id ;
run;

You could have tried yourself. it's easy copy paste

ursula — Mon, 18 Dec 2017 23:11:53 GMT

Thank you!

I wonder if the variable Age1 and Age1 are characters, then the code is not working.

This is the other example:

I want:

novinosrin — Mon, 18 Dec 2017 23:15:22 GMT

proc transpose data=have out=want;
id id;
var code1 code2;
run;

soham_sas — Tue, 19 Dec 2017 12:03:25 GMT

@ursula you can try the below,

data have;
input ID $ Age1 Age2;
datalines;
A 10 20
C 30 40
D 50 60
E 70 80
;
run;

proc transpose data=have;
var age:;
ID ID;
run;

ursula — Tue, 19 Dec 2017 22:03:56 GMT

Perfect!

Thank you so much.