CDISC Builder™ 2.1 - Installation Test Scripts - Findings

 

The following documentation contains test scripts and expected results for validating the Findings tool.  Do the following to verify proper installation:

  • Start CDISC Builder application by double clicking on the desktop icon.
  • Perform each test by performing the steps specified by the instructions.  
  • Evaluate the results of each step by comparing them with results described in the Documentation column. 
Script Description Documentation
Source Data
  • Type invalid path
  • Navigate to location with no SAS datasets
  • Path name that is longer than 200 characters
  • Use [...] path navigation
Instructions 1  
Data Sets
  • List of datasets match what is in the selected path
  • Verify preview button with a separate PROC PRINT
Instructions 2
Original Source Variables
  • Verify the list of variables reflect those from selected dataset.  Do this through PROC CONTENTS.
  • Verify select all button toggle
Instructions 3
Test Variables
  • Verify the variables are added and removed using << and >> buttons.
  • Verify select all button toggle
Instructions 4
Additional Variables
  • Verify the variables are added and removed using << and >> buttons.
  • Verify select all button toggle
Instructions 5

Related Domain

  • Verify list of domains matches list in documentation.
  • If CDISC dataset is selected, related domain is defaulted.
Instructions 6

Study Identifier

  • Verify name with special character such as comma and quotes.
  • Name cannot longer than 10.
Instructions 7
Unique Subject ID
  • List of variables match what is in the selected dataset.  Verify via PROC CONTENTS. 
  • Default to the first "Subject" variable it finds.   
Instructions 8
Output
  • The [...] library manager returns the last libname selected 
Instructions 9
OK/Cancel
  • OK button applies all selected parameters.
  • Memory of all fields are retained.
  • Cancel does not apply logic.
Instructions 10
Save Code
  • Program is saved with proper comments
  • Generated program is submitted and results verified
Instructions 11

Instructions 1
Start the CDISC BUILDER from the icon on desktop.

  1. Create the following path if it does not already exist.
    c:\temp\cdiscbld\input\findings
    c:\temp\cdiscbld\output\findings
     

  2. Click on the [...] button next to the Output library field.

  3. Create the following library name in the library manager screen if they do not already exist.

    Library Name: intest
    Path: c:\temp\cdiscbld\input\findings

    Library Name: outtest
    Path: c:\temp\definedoc\output\findings
     

  4. Click on the Back to close the library manager screen.

  5. Submit the following program:

    libname testlib 'c:\temp\cdiscbld\input\findings';

    data testlib.shoes;
    set sashelp.shoes;
    run;
    data testlib.company;
    set sashelp.company;
    run;
    data testlib.manage;
    set sashelp.manage;
    run;
     

  6. Click on the FINDINGS icon from the main screen.

  7. Enter a path which does not exist into Source Data field and hit Enter.

  8. Verify that there is a error message saying that "Source Data does not exist.".

  9. Close the message dialog.

  10. Click on the [...] button next to the Source Data field.

  11. Browse to a directory which does not contains any datasets and click OK.

  12. Verify that there is a warning message saying that "There is no dataset in this path.".

  13. Close the message dialog.

  14. Create a directory with the name longer than 244 characters.

  15. Copy three datasets from findings directory into this directory.

  16. Click on the [...] button.

  17. Browse to the long-name directory and click OK.

  18. Verify that there is a warning message saying that "You cannot select a path longer than 200 characters using Select dialog. Please enter the path directly to the Source Data field.".

  19. Close the message box.

  20. Enter the path directly into the Source Data path and hit Enter.

  21. Verify that there is a message saying that "You cannot type the path longer than 244 characters. Enter the other path.".

  22. Shorten the long-name directory to shorter than 244 characters.

  23. Enter the path and hit Enter.

  24. Verify that there is no warning or error message.

  25. Verify that all datasets in the long-name directory have been listed in the dataset list.

  26. Click on Cancel and then Exit to close the application.

Instructions 2
Start the CDISC BUILDER from the icon on desktop.

  1. Click on the FINDINGS icon from the main screen.

  2. Select C:\temp\cdiscbld\input\findings as Source Data.

  3. Verify that all the datasets in the findings directory are listed in the dataset list.

  4. Select COMPANY from the dataset list.

  5. Click on the Preview button.

  6. Verify that it generates a report and displays it on the screen.

  7. Do a PROC PRINT against dataset COMPANY.

  8. Verify that the contents of dataset COMPANY in the report and in the output of proc print are the same.

  9. Click Cancel and then Exit to close the application.

