Record Display for the EPA National Library Catalog

RECORD NUMBER: 87 OF 146

Main Title Interfacing SAS to Oracle in the UNIX Environment.
Author Matheny, R. W. ;
CORP Author Environmental Protection Agency, Research Triangle Park, NC. Atmospheric Research and Exposure Assessment Lab.
Publisher 1994
Year Published 1994
Report Number EPA/600/A-94/250;
Stock Number PB95-155115
Additional Subjects US EPA ; Computer software ; Data base management systems ; Relational data bases ; Data processing ; Statistical analysis ; UNIX(Operating system) ; Query languages ; Data analysis ; Data storage ; Data retrieval ; Linking systems ; SAS computer software ; ORACLE computer software ; SQL(Structured Query Language)
Holdings
Library Call Number Additional Info Location Last
Modified
Checkout
Status
NTIS  PB95-155115 Some EPA libraries have a fiche copy filed under the call number shown. 07/26/2022
Collation 7p
Abstract
SAS is an EPA standard data and statistical analysis software package while ORACLE is EPA's standard data base management system software package. ORACLE has the advantage over SAS in data retrieval and storage capabilities but has limited data and statistical analysis capability. SAS, on the other hand, is inefficient for data retrieval and storage of data but contains almost every conceivable statistical procedure. Thus, linking SAS with ORACLE offers the advantages of both packages and eliminates the major disadvantages associated with each package. The paper discusses how the SAS procedures can be used on the UNIX platform to link the SAS system with the ORACLE system. Instead of producing new SAS datasets from ORACLE tables, this approach reads ORACLE data directly and uses them as if they were SAS data.