Managing Large Databases with Customized SAS Windows

摘要

This paper discusses the principles of database management through customizedwindows 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.