topic Re: How to change table structure in SAS Procedures

How to change table structure

Ypss — Wed, 14 Jan 2015 09:14:50 GMT

I have a dataset that looks like this:

a	b	c	d	e
1	3	5	7	9
2	4	6	8	10

How to change it to:

Thank you in advance!

LinusH — Wed, 14 Jan 2015 11:30:46 GMT

mohamed_zaki — Wed, 14 Jan 2015 11:50:11 GMT

data have;

input a b c d e;

cards;

1 3 5 7 9

2 4 6 8 10

;

run;

proc transpose data=have out=have;

run;

proc transpose data=have out=have;

by _name_;

run;

Loko — Wed, 14 Jan 2015 12:02:23 GMT

Hello,

A data step solution:

data have;
input a b c d e;
datalines;
1 3 5 7 9
2 4 6 8 10
;

data want;
set have;
array vars{*} a--e;
do i=1 to dim(vars);
character=vname(vars{i});
number=vars{i};
output;
end;

keep character number;
run;