I've the following datasets in SAS and for the reporting I use only the previous month datasets (test_201801).
test_201801
test_201712
test_201711
test_201710
test_201709
.
.
test_201501
Now there going to be slight change in the reporting and it was to find all the historical datasets from previous month and to append those datasets and make it as final dataset "test_final". All the datasets are in similar fashion and it has ~10K records each.
Appreciate if someone of you guide me to accomplish this exercise.
Hi, is this what you are wanting to do? Set All Datasets in a library in a datastep
Thank you for pointing me in right direction. Now how can I write a code if the requirement has changed like keeping "test_201711" dataset as base and I've to append the datasets (dataset test_201712,dataset test_201801) to the base dataset test_201711?
if you can give an example( 5 to 10 rows) input dataset and output dataset, it will be very easy for help.
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.