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.

proc setinit noalias;
run;

libname odbclib odbc dsn=your_DSN_name user=YourUserID password=YourPW;

Operating System and Release Information