topic Re: copy multiple datasets in SAS Programming

copy multiple datasets

hhchenfx — Sun, 24 Jun 2018 17:38:36 GMT

Hello Everyone,

Is there any way to shorten the below code since all "have" files are from the same lib?

Thank you,

HHCFX

data want; set libname.have1 libname.have2 libname.have3 libname.have4;run;

Re: copy multiple datasets

Kurt_Bremser — Sun, 24 Jun 2018 17:58:06 GMT

Use a wildcard:

set libname.have:;

Re: copy multiple datasets

hhchenfx — Sun, 24 Jun 2018 17:59:36 GMT

oh, my example is a bit mis-leading.
the file I have are not all share the same name.
it is random, say ab1 cd3 dxyz22
Hoang

Re: copy multiple datasets

Kurt_Bremser — Sun, 24 Jun 2018 18:02:38 GMT

Then there's no way to reduce the set statement. Unless you have some criteria that helps you in selecting your datasets from dictionary.tables and putting all dataset names (including the library) into a macro variable.

Re: copy multiple datasets

hhchenfx — Sun, 24 Jun 2018 18:05:12 GMT

Thanks for your info.

I hope it could be something like libname.( list of datasets...);

Re: copy multiple datasets

pjpnk — Sun, 24 Jun 2018 18:10:23 GMT

Yes, this should be achieved, because you already have the data sets which are in numbered range lists. You can try below:

data want; 
   set libname.have1-libname.have4;
run;

Re: copy multiple datasets

novinosrin — Sun, 24 Jun 2018 18:20:49 GMT

Hi @hhchenfx Try to read the dataset names from dictionary tables and create a list macrovar. Then call the macrovar in your set statement. This can help you avoid typing

Re: copy multiple datasets

Reeza — Sun, 24 Jun 2018 19:33:50 GMT

Following up on @novinosrin suggestion:

%let myLib=WORK;

proc sql noprint;
select catx(".", "&myLib",  memname) into :name_list separated by " "
from sashelp.vtable
where libname=upcase("&myLib.");
quit;


data want;
set &name_list;
run;

This approach works if you have less than 1500+ variables due to the length restrictions of a SAS macro variable.

@hhchenfx wrote:

Hello Everyone,

Is there any way to shorten the below code since all "have" files are from the same lib?

Thank you,

HHCFX

data want; set libname.have1 libname.have2 libname.have3 libname.have4;run;