I am wondering if there is a more efficient way to append a bunch of data sets during read in. Fortunately, all the data sets I am working with follow the same naming convention and only differ in a single number that increments each year. I have been doing the below, but since is this something I will simply have to add to each year, am wondering if there is a way to use a macro (indicating the most recent year) and a loop to make this more efficient.
data app_data; set ds2015 ds2016 ds2017 ds2018 ds2019 ds2020; *Other stuff happens; run;
Since your datasets are using nice sequential numeric suffixes you can use a dataset list.
data app_data;
set ds2015-ds2020;
run;
Depending on your situation, this maybe useful. A colon is used as a wildcard for datasets.
data app_data;
set ds: ;
run;
This will select ALL datasets in WORK with the "ds" prefix, mind you.
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 16. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: