Skip to main content
ARS Home » Research » Publications at this Location » Publication #179667
Title: DATABASE ACCESS BASICS: SQL AND DATA STEP INTERFACE TO RELATIONAL DATABASES

Author
item Sanders, Ashley

Submitted to: Proceedings of SAS Users Group
Publication Type: Abstract Only
Publication Acceptance Date: 8/1/2005
Publication Date: 9/11/2005
Citation: Sanders, A.H. 2005. Database access basics: SQL and data step interface to relational databases [abstract]. Proceedings of 18th Annual Northeast SAS Users Group Conference, September 11-14, 2005, Portland, Maine. p. 56-57.

Interpretive Summary:

Technical Abstract: SAS/ACCESS provides virtually seamless interaction with relational databases such as DB2. The SQL pass-through facility gives direct access to the database, but requires knowledge of the native SQL syntax. Alternately, the libname statement can be used to assign SAS library references to database objects, allowing database tables to be used like SAS datasets. SAS SQL functions are available that cannot be used with the pass-through facility. For data step diehards, database tables can be treated (almost) just like indexed SAS datasets. SAS statistical procedures can also reference database tables directly using the libref name. This paper covers the basics of accessing database data from SAS using SQL and data step language, using the database with SAS procedures, and getting information about the database delivered through SAS.