Hello, I am trying to append or put together numerous SAS datasets (note: every dataset has its own number) into one dataset "FinalData". Here is example of how my SAS datasets look like:
DataSet_<number> and so on...
The problem that I am experiencing is that my program has to somehow look for all those SAS datasets (with different numbers) in my directory folder first before appending them together into one dataset "FinalData". First, my program has to search all datasets look like "DataSet_<number>" available in the directory and than append them into "FinalData". There can be 5 or 500 datasets with the name like "DataSet_<number>" in my directory.
Note: all these datasets have the same variables.
I realized that I can not just use "PROC APPEND" function since I want my program to search for those datasets (with those individual numbers) automatically and than append them into "FinalData" dataset.
Should I use "%sysfunc" within my macro statement? How do I search for an existence of datasets in my directory?
Any examples will really help!