• Home
  • Profile
  • Papers
  • SAS programs

Papers
  • Web-enabling the Pharmaceutical Sector
  • Using the SAS® Information Delivery Portal in the Pharmaceutical sector
  • Migration of a Flexible Reporting System from SAS 6.12 to SAS 9.1.3
Home Papers

Migration of a Flexible Reporting System from SAS 6.12 to SAS 9.1.3

Article Index
Migration of a Flexible Reporting System from SAS 6.12 to SAS 9.1.3
Applications to migrate - FRS
Applications to migrate - HDS
The Data and FRS and HDS within NOTOX
The migration project
Technology
The migrated FRS system
Project metrics / lessons learned/ tips
Page 2 of 8

3. Overview of the applications to migrate


3.1 FRS (SAS version6.12)

3.1.1 Background

The FRS is a Flexible Reporting System created with SAS version 6.12. The main function of the FRS is to provide a flexible reporting environment for pre-clinical toxicology and reproductionstudies. The application has been created because the existing data entry system had insufficient reporting capabilities to satisfy client needs. The application is created using SAS Base, SAS Macro, SAS/AF®, SAS/GRAPH® and SAS/STAT®.

3.1.2 The application

Access to the application is regulated via a logon procedure. Once logged on the user can select the study type to report on (toxicology/acute toxicology/reproduction).

3.1.3 Report selection screens

When the study type is selected, the user has to specify the project number to report on. If this is a valid project number, the available tables and graphs for this study type are shown. From this screen the user can select the table(s) and/or graph(s) to be generated. It also allows the user to set some general parameters such as page number to start with, the title of the report and the output type (word document or PDF document).

FRS-migration-1

3.1.4 Report info screen

For each table or graph selected a screen is displayed allowing the user to customise this particular table or graph. Most of the options presented on the screen are derived from the available project data. A default selection is presented, allowing the user to customise when required. Some typical options the user can select or change are:

  • The title of the table or graph;
  • The reporting period;
  • The number of decimals;
  • Whether to calculate statistics or not.

FRS-migration-2

3.1.5 Output

Once all selected tables and graphs are processed, the results are exported to the selected output medium (word document or PDF document). This is stored on a pre-defined network area.

FRS-migration-3


<< Prev - Next >>

 

© 2010 Raymond Ebben, expert SAS consultant and programmer, Netherlands All Rights Reserved.