topic Re: set dataset with simiar names in SAS Enterprise Guide

set dataset with simiar names

learner_sas — Thu, 22 Jan 2015 20:11:00 GMT

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,

Re: set dataset with simiar names

Reeza — Thu, 22 Jan 2015 20:14:37 GMT

Use a Data Set list or the colon shortcut:

*Combines dsn1 to dsn_5;

data final;

set dsn_1-dsn_5;

run;

*Combines anything that starts with DSN

data final;

set dsn:;

run;

Re: set dataset with simiar names

Astounding — Thu, 22 Jan 2015 20:22:13 GMT

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.