You often need data that are stored in separate tables. For example, you may want to produce a report that gets information about flight delays from one table and boarding capacity from another.
Combining a PROC SQL View with a SAS Data Set By Using the Pass-Through Facility This example joins SAS data with CA-OpenIngres data that is retrieved by using a Pass-Through query in a PROC SQL ...