Desktop productivity for business analysts and programmers

can we import files with same names at once

Accepted Solution Solved
Reply
Contributor
Posts: 21
Accepted Solution

can we import files with same names at once

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!!!!


Accepted Solutions
Solution
‎01-15-2015 03:14 PM
Grand Advisor
Posts: 10,210

Re: can we import files with same names at once

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

View solution in original post


All Replies
Grand Advisor
Posts: 10,210

Re: can we import files with same names at once

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

Contributor
Posts: 21

Re: can we import files with same names at once

Into same dataset

Solution
‎01-15-2015 03:14 PM
Grand Advisor
Posts: 10,210

Re: can we import files with same names at once

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

Contributor
Posts: 21

Re: can we import files with same names at once

It worked Thank you!!!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 298 views
  • 0 likes
  • 2 in conversation