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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.