As the first step in the decommissioning of the site has been converted to read-only mode.

Here are some tips for How to share your SAS knowledge with your professional network.

Romancing Your Data: The Getting-To-Know-You Phase

From sasCommunity
Jump to: navigation, search


The ability to gather and store large amounts of data has become commonplace. As these capabilities have grown, so has database complexity. The deluge of corporate acquisitions further complicates things, driving more undocumented data sources into the hands of new database users, often without the institutional knowledge to go with them. Thus, analysts must develop the ability to discover the complexity of a database on their own.

This paper focuses on Oracle® databases and use of SAS/ACCESS® Interface to ORACLE to explore the Oracle Data Dictionary Views that contain the database metadata. We focus on metadata summaries of interest to a user new to the database. The metadata is presented through a series of programs that use Base SAS®, specifically the SQL Procedure, macro language, and the Output Delivery System (ODS).

The target audience for this paper includes anyone who uses Oracle databases to solve business problems. Some basic understanding of Base SAS PROC SQL, macro language, and the SAS/ACCESS Interface to ORACLE product is helpful, but not required.

Online Materials

View the pdf for the paper SAS Global Forum 2011, Paper 133

Code contained in Paper 133. Download the file and unzip it.

Contact Info