Skip to Main Content
Base SAS 9.4 Procedures Guide, Third Edition
book

Base SAS 9.4 Procedures Guide, Third Edition

by SAS Institute
August 2014
Intermediate to advanced content levelIntermediate to advanced
2218 pages
209h 16m
English
SAS Institute
Content preview from Base SAS 9.4 Procedures Guide, Third Edition
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Base SAS 9.4 Procedures Guide, Second Edition

Base SAS 9.4 Procedures Guide, Second Edition

SAS Documentation
Oracle® Database 10g Insider Solutions

Oracle® Database 10g Insider Solutions

Arun Kumar R., John Kanagaraj, Richard Stroupe

Publisher Resources

ISBN: 9781629593043