topic Re: SET data sets that their names appear in help data set in SAS Programming

SET data sets that their names appear in help data set

Ronein — Mon, 30 Dec 2019 06:12:35 GMT

Hello

I want to create a new data set by set multiple data sets that appear in another data set.

For example:

in data set "helptbl" we can see the names of the data sets that will be in SET statement.

What is the way to tell SAS to using these name for SET statement (without doing it manually...)

data helptbl;
input tblnames;
cards;
tbl190828
tbl190825
tbl190821
tbl190812
tbl190803
;
run;


Data tbl_all;
set tbl190828
tbl190825
tbl190821
tbl190812
tbl190803
;
run;

Re: SET data sets that their names appear in help data set

Kurt_Bremser — Mon, 30 Dec 2019 06:49:01 GMT

CALL EXECUTE does this.

Re: SET data sets that their names appear in help data set

Coooooo_Lee — Mon, 30 Dec 2019 06:49:19 GMT

data helptbl;
input tblnames $9.;
cards;
tbl190828
tbl190825
tbl190821
tbl190812
tbl190803
;
run;

proc sql noprint;
  select tblnames into :tname separated by ' ' from helptbl;
quit;

Data tbl_all;
set &tname.;
run;

Re: SET data sets that their names appear in help data set

ed_sas_member — Mon, 30 Dec 2019 09:18:30 GMT

Hi @Ronein

If you want to append all the datasets beginning by "tbl" of a library, you can directly do this by using the following code :

data want;
	set tbl:;
run;

Otherwise, if you want to append only some of these datasets (which are listed in the helptbl dataset), the solution provided by @Coooooo_Lee would work.