Instructions 3
Start the CDISC BUILDER from the icon on desktop.

  1. Click on the FINDINGS icon from the main screen.

  2. Select COMPANY from the dataset list.

  3. Click on the Select All button under the Original Source Variables list.

  4. Verify that all the items in the list are selected.

  5. Click on the Select All button again.

  6. Verify that all the items in the list are deselected.

  7. Do a PROC CONTENTS against dataset COMPANY.

  8. Verify that the list of variables from result of PROC CONTENTS and from the Original Source Variables list are the same.

  9. Click Cancel and then Exit to close the application.

Instructions 4
Start the CDISC BUILDER from the icon on desktop.

  1. Click on the FINDINGS icon from the main screen.

  2. Select COMPANY from the dataset list.

  3. Select some variables from the Original Source Variables list.

  4. Click on the << button next to the Test Variable list.

  5. Verify that selected variables are copied to Test Variable list.

  6. Click on the Select All button under the Test Variable list.

  7. Verify that all items on the list are selected.

  8. Click Select All again.

  9. Verify that all items on the list are deselected.

  10. Select some items from the Test Variable list.

  11. Click on the >> button next to the Test Variable list.

  12. Verify that the selected items are removed from the list.

  13. Click Cancel and then Exit to close the application.

Instructions 5
Start the CDISC BUILDER from the icon on desktop.

  1. Click on the FINDINGS icon from the main screen.

  2. Select COMPANY from the dataset list.

  3. Select some variables in the Original Source Variables list.

  4. Click on the >> button next to the Additional Variable list.

  5. Verify that selected items are copied to the Additional Variable list.

  6. Click on the Select All button under the Additional Variable list.

  7. Verify that all the items in the list are selected.

  8. Click Select All again.

  9. Verify that all items are deselected.

  10. Select some items in the Additional Variable list.

  11. Click on the << button close to Additional Variable list.

  12. Verify that selected items are removed from the list.

  13. Click Cancel and then Exit to close the application.

Instructions 6
Start the CDISC BUILDER from the icon on desktop.

  1. Submit the following program.

    libname testlib 'c:\temp\cdiscbld\input\findings';

    data testlib.ae (label="Adverse Events");
    set sashelp.shoes;
    run;

    data testlib.dm (label="Demographics");
    set sashelp.company;
    run;
     

  2. Click on the ADDSEQ button from the main screen.

  3. Click on the Related Domain list.

  4. Verify that all the domains from the documentation are on this list.

  5. Select AE from the Data Sets list.

  6. Verify that the related domain will be defaulted to AE.

  7. Select DM from the Data Sets list.

  8. Verify that the related domain will be defaulted to DM.

  9. Click Cancel and then Exit to close the application.

Instructions 7
Start the CDISC BUILDER from the icon on desktop.

  1. Click on the FINDINGS icon from the main screen.

  2. Select AE from the dataset list.

  3. Select Product as test variable.

  4. Select Inventory as additional variable.

  5. Verify that you cannot enter more than 10 characters into Study Identifier field.

  6. Try to enter some special characters such as "," or "&" and click OK.

  7. Verify that there is a warning message saying that "The field (Study Identifier) contains some special characters.".

  8. Close the message dialog.

  9. Click Cancel and then Exit to close the application.

Instructions 8
Start the CDISC BUILDER from the icon on desktop.

  1. Submit the following program.

    libname testlib 'c:\temp\cdiscbld\input\findings';

    data testlib.ae (label="Adverse Events");
    attrib region length=$25;
    attrib product length=$14;
    attrib subsidiary length=$12;
    attrib stores length=8;
    attrib usubjid label="Subject ID" length=8;
    set sashelp.shoes;
    run;
     

  2. Click on the FINDINGS icon from the main screen.

  3. Select AE from dataset list.

  4. Verify that the Unique Subject ID Variable are defaulted to usubjid.

  5. Do a PROC CONTENTS against dataset AE.

  6. Verify that all variables of AE dataset from the output result of PROC CONTENTS are listed on the Unique Subject ID Variable list.

  7. Click Cancel and then Exit to close the application.

