Hi everyone,
I am attempting to transpose data using a data step (cannot use proc transpose for this question). I can't figure out why I keep getting a value of '15' for Maple Yr2009. I'm assuming it has something to do with the missing data, but if anyone has a suggestion for how I correct this that would be wonderful.
Dataset:
DATA Work.Trees;
INFILE DATALINES;
INPUT Type $6.
Year 8-11
HtFt 13-14;
CARDS;
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
;
Current code to transpose using data step:
DATA Work.TreesWide2;
SET Work.Trees;
BY Type;
RETAIN Yr2009 Yr2010 Yr2011 Yr2012;
IFFIRST.LabDate = 1THENCALL MISSING(Yr2009, Yr2010, Yr2011, Yr2012);
IFYear = 2009 THEN Yr2009 = HtFt;
ELSE IF Year = 2010THEN Yr2010 = HtFt;
ELSE IF Year = 2011THEN Yr2011 = HtFt;
ELSE IF Year = 2012THEN Yr2012 = HtFt;
IF LAST.Type = 1;
DROP Year HtFt;
RUN;
Output I am currently getting:

Output I want:

Thank you!