Importing from Microsoft Access

NazaninSAS — Wed, 21 Nov 2018 19:37:45 GMT

Hi I have the following codes to import two tables. however, I'm looking for merging two proc together

proc import dbms=accesscs datatable='RV18NOV'

out=work.RV18NOV replace;

database="P:\Demographics\Demographics Team\Suzanne\MDP PARTAGE.mdb";

run;

proc import dbms=accesscs datatable='FUNWSG_RV18NOV'

out=work.FUNWSG replace;

database="P:\Demographics\Demographics Team\Suzanne\MDP PARTAGE.mdb";

run;

how can I merge these two Procs together to be able to import two tables at the same time?

Thanks,

Nazanin

Re: Importing from Microsoft Access

PGStats — Wed, 21 Nov 2018 19:59:08 GMT

You can't.

Two alternatives are:

If the two tables are to be joined, create the join as a view in Access and IMPORT data into a SAS dataset from the view.
Define a libname pointing to the Access database and query the tables in the database as if they were SAS tables using that libname.