You are here:
MANAGING LARGE DATABASES USING SAS AND ORACLE
Citation:
Matheny, R. MANAGING LARGE DATABASES USING SAS AND ORACLE. U.S. Environmental Protection Agency, Washington, D.C., EPA/600/A-95/148 (NTIS PB96139159).
Description:
This aper iscusses the rinciple f atabase anagement hrough the use of SAS/ASSIST to develop SAS/ACCESS code to interface with ORACLE. t examines how EPA in beginning to use the SAS interface to ORACLE to invoke interactive and batch processing for data entry, editing, updating, automatic report generation, and custom report generation functions. AS/ACCESS is used to efficiently store the data in ORACLE, using about a third of the memory that SAS databases require and the code is written mostly through SAS/ASSIST. ustomized "views" re developed using PROC SQL with PROC/ACCESS and SAS/ASSIST to efficiently manage extraction of the data from the ORACLE database into SAS for a variety of purposes, specifically database management and statistical/ graphical analysis. etailed sample programs are not presented which demonstrate the basic principles since SAS/ASSIST uses a mouse with point-and-click screens involved so potential users may implement the concepts effectively and efficiently. ome commented SAS code (including SQL and appropriate ORACLE commends) are used as examples and discussed at a level appropriate for an beginner user of the SAS language and SAS/ASSIST. his paper has been reviewed in accordance with the United States Environmental Protection Agency's pear and administrative review policies and approved for presentation and publication. ention of trade names or commercial products does not constitute endorsement or recommendation for use.