topic Re: proc transpose by numerical variable in SAS Programming

proc transpose by numerical variable

HSM9 — Tue, 14 Nov 2017 02:12:36 GMT

What do I need to add in this code to have the HtFt values be organized based on the year? The code I have now just puts the variables in columns, but not in the correct one by year. How do I specify this?

data work.Trees;
infile datalines delimiter = ',';
input Type :$6.
Year :4.
HtFt :2.
;
datalines;
Aspen,2009,15
Aspen,2010,16
Maple,2010,6
Maple,2011,8
Maple,2012,10
Spruce,2009,22
Spruce,2010,23
Spruce,2011,24
Spruce,2012,25
;

proc transpose
data = work.Trees
out = work.TreesWide;
by Type;
var HtFt;

run;

Re: proc transpose by numerical variable

PGStats — Tue, 14 Nov 2017 02:16:02 GMT

Add the statement :

ID year;

Re: proc transpose by numerical variable

Reeza — Tue, 14 Nov 2017 02:20:45 GMT

The code I have now just puts the variables in columns, but not in the correct one by year.

Are you sure about that?

You can the ID with PREFIX and/or IDLABEL options but if they're in the wrong place this won't fix that.

@HSM9 wrote:

What do I need to add in this code to have the HtFt values be organized based on the year? The code I have now just puts the variables in columns, but not in the correct one by year. How do I specify this?

data work.Trees;
infile datalines delimiter = ',';
input Type :$6.
Year :4.
HtFt :2.
;
datalines;
Aspen,2009,15
Aspen,2010,16
Maple,2010,6
Maple,2011,8
Maple,2012,10
Spruce,2009,22
Spruce,2010,23
Spruce,2011,24
Spruce,2012,25
;

proc transpose
data = work.Trees
out = work.TreesWide;
by Type;
var HtFt;

run;

Re: proc transpose by numerical variable

HSM9 — Tue, 14 Nov 2017 02:30:13 GMT

Yes, that was all it needed I guess. Thank you!