Record Display for the EPA National Library Catalog


Main Title Managing Large Databases with Customized SAS Windows.
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/147;
Stock Number PB96-139142
Additional Subjects Statistical analysis ; Databases ; Computer programs ; Environmental data ; Database management systems ; Data analysis ; Relational databases ; Data retrieval ; SAS computer software ; SQL(Structural Query Language) ; Structured Query Language
Internet Access
Description Access URL
Library Call Number Additional Info Location Last
NTIS  PB96-139142 Some EPA libraries have a fiche copy filed under the call number shown. 07/26/2022
Collation 13p
This paper discusses the principles of database management through customized windows using SAS/AF, particularly PROC BUILD, to invoke interactive and batch processing of data entry, editing, updating, automatic report generation, and custom report generation functions, including graphics. SAS/ACCESS is used to efficiently store the data in ORACLE using about a third of the memory that SAS databases require. Customized 'views' are developed using PROC SQL with PROC/ACCESS and BASE/SAS to efficiently manage extraction of the data from the ORACLE database into SAS for a variety of purposes. Security from both the ORACLE and SAS sides is discussed as it relates to a network of personal computers and Unix workstations and Unix servers including storage of data on different Unix machines to allow more effective controlled access to the data. This paper also gives users a detailed skeleton of the manual, automated data entry and quality assurance procedures that may be needed for proper database management before customized windows are used.