Hello, I need to merge 5 data sets that have the same variables but are just counts from different years. I need a single data set of all 5 years with their counts summed. All the individual years have this format for example: 2008: tract under 1 1-4 4-5 … 1 1 5 10 … 2 2 5 1 … 3 10 4 2 … 4 11 6 8 … 5 8 1 14 … … … … … … I need to put 5 the years together by the tract number and sum the variables so it come out like this for example: 2008-2012 tracts under 1 1-4 4-5 … 1 151 418 410 … 2 541 115 231 … 3 122 354 354 … 4 78 456 564 … 5 6546 48 684 … … … … … … I've tried the simple data Y_08_15; merge D2008 D2009 D2010 D2011 D2012; by Tracts; run; But the sums of the variables did not come out right. Like for age 5 the sum should've been 215 but came out as 18. I am not sure what I am missing or need to do differently, what is the code I should be using? Thanks in advanced!
... View more