Importing from Microsoft Access

[NazaninSAS]

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

[PGStats]

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.