Combining a PROC SQL View with a SAS Data Set By ... joined to DBMS data by using a Pass-Through query, PROC SQL cannot optimize the query. In this case it is much more efficient to use a SAS/ACCESS ...

The following example shows how to read DBMS data into SAS and create additional variables to perform calculations or subsetting operations on the data. This example creates the SAS data set ...