| 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 |
|
| Holdings |
| Library |
Call Number |
Additional Info |
Location |
Last
Modified |
Checkout
Status |
| NTIS |
PB96-139142 |
Some EPA libraries have a fiche copy filed under the call number shown. |
|
07/26/2022 |
|
| Collation |
13p |
| Abstract |
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. |
| NTIS Title Notes |
Symposium proceedings. |
| Category Codes |
68; 62B |
| NTIS Prices |
PC A03/MF A01 |
| Primary Description |
200/04 |
| Document Type |
NT |
| Cataloging Source |
NTIS/MT |
| Control Number |
612400410 |
| Origin |
NTIS |
| Type |
CAT |
