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;
Add the statement :
ID year;
Yes, that was all it needed I guess. Thank you!
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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.