Abstract |
SAS is an EPA standard data and statistical analysis software package while ORACLE is EPA's standard data base management system software package. ORACLE has the advantage over SAS in data retrieval and storage capabilities but has limited data and statistical analysis capability. SAS, on the other hand, is inefficient for data retrieval and storage of data but contains almost every conceivable statistical procedure. Thus, linking SAS with ORACLE offers the advantages of both packages and eliminates the major disadvantages associated with each package. The paper discusses how the SAS procedures can be used on the UNIX platform to link the SAS system with the ORACLE system. Instead of producing new SAS datasets from ORACLE tables, this approach reads ORACLE data directly and uses them as if they were SAS data. |