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!
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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.