For example in a regular sas program you could do the following:
Code:
LIBNAME test odbc dsn="your dsn name"; data mytest; set test.any_table_in_lib; .... run;
Code:
LIBNAME msacc odbc noprompt="Driver={Microsoft Access Driver (*.mdb)}; DBQ=c:\Your_test_database.mdb";
Now for use with the DM 3.x system. You can set up external libraries using the study setup tool (located under system administration --> studies). Select the study in your source and then select the Libraries tab. Add a library by clicking the add lib icon and fill in the info for description and libname. For the engine select the ODBC engine and in the options column enter the following:
noprompt="Driver={Microsoft Access Driver (*.mdb)};
DBQ=c:\Your_test_database.mdb"
(Make sure that its one line)
You will now have access to an ODBC compliant datasource without setting up a DSN for every computer in your organization.