Announcement

Collapse
No announcement yet.

Correct index issue when moving CPDM 3.2.1(SR-3) from SAS 9.1.3 to SAS 9.2

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Correct index issue when moving CPDM 3.2.1(SR-3) from SAS 9.1.3 to SAS 9.2

    Correct index issue when moving CPDM 3.2.1(SR-3) from SAS 9.1.3 to SAS 9.2

    To migrate the ClinPlus Data Management system 3.x to SAS version 9.2 the global system, study system and clinical tables must be re indexed under SAS 9.2. This is due to an issue deleting integrity constraints.

    The attached programs can be used to update the data sets by performing a data step to rewrite the existing tables. The tables can then be re indexed from within the system.

    WARNING:
    • A full backup of all system and study data must be in place before continuing.
    • All users must be out of the system. There must be no user activity in the system when this is performed.



    Programs:

    The following programs are attached to this post - you will need to download these and load them as user report programs.
    • SAS92CPGLOBALUpdate.sas - Updates all system tables in the CPGLOBAL library.
    • SAS92ProjectUpdate.sas - Updates all data sets in the PSYS and PDATA libraries for current study.



    Process:
    1. Install SAS 9.2 and configure system. The SAS Share Service must be reinstalled to use SAS 9.2. Verify that system is functional before continuing.
    2. Load update scripts as user report programs
    3. Run SAS92CPGLOBALUpdate.sas to update global library
    4. Re-index all global tables using system indexing utility
    5. Run SAS92ProjectUpdate.sas on each study to be updated
    6. Re-index all tables in study that was updated



    Details:

    Program: SAS92CPGLOBALUpdate.sas

    This program will recreate the system global data sets that are found in the library CPGLOBAL (...\CPDM root\sysdata) by performing a data step and overwriting the existing tables.


    Define Report in Report Library:

    1. Name: SAS92CPGLOBALUpdate
    2. Type: Normal
    3. Category: System Update
    4. Import this code to the report definition


    Define Template in Report Templates
    1. Name: SAS92CPGLOBALUpdate
    2. Description: optional
    3. Category: System Update
    4. Report type: Global System Data
    5. Program: SAS92CPGLOBALUpdate
    6. No pre- or post-processing or selection criteria are defined


    To update your global library:
    1. Make sure that a full backup of the system is in place before running this code.
    2. Execute this program from System Administration / System Data / Reports
    3. Re-index all system data sets from System Administration / System Data / Data Set Utilities / Index Management



    Program: SAS92ProjectUpdate.SAS

    This program will recreate all of the study System and Clinical data sets by performing a data step and overwriting the existing tables.

    The libraries affected are PSYS and PDATA for each project. Define this program as a user report as follows:


    Define Report in Report Library:

    1. Name: SAS92ProjectUpdate
    2. Type: Normal
    3. Category: System Update
    4. Import this code to the report definition


    Define Template in Report Templates

    1. Name: SAS92ProjectUpdate
    2. Description: optional
    3. Category: System Update
    4. Report type: Multiple Studies
    5. Program: SAS92ProjectUpdate
    6. No pre- or post-processing or selection criteria are defined


    To update your study libraries:

    1. Make sure that a full backup of the system is in place before running this code. Each study directory to be updated must be backed up.
    2. Using Study Information / Reports, execute this program once for each study to be updated.
    3. Using Study Administration / Data Set Utilities Index Management, re-index all of the study System and study Clinical data sets.
    Attached Files
    Last edited by Greg Wagner; 08-12-2010, 03:45 PM.
Working...
X