proc transpose by numerical variable

[HSM9]

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;

[PGStats · Accepted solution]

Add the statement :

ID year;

[HSM9]

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

[Reeza]

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;

---