OLS : Record


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
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)
Library   Call Number Additional Info Location Date Modified
NTIS PB95-155115 Most EPA libraries have a fiche copy filed under the call number shown. Check with individual libraries about paper copy. NTIS 05/26/1995
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.
Category Codes 68; 62B
NTIS Prices PC A02/MF A01
Primary Description 600/09
Document Type NT
Control Number 504716131
Cataloging Source NTIS/MT
Origin NTIS
Type CAT