topic Re: Copy all tables beginning with certain keyword from one lib to other in SAS Programming

Copy all tables beginning with certain keyword from one lib to other

Abraham — Mon, 18 Mar 2019 12:02:26 GMT

Hi,

I wanto to copy all tables that begin with keyword AB (e.g. AB_tabl1, AB_emp, AB_department etc..) from library "Slave" into the master library "Master".

I tried with Proc copy which is working but I need to mention the table name which I dont want. Is there any approach to find it

Thanks

Re: Copy all tables beginning with certain keyword from one lib to other

Kurt_Bremser — Mon, 18 Mar 2019 12:20:39 GMT

You can use wildcards for dataset names:

proc copy inlib=slave outlib=master;
select ab:;
run;

Re: Copy all tables beginning with certain keyword from one lib to other

PeterClemmensen — Mon, 18 Mar 2019 12:20:47 GMT

I think PROC COPY with the : Operator is the way to go? Does this solve your problem?

proc copy in=Slave out=Master memtype=data;
   select AB:;
run;

Re: Copy all tables beginning with certain keyword from one lib to other

PeterClemmensen — Mon, 18 Mar 2019 12:21:29 GMT

@Kurt_Bremser beat me by 8 seconds 😉

Re: Copy all tables beginning with certain keyword from one lib to other

Astounding — Mon, 18 Mar 2019 12:23:25 GMT

Presumably you have set up the PROC COPY, but need to know how to select just the tables of interest. Here is the way to ask for that list:

select AB_: ;

Re: Copy all tables beginning with certain keyword from one lib to other

Astounding — Mon, 18 Mar 2019 12:25:35 GMT

I'm the sluggard using the handheld: 3 minutes late.