topic Re: can we import files with same names at once in SAS Enterprise Guide

can we import files with same names at once

rkolupoti9001 — Thu, 15 Jan 2015 19:46:59 GMT

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

Re: can we import files with same names at once

ballardw — Thu, 15 Jan 2015 19:58:43 GMT

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

Re: can we import files with same names at once

rkolupoti9001 — Thu, 15 Jan 2015 20:01:13 GMT

Into same dataset

Re: can we import files with same names at once

ballardw — Thu, 15 Jan 2015 20:14:27 GMT

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

Re: can we import files with same names at once

rkolupoti9001 — Thu, 15 Jan 2015 20:34:57 GMT

It worked Thank you!!!