How do I add more years to my dataset?

[dpachorek]

Hello!

I have a list of 246 schools. I am trying to add a year column but each school should have 2019, 2018, 2017, 2016, and 2015. Can someone help me figure out a way to code this so that I do not have to go in manually for this?

Thank you!

[ballardw · Accepted solution]

If your current data has one record per school then something like this:

data want;
   set have;
   do year=2015 to 2019;
       output;
   end;
run;

which will duplicate all the values in the other variables.

If you do not have one record per school then example of what you currently have and what the output should look like.

If the actual order really matters you could do: year = 2019 to 2015 by -1

[Reeza]

Do you want 4 columns, one for each year per school?
Or do you want 4 rows, one for each year per school?
Or do you already have years but not all school has every year?