I have a data set that looks like this, with data for different years in different columns county age data2015 data2016 data2017 1 1 89 17 79 1 2 6 76 49 1 3 87 5 25 1 4 45 17 1 1 5 78 59 45 2 1 35 4 20 2 2 51 95 46 2 3 76 24 8 2 4 60 66 30 2 5 54 28 41   I would like to change this so each year has it's own set of rows, but keeping their county and age, so it would look like this. Is there an easy way to do this?  I could read in the data set three times, once for each year, and append each time. But I just wanted to ask if there was an easier way.   county age year data 1 1 2015 89 1 2 2015 6 1 3 2015 87 1 4 2015 45 1 5 2015 78 2 1 2015 35 2 2 2015 51 2 3 2015 76 2 4 2015 60 2 5 2015 54 1 1 2016 17 1 2 2016 76 1 3 2016 5 1 4 2016 17 1 5 2016 59 2 1 2016 4 2 2 2016 95 2 3 2016 24 2 4 2016 66 2 5 2016 28 1 1 2017 79 1 2 2017 49 1 3 2017 25 1 4 2017 1 1 5 2017 45 2 1 2017 20 2 2 2017 46 2 3 2017 8 2 4 2017 30 2 5 2017 41   ... View more

I am importing an excel file that we get from another group, using this code   libname one "\\scchoit40\phig\gxs03\chire\"; proc import out = preg_1 datafile = "\\scchoit40\phig\gxs03\chire\testdata.xlsx" DBMS=XLSX REPLACE; sheet = "2012-14"; RANGE = "A5:G67"; getnames = yes; run;   proc import out = preg_2 datafile = "\\scchoit40\phig\gxs03\chire\testing_2010_2014.xlsx" DBMS=XLSX REPLACE; sheet = "Total_2012_2014"; RANGE = "A6:G68"; getnames = yes; run;       The first couple of lines of the testing data set look like this, below. But the sas program reads the first line of the file as the labels, rather than the first line of data (starting at row a6). Doesn't the range tell sas where to start reading the data, so shouldn't the first line of the data range be the lables?   New York State testdata by County of Residence 2011-2013                   County White NH Black NH Asian NH Other NH Hispanic Total ALBANY 104 127 2 19 48 300 ALLEGANY 40 0 0 2 1 43 BROOME 146 39 4 17 14 220 CATTARAUGUS 85 3 1 12 5 106 ... View more