When you click File > Open > ODBC (ODBC-ICON), the SAS/ACCESS® Interface to ODBC is not being used; Microsoft's ADO data access layer is being used. In order for SAS Enterprise Guide to process a task or query by using ODBC-ICON, it must first copy the data to the SAS Enterprise Guide client computer. For large volumes of data, this process can be slow. If you create a library that uses SAS/ACCESS or a database engine on the SAS server, SAS Enterprise Guide does not need to copy the data to the client computer.
To see if you have a SAS/ACCESS product on the SAS server, run the following code:
proc setinit noalias;
run;
To define a libref, execute the following LIBNAME statement from a code window in SAS Enterprise Guide:
libname odbclib odbc dsn=your_DSN_name user=YourUserID password=YourPW;
To access the data from SAS Enterprise Guide after the preceding libref is defined, go to: View > Server List > Server > Libraries > odbclib > then select a table to open.