Explains and shows how to use all major features and functionality of SAS/ACCESS interfaces to available relational databases, data warehouse appliances, and distributed applications: LIBNAME, data set, and system options; macro variables; threaded reads; PROC SQL interactions; and numerous examples with output. Contains information common to all DBMSs and a reference section for each DBMS: Aster nCluster, DB2, Greenplum, Hadoop, HP Neoview, Informix, Microsoft SQL Server, MySQL, Netezza, ODBC, OLE DB, Oracle, Sybase, Sybase IQ, Teradata. This title is also available online.SAS Products and Releases: SAS/ACCESS Interface to Aster nCluster: 9.3_M2 SAS/ACCESS Interface to DB2: 9.3_M2 SAS/ACCESS Interface to Greenplum: 9.3 SAS/ACCESS Interface to HP Neoview: 9.3 SAS/ACCESS Interface to Hadoop: 9.3 SAS/ACCESS Interface to Informix: 9.3 SAS/ACCESS Interface to Microsoft SQL Server: 9.3_M2 SAS/ACCESS Interface to MySQL: 9.3_M2 SAS/ACCESS Interface to Netezza: 9.3 SAS/ACCESS Interface to ODBC: 9.3_M2 SAS/ACCESS Interface to OLE DB: 9.3_M2 SAS/ACCESS Interface to Oracle: 9.3 SAS/ACCESS Interface to Sybase: 9.3 SAS/ACCESS Interface to Sybase IQ: 9.3 SAS/ACCESS Interface to Teradata: 9.3_M2 SAS/ACCESS Product of Choice Operating Systems: AllReference, Second Edition SAS Institute. SAS procedures generate SQL for in- database processing for all databases except DB2 in this example. options sqlgeneration=a#39;a#39;; ... Teradata aSQL_FUNCTIONS= LIBNAME Optiona, SAS In- Database Products: Usera#39;s Guide Syntax SQLMAPPUTTO= NONE | SAS_PUT | ( database.
Title | : | SAS/ACCESS 9.3 for Relational Databases |
Author | : | SAS Institute |
Publisher | : | SAS Institute - 2012-08-28 |
You must register with us as either a Registered User before you can Download this Book. You'll be greeted by a simple sign-up page.
Once you have finished the sign-up process, you will be redirected to your download Book page.
How it works: