01-22-2015 03:11 PM
I want to combine different datasets which have similar name or started with same names. For example. I have dsn_1,dsn_2,dsn_3..............,dsn_99 and I want to set all of the datasets into one. Variables have same attributes and names across the datasets.
I am using data final; set dsn_1 dsn_2 dsn_3 dsn4...........dsn5;run; or proc sql with union all options. I been doing this but it takes long time since I have to combine significant number of datasets. I am wondering if there is a easier way so that I do not have to change datasets name each time I have new data.
01-22-2015 03:22 PM
If you save the combined file, it's quick and easy:
proc append base=combined_file data=new_file;
This program requires that the variable definitions are identical.
Need further help from the community? Please ask a new question.