Working with ACCESS database without import in SAS formats
1. Create ODBC connection by setting System DSN
2. in SAS create a libname like this:
LIBNAME yourlibname ODBC="yourDSNname";
3. Work with Mdb table like SAS Table.
sample : I have 2 tables in my Access table tab1 tab2 and I wand to create one table with the two.
data yourlibname.tab;
set yourlibname.tab1 yourlibname.tab2
run;
2. in SAS create a libname like this:
LIBNAME yourlibname ODBC="yourDSNname";
3. Work with Mdb table like SAS Table.
sample : I have 2 tables in my Access table tab1 tab2 and I wand to create one table with the two.
data yourlibname.tab;
set yourlibname.tab1 yourlibname.tab2
run;
Commentaires