Instructions 9
Start the CDISC BUILDER from the icon on desktop.

  1. Click on the FINDINGS icon from the main screen.

  2. Click on the [...] button next to the Output field.

  3. Select INTEST library and click Back.

  4. Verify that INTEST will be selected in the Output library list.

  5. Click on the [...] button again.

  6. Select OUTTEST library and click Back.

  7. Verify that OUTTEST will be selected in the Output library list.

  8. Select AU from the related domain list.

  9. Verify that the output dataset name is changed to AE.

  10. Select DC from the related domain list.

  11. Verify that the output dataset name is changed to DC.

  12. Enter AE into output dataset name.

  13. Verify that the output name won't be changed when a new related domain selected.

  14. Click Cancel and then Exit to close the application.

Instructions 10
Start the CDISC BUILDER from the icon on desktop.

  1. Click on the FINDINGS icon from the main screen.

  2. Select C:\TEMP\CDISCBLD\INPUT\FINDINGS as Source Data.

  3. Select AE from the dataset list.

  4. Select Product as test variable.

  5. Select Sales as additional variable.

  6. Select AU as related domain.

  7. Enter "12345" into Study Identifier field.

  8. Select usubjid as Unique Subject Id Variable.

  9. Select OUTTEST as output library.

  10. Enter "AE" into output dataset field.

  11. Click on the Cancel button.

  12. Verify that it closes FINDINGS dialog without doing anything.

  13. Verify that it won't created the output dataset in the selected output library.

  14. Click Exit to close the application.

  15. Start the application again.

  16. Click on the FINDINGS icon.

  17. Verify that all the values from the previous time are retained in the screen.

  18. Click on the OK button.

  19. Verify that it generates dataset AE into the selected output library.

  20. Verify that there are six variables in the output AE dataset.

  21. Verify that the usubjid column contains all values of variable usubjid from input ae dataset.

  22. Verify that the rdomain column contains value AU.

  23. Verify that the column testname contains the name of test variable selected in the screen which is Product.

  24. Verify that the column autest contains all values of variable product from input dataset.

  25. Verify that there is the variable named sales which is the selected additional variable in the screen.

  26. Click Cancel and then Exit to close the application.

Instructions 11
Start the CDISC BUILDER from the icon on desktop.

  1. Rename the AE dataset in outtest library to AE2.

  2. Click on the FINDINGS icon in the main screen.

  3. Click on the Save Code button.

  4. Select C:\temp\cdiscbld\output\findings as file path.

  5. Enter findings_savecode as file name.

  6. Click OK.

  7. Verify that the View Code screen will displayed with the contents of the generated base code program.

  8. Verify that the header of the program looks similar as follows (The user name and time may be different).

    /*----------------------------------------------------*
    * Program: findings_savecode.sas
    * Path: C:\temp\cdiscbld\output\findings
    * Description: Generate CDISC Findings data set
    * for a specified domain.
    * By: Bui Nguyen Tuan Anh, %findings, 02/14/2006, 11:39:55 am
    *-----------------------------------------------------*/
     

  9. Click on Cancel and then Exit to close the application.

  10. Right mouse click on the findings_savecode.sas program and select Batch Submit.

  11. Verify that there is no error message in the log file.

  12. Verify that it generates a new AE dataset into C:\temp\cdiscbld\output\findings.

  13. Compare the new AE dataset with AE2 and verify that they contain the same information.

 

For more information, please contact MXI .

 
     Meta-Xceed Inc. © 2009

Clinical Analytic Software Solutions SAS Consulting SAS Alliance Partner SAS CFR Part 11 Compliance SAS Software Development SAS Biotech Pharmaceutical Consulting SAS Biotech Pharmaceutical Consulting SAS Consulting SAS Alliance Partner Clinical Analytic Software Solutions SAS Biotech Pharmaceutical Consulting Clinical Analytic Software Solutions CFR Part 11 Compliance SAS Alliance Partner SAS Software Development SAS Biotech Pharmaceutical Consulting SAS Data Standards SAS Data Quality SAS Data Integrity SAS Data Audit SAS Data Versioning CDISC Data Standards SAS Data Transfer Utility SAS Data Conversion Utility Clinical Analytic Software Solutions Adverse Event Data Coding Adverse Event Data Mapping Adverse Event Auto Coder Adverse Event Autocoder MedDRA Coder MedDRA Autocoder MedDRA Auto Coder Costart Coder Costart Autocoder Costart Auto Coder Who Drug Coder Who Drug Autocoder Who Drug Auto Coder SAS Analysis Tools SAS Reporting Tools SAS Batch Submit SAS Report Standards SAS Log Evaluation SAS Page X of Y Tool Table of Contents SAS Output SAS Output TOC SAS Code Development SAS Development Environment SAS Macros Management SAS Output Management SAS Output TOC First Page SAS Output SAS Log Runtime SAS Program Search and Replace Tool SAS Program Validation SAS Program Validate SAS Program Audit Trail SAS Program Versioning SAS Program Version Control SAS Program Change Control SAS Program Verification SAS Program CFR Part 11 Compliant SAS Data Standards Scheduling of SAS Jobs SAS Clinical Information Management SAS Web-based Clinical Information SAS ESUB FDA Submission

