
Using the FEDSQL Procedure
Data Source Connection
PROC FEDSQL connects to a data source by using the attributes of currently assigned
librefs. Attributes include the physical location of the data, and for some data sources,
access information such as network information used to access the data server, and user
identification and password.
You first submit the LIBNAME statement for a SAS engine and then submit PROC
FEDSQL. The supported engines include BASE (V9, V8, and V7), SPD Engine, and the
SAS/ACCESS engines Aster, DB2, Greenplum, Microsoft SQL Server, MySQL,
Netezza, ODBC, Oracle, SAP, Sybase IQ, and Teradata.
This example illustrates how PROC ...