Main Title |
Managing Large Databases Using SAS and ORACLE. |
Author |
Matheny, R. W. ;
|
CORP Author |
Environmental Protection Agency, Research Triangle Park, NC. National Exposure Research Lab. |
Publisher |
1995 |
Year Published |
1995 |
Report Number |
EPA/600/A-95/148; |
Stock Number |
PB96-139159 |
Additional Subjects |
Statistical analysis ;
Databases ;
Computer programs ;
Environmental data ;
Database management systems ;
Data analysis ;
Relational databases ;
Data retrieval ;
SAS computer software ;
SQL(Structured Query Language) ;
Structured Query Language
|
Holdings |
Library |
Call Number |
Additional Info |
Location |
Last Modified |
Checkout Status |
NTIS |
PB96-139159 |
Some EPA libraries have a fiche copy filed under the call number shown. |
|
07/26/2022 |
|
Collation |
8p |
Abstract |
This paper discusses the principles of database management through the use of SAS/ASSIST to develop SAS/ACCESS code to interface with ORACLE. It examines how EPA is 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. SAS/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. Customized 'views' are 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. Detailed 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. Some commented SAS code (including SQL and appropriate ORACLE commends) are used as examples and discussed at a level appropriate for a beginner user of the SAS language and SAS/ASSIST. |
Supplementary Notes |
See also PB95-155115. |
NTIS Title Notes |
Symposium proceedings. |
Category Codes |
68; 62B |
NTIS Prices |
PC A02/MF A01 |
Primary Description |
600/09 |
Document Type |
NT |
Cataloging Source |
NTIS/MT |
Control Number |
612400420 |
Origin |
NTIS |
Type |
CAT |