Everyone who can spell SAS knows how to use PROC PRINT. It's primary use may be as a development tool to help in debugging a long multi-step program, or as a simple report generator when all that is really needed is a quick look at the data, or even a basic low-level finished report. However, if a report generation/information delivery tool with powerful formatting, summarizing and analysis features is called for, then PROC REPORT is the solution. PROC REPORT can provide the standard PROC PRINT functionality, but in addition, can easily perform many of the tasks that you would otherwise have to use the SORT, MEANS, FREQ and TABULATE procedures to accomplish. PROC REPORT is part of the Base SAS product, can run in both an interactive screen-painting mode or a batch mode, and should be the basic tool of choice when there is a need to produce powerful and productive reports from SAS data sets. This paper will present the basics of PROC REPORT (non-interactive mode) through a series of progressively more sophisticated examples of code and output.

Ray Pass is a SAS consultant with ASG, Inc. and has been using the SAS System for too many years. He is the co-author, with Ron Cody, of Programming SAS by Example (1995) and has delivered many invited papers at national, regional and local SAS user groups. Ray's primary areas of expertise in the SAS System are report generation and data manipulation.In addition to teaching SAS courses, Ray has also been quite active in organizing and participating in SAS user group activities on various levels. Ray was one of the founders of both the New York Area SAS Users Group (NYASUG) and the NorthEast SAS Users Group (NESUG.) Ray co-chaired the first two NESUG annual conventions ('88, '89) and has been a Section Chair at many SAS User Group International (SUGI) annual conventions.

Daphne Ewing (co-author of this paper) is a Director, Biometrics at IBAH, Inc., a Clinical Research Organization in the Philadelphia area. She holds a B.S. in Computer Science Engineering from the University of Virginia. Daphne has almost 10 years of pharmaceutical data processing experience, including 8 years of SAS programming in the CMS, VMS, DOS and Windows environments. Daphne is a member of the PhilaSUG Executive Committee, the NorthEast SAS Users Group Executive Committee, and has presented at the local, regional and national level. Daphne was the NESUG '96 = Conference Co-Chair.

The transfer from legacy software to new information systems is a daunting task in any company. The Pharmaceutical industry is no exception. This paper chronicles our company's efforts in performing a thorough evaluation of the SAS/ PH-Clinical Version 2.01 software product. It describes how the product was tested, what knowledge about the product was gained, and how this information was utilized to formulate a recommendation concerning the use of PH-Clinical as a reporting tool. Issues concerning the use of SAS PH-Clinical in a many-user environment are also discussed.

Phil Giangiulio is a Clinical Analyst/Programmer at SmithKline Beecham Pharmaceuticals. For the past seven years, he has supported the reporting of clinical studies and electronic submissions to regulatory authorities, utilizing SAS software including SAS macros, various SAS procedures, and most recently SAS PH-Clinical. Phil received a BS degree in Medical Technology from Hahnemann University in 1982, and an MS degree in Computer Science from Villanova University in 1990.

The paper presents the applications of PH-Clinical in clinical trials reporting and analysis, and describes how clinical researchers can utilize its capabilities to analyze and explore the information with timeliness and efficiency during the drug development process.

Since it is essential to extract useful information from the vast amount of data collected, statistical report generation is a representative and usually time consuming activity in the world of clinical research and development. PH-Clinical, a data review and analysis tool developed by SAS Institutes, provides the functionalities of a data browser, a query builder, as well as a flexible reporting system that is capable of creating templates which users can invoke and customize in a visual interface environment. Instead of receiving and reviewing reports printed on stacks of paper, the clinical scientists can view them on-line within the same system that is used for the generation of those displays.

In addition, the paper discusses how a subset of an organization's internal reporting system can readily be developed into a Computer-assisted New Drug Application (CANDA). Coupled with concepts of data warehousing, practical and beneficial data querying and report generation tools can greatly shorten the development time and improve the quality of a drug submission.

Eileen Ching is a Clinical Applications Programmer/Analyst at SmithKline Beecham Pharmaceuticals responsible for clinical applications programming in clinical trials research and development. Her five years of industry experience includes SAS-based clinical and statistical reporting, applications design and development, and various drug submission support including CANDA project development.

Rosemary Oakes, a Biostatistician at SmithKline Beecham Pharmaceuticals, is responsible for input into clinical study design, statistical programming and analysis, and interpretation of results for clinical drug development. Her six years of statistical experience includes statistical reporting methodology, SAS macro and report programming, SAS graphical data presentation, and statistical support of drug submissions to international regulatory agencies.

The Web has promised to make information delivery easy and cost effective. SAS has delivered on that promise with its tools for web publishing and interactive, dynamic applications. Today we will take a look at SAS's Web Publishing tools and SAS/Intrnet, a product for the dynamic execution of SAS programs from a web browser environment.

Dave Danyluk is a Systems Engineer in the New Jersey Regional Office located in Bedminster, NJ. Dave has been with the SAS Institute for 3 years. He started out his career at SAS working out of the Philadelphia Office, although his responsibilities have always been the support of both New Jersey and Delaware.

This poster presents a step by step of exporting SAS list and graphics output onto the World Wide Web. The discussion includes but not limited to:

• Preparing SAS list and graphics output,
• Inserting your SAS list into HTML code,
• Providing a SAS macro code to generate HTML code automatically
• Converting SAS graphics GSF format to GIF format
• Illustrating a point and click Web pages with SAS output

The SAS products used in this poster are: SAS BASE® and SAS/GRAPH® with no limitation of operating systems.