10 + 20 is the answer ... View more

Hi Kaitlin- I found 2 ways that seemed to work. Building the data set: DATA lib.dataset; INFILE DATALINES DELIMITER=' '; INPUT Type $ Year HtFt; 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 PRINT DATA = lib.dataset; RUN;   First way to transpose (With Proc Transpose): PROC TRANSPOSE DATA = lib.dataset OUT = lib.datasetwide( DROP = _NAME_ ) PREFIX = Yr; VAR HtFt; BY Type; ID Year; RUN; PROC PRINT DATA = lib.datasetwide; RUN;   Output1: Obs Type Yr2009 Yr2010 Yr2011 Yr2012123 Aspen 15 16 . . Maple . 6 8 10 Spruce 22 23 24 25   Second way to transpose (With Data Step): DATA lib.datasetwide2; SET lib.dataset; BY Type; ARRAY Years {2009:2012}Yr2009 - Yr2012 (. . . . ); IF First.type = 1 THEN CALL MISSING(OF Years{*}); Years{Year} = HtFt; IF Last.Type = 1; DROP Year HtFt; RUN; PROC PRINT Data= lib.datasetwide2; RUN;   Output 2: Obs Type Yr2009 Yr2010 Yr2011 Yr2012123 Aspen 15 16 . . Maple . 6 8 10 Spruce 22 23 24 25   ... View more