topic Re: Proc Transpose Help in SAS Programming

Proc Transpose Help

shynu — Mon, 16 Jan 2017 17:37:29 GMT

I have a dataset:

id	name	dm	value
101	weight	ds	50
101	weight	ds	55
101	weight	ds	54
101	weight	ds	49.8
101	weight	ds	53

i need to output:

id	dm	weight
101	ds	50
101	ds	55
101	ds	54
101	ds	49.8
101	ds	53

using proc transpose how can i do it?

Re: Proc Transpose Help

collinelliot — Mon, 16 Jan 2017 18:26:14 GMT

The following seems to work:

data have;
input id name $	dm $ value;
datalines;
101 weight ds 50
101 weight ds 55
101 weight ds 54
101 weight ds 49.8
101 weight ds 53
;

proc sort data = have;
    by id dm value;
run;

proc transpose data = have out = want;
    by id dm value;
    var value;
    id name;
run;

But why? Why not just rename "value" to "weight" and drop "name" if you really need that specific structure?

Re: Proc Transpose Help

shynu — Tue, 17 Jan 2017 12:49:05 GMT

thanx that worked