To query a Microsoft SQL Server table on a linked server with SAS/ACCESS^® Interface to ODBC, you need to use pass-through statements in the SQL procedure similar to those shown in the following example. You must also specify the full, four-part table name in the query that accesses the table.

You can use these same PROC SQL pass-through statements when you use SAS/ACCESS^® Interface to OLE DB to query a linked table.

Operating System and Release Information