can we import files with same names at once

[rkolupoti9001]

Hi, Am having a set files like master_1,master_2,master_3.........,master_n in access database.Can we import them all at a time something like master%.

Thanks in advance!!!!

[ballardw]

Do you want to import them into the same dataset or individual sets?

[rkolupoti9001]

Into same dataset

[ballardw · Accepted solution]

Using the LIBNAME access to your database

LIBNAME mdb ACCESS "pathtodatabase\databasename.accdb" ; or mdb as appropriate

Data Mysasdatsset;

     set mdb.master: ;

run;

might do it

[rkolupoti9001]

It worked Thank you!!!