set dataset with simiar names

[learner_sas]

Hello Everybody,

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.

Thank you,

[Reeza · Accepted solution]

Use a Data Set list or the colon shortcut:

*Combines dsn1 to dsn_5;

data final;

set dsn_1-dsn_5;

run;

or

*Combines anything that starts with DSN

data final;

set dsn:;

run;

[Astounding]

If you save the combined file, it's quick and easy:

proc append base=combined_file data=new_file;

run;

This program requires that the variable definitions are identical.

Good luck.