TU08
Customized Reports - Have It Your Way!
Invited
Deb Cassidy
Cardinal Distribution
Abstract:
This presentation will cover some examples to create a report just the way you need it. Two main areas will be covered. The first area will be manipulating the raw data to provide what you really need. The second area will focus on formatting the text with
in the report. Different methods will be explored to try to accomplish the same report. This exploration will discuss factors to help you decide which method may be best for your next custom report.
The examples covered will be creating an evaluation form
and a letter to report the evaluation results to the individuals being evaluated. While this might sound simple, the actual requirements might throw you a few curves. For example, the letter needs to contain the individual's score, a group average and an
overall average.
Some of the code shown will include the use of DATA _NULL_, PROC REPORT, ODS, and PROC MEANS as well as combining and splitting data into the variables you really need. Some of the methods shown will involve export data to Excel or Word f
or the final formatting. This presentation is intended as a overview of some of the many things you can do to create customized reports.
Biography:
Deb Cassidy works for Cardinal Distribution, the pharmaceutical distribution division of Cardinal Health. She primarily uses SAS Software for general reporting (including web-based static reports) and data analysis. Within the company, she is known for usi
ng SAS software for projects that can't easily be done with other available software because of the complexity of the underlying data. Others within the company also do statistical modeling and sampling.