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

[Abraham]

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

[Kurt_Bremser · Accepted solution]

You can use wildcards for dataset names:

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

[PeterClemmensen]

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;

[PeterClemmensen]

@Kurt_Bremser beat me by 8 seconds 😉

[Astounding]

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_: ;

[Astounding]

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