User manual SAS CLINICAL DATA STANDARDS TOOLKIT 1.3 INSTALLATION QUALIFICATION

[. . . ] SAS Clinical Data Standards Toolkit 1. 3 Installation Qualification ® The correct bibliographic citation for this manual is as follows: SAS Institute Inc. SAS ® Clinical Data Standards Toolkit 1. 3: Installation Qualification. SAS® Clinical Data Standards Toolkit 1. 3: Installation Qualification Copyright © 2010, SAS Institute Inc. , Cary, NC, USA All rights reserved. Produced in the United States of America. [. . . ] The data set should contain 14 records and the last record should report "Process completed successfully. " There should be 33 new SAS data sets. The data set dm should have 70 records and 20 columns. 5 Review the folder CST_SDTM_312/derived/data. 6 End the current SAS session. Sign-off Test 6 ­ SDTM 3. 1. 2 Build Source Data Signature Date Test Was Executed Did the test pass?(Yes or No) Comments Test 6 ­ SDTM 3. 1. 2 Build Source Metadata This test references derived data from a CRT-DDS (define. xml) file to build a set of SDTM 3. 1. 2 metadata in a structure required by SAS Clinical Standards Toolkit. Steps 1 2 Start a new SAS session. In the SAS Program Editor, select File->Open and select CST_SDTM_312/programs/create_sourcemetadata. sas. This code outputs to the SAS log and creates data sets in both the results and derived/metadata subfolders under CST_SDTM_312. As in Test 5, the library information was cleaned up by the program, so these files are not immediately accessible under Libraries in the SAS Explorer. In Windows, you can access these files through the SAS Explorer by navigating from within the SAS Explorer starting at the node labeled "My Computer. " On UNIX, it is necessary for you to copy these data sets into a folder that is viewable by the SAS Explorer. Installation Qualification / / Test 7 ­ SDTM 3. 1. 2 Build SAS Formats 9 3 4 Review the log to see whether there are any errors or warnings. Review the data set named srcmeta_results under CST_SDTM_312/results. For the records where the column labeled "validation check identifier" (named checkid) is blank, examine the message column and check for correct paths and process metadata. The column labeled "process status" (named _cst_rc) should be 0 for all records. The last three records should report that study reference data was created in folder CST_SDTM_312/derived/metadata. There should be three new data sets: source_columns, source_study, source_tables. The data set named source_tables should have 33 records. 5 Review the folder CST_SDTM_312/derived/metadata. 6 End the SAS session. Sign-off Test 3 ­ SDTM 3. 1. 1 Build Source Metadata Signature Date Test Was Executed Did the test pass?(Yes or No) Comments Test 7 ­ SDTM 3. 1. 2 Build SAS Formats This test referenced derived data from a CRT-DDS (define. xml) file to build a SAS format catalog that represents the codelists in the CRT-DDS file. Steps 1 2 Start a new SAS session. In the SAS Program Editor, select File->Open and select CST_SDTM_312/programs/create_formatsfromcrtdds. sas. The code outputs to the SAS log and creates a data set named codelist_results in CST_SDTM_312/results and creates a catalog named cterms under CST_SDTM_312/derived/formats. As in Tests 5 and 6, the library information was cleaned up by the program so these files are not immediately accessible under Libraries in the SAS Explorer. In Windows, you can access these files through the SAS Explorer by navigating from within the SAS Explorer starting at the node labeled "My Computer. " On UNIX, it is necessary for you to copy these data sets into a folder that is viewable by the SAS Explorer. Review the log to see whether there are any errors or warnings. Review the data set named codelist_results under CST_SDTM_312/results. 3 4 10 Test 8 ­ SDTM 3. 1. 2 Report Check Metadata Chapter 1 For the records where the column labeled "validation check identifier" (named checkid) is blank, examine the message column and check for correct paths and process metadata. The column labeled "process status" (named _cst_rc) should be 0 for all records and there should not be any checks with result severity='Warning: Check not run'. The last record should report "Process completed successfully. " 5 6 Folder CST_SDTM_312/derived/formats should contain a catalog cterms (named cterms. sas7bcat). Open cterms and verify that it has 48 formats. [. . . ] You can also view these data sets in the SAS Explorer in the library named Srcmeta. The data set source_tables should have 52 rows and 10 columns. The data set source_columns should have 241 rows and 15 columns. The data set codelists should have six records and five columns. 6 Review the folder CST_ODM/data. 7 End the current SAS session. Sign-off Test 11 ­ ODM1. 3. 0 Create SAS ODM From XML Signature Date Test Was Executed Did the test pass?(Yes or No) Comments Test 12 ­ Controlled Terminology 200810 This test verifies that the controlled terminology package 200810 has been installed and is available to SAS Clinical Standards Toolkit processes. Steps 1 2 Start a new SAS session. [. . . ]