SAS Helpful Hints

Biostat Macro Library

The Department of Biostatistics and Computational Biology at the University of Rochester has developed an extension to the SAS software that enables a quick, and easy method for the description and analysis of clinical research databases.
Our goal was to create a set of flexible reporting procedures that would operate on lists of outcome variables from rectangular datasets. We define rectangular datasets as having one observation for each subject visit. These procedures adapt to many treatment and visit schedules, eliminating much of the tedious programming usually required to analyze clinical databases. The analysis procedures have been saved in a SAS macro catalog for ease of use and portability. This small list of reporting procedures is by no means a complete list of the reports necessary to analyze all possible clinical data that may be collected. But it is a good place to start, and will certainly save hours of programming time.

The departments SAS Macro Library is enabled with the following SAS statements:

Libname biostat '\\BIO2\example\SASMacrosWindows';
Options Mstored SasMstore=biostat;

Reporting Procedures:

• Randomization
• Mass Production of Boxplots
• Mass Production of Standard Error Plots
• Chi-Squares
• Anovas
• Survival Analysis
• Ttests
• Kruskal-Wallis
• Auto Tabulate
• Adverse Event Summary
• %Change From Baseline(Chi-Square)
• Finding Outliers
• Data manipulation tools: Deltas and Transpose.
• Misc. Tidbits: (Html,Replay,mean(Std)).

Please send your comments and suggestions about this web page to A. Watts (watts@bst.rochester.edu)