DM05
SASŪ Techniques to Get the Most out of Oracle ClinicalŪ
David A. Johndrow, Analytical Sciences, Inc.

Many research companies are short on Oracle talent but long on SAS expertise. How can such organizations further benefit from SAS experience within the clinical setting? This presentation will expose an alternative approach to the extraction of clinical da ta from Oracle Clinical to SAS (with a larger role played by SAS programmers). This approach can also potentially have a significant impact on cost. The presentation will also explore how SAS can be employed to tap into the underpinning tables of the Orac le Clinical system, and how this available treasure trove of data can be used within the SAS setting to generate project reports and track study progress. Lastly, the presentation will expand on the creation of custom SAS reports using the newer output for mats available in SAS, via the Output Delivery System (i.e. RTF, HTML), and how these reports can be "tricked" into being intelligent, complete with drill-down features.