SAS Benchmark SAS System Benchmark SAS Software Benchmark SAS Performance SAS Performance Benchmark SAS Performance Test

SAS Cluster SAS Grid Cluster SAS Grid SAS SAS Cluster System SAS Cluster Servers SAS Grid Computing SAS Plugin for MS Office SAS MS Office Plugin SAS Plugin for Excel SAS Plugin for MS Word SAS Excel SAS MS Word SAS Macro Interfeace for MS Office Optimize Report Generation from CDISC Standards Generate Reports from CDISC Data SDTM Reports ADaM Reports Standard SAS Reports SAS Program Library SAS Macro Library MedDRA Coding WHO Drug Coding MedDRA Coding Service WHO Drug Coding Service MedDRA Service WHO Drug Service Thesaurus Dictionary Management ADaM ADaM Consulting ADaM Service Analysis Datasets Analysis Datasets Consulting Analysis Datasets Service Annotated Case Report Form Annotated Case Report Form Consulting Annotated Case Report Form Service Annotated CRF Annotated CRF Consulting Annotated CRF Service Biostatistics Consulting Biostatistics Service CDISC ADAM CDISC ADAM Consulting CDISC ADAM Service CDISC Compliance CDISC Compliance Consulting CDISC Compliance Service CDISC SDTM CDISC SDTM Consulting CDISC SDTM Service Clinical Data Management Clinical Data Management Consulting Clinical Data Management Service CRF Design CRF Design Consulting CRF Design Service Data Management Service Design Case Report Form Design Case Report Form Consulting Design Case Report Form Service Discrepancy Management Discrepancy Management Consulting Discrepancy Management Service Edit Checks Edit Checks Consulting Edit Checks Service Electronic Submission Electronic Submission Consulting Electronic Submission Service SAS Consulting SAS Development Consulting SAS Development Service SAS Program Consulting SAS Program Service SAS Service SDTM Consulting SDTM Service Statistical Consulting Statistical Service Tables Listings and Graphs Tables Listings and Graphs Consulting Tables Listings and Graphs Service TLG Consulting TLG Service Coding Methodologies Contract Research Organizations CRO Data Library Managing Thesaurus Reconciling Dictionaries SAS Macros Table of Contents TOC Biostatistics Case Report Form Case Report Form Design Case Report Form Service CFR part 11 Clinical Data Management CRF Tabulations Custom Database Custom Database Consult Custom Database Design Custom Database Service Data Analysis Data Management Data Warehouse Design Clinical Plans Electronic case report Electronic submission FDA Submission IND Medical Device Medical Writing Ndas Prepare Patient Profile Consult Patient Profile Generator Patient Profile Service RFP SAS Consulting SAS Service SOP Consulting SOP Service Code Optimizer Data Models Data Standards Data Definition Define.xml Define.PDF Domain documentation Data Definition Documentation Coded Terminology Coded Terminology Management Coded Terminology Software SAS Format SAS Format Management CDISC Coded Terminology Coded Terms Coded Terms Coded Terms Software Controlled Terminology Control Terminology Controlled Terminology Management Control Terminology Management Control Terminology Software Controlled Terminology Software CDISC Controlled Terminology CDISC Control Terminology SAS Data Viewer Data Viewer Syview View SAS without lock SAS Dataset Viewer SAS Dataset View SAS Data View Optimize Report Generation from CDISC Standards Generate Reports from CDISC Data SDTM Reports ADaM Reports Standard SAS Reports SAS Program Library SAS Macro Library