Desktop productivity for business analysts and programmers

set dataset with simiar names

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 89
Accepted Solution

set dataset with simiar names

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,


Accepted Solutions
Solution
‎01-22-2015 03:14 PM
Super User
Posts: 19,038

Re: set dataset with simiar names

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;

View solution in original post


All Replies
Solution
‎01-22-2015 03:14 PM
Super User
Posts: 19,038

Re: set dataset with simiar names

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;

Super User
Posts: 5,353

Re: set dataset with simiar names

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.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 284 views
  • 1 like
  • 3 in conversation