CDISC Builder™  2.1 - Installation Test Scripts - SD2XPT
The following documentation contains test scripts and expected results for validating the CDISC Builder SD2XPT 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
Verify select all button toggle.
Verify CDISC button selection of all CDISC type datasets.
 		 Instructions 2
Output Path Entered invalid path.
Path longer than 200 characters.
The [...] library manager returns the correct path.
Default path to be the same as source data.   
 		 Instructions 3
Output File Invalid file greater than 8 characters warning message.
Invalid extension other than xpt
Default the name to be the first dataset selected.   
 		 Instructions 4
Base Code Default base program is the name of the selected dataset with the extension of .sas.  
Verify the [...] button correctly assigns path.
 		 Instructions 5
OK/Cancel OK button applies all selected parameters.
Memory of all fields is retained.
Cancel does not apply logic.
 		 Instructions 6
Save Code Program is saved with proper comments
Generated program is submitted and results verified
 		 Instructions 7

Notes:

  1. Create the following paths if they do not already exist.

    • "c:\temp\cdiscbld\input\sd2xpt".

    • "c:\temp\cdiscbld\output\sd2xpt".

  2. Submit the following program:

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

    data testlib.ae;
            set sashelp.shoes;
    run;

    data testlib.dm;
           set sashelp.company;
    run;

    data testlib.cm;
          set sashelp.manage;
    run;

    data testlib.ae1;
         set sashelp.manage;
    run;

Instructions 1
Start the CDISC Builder application from the icon in desktop.

  1. Click SD2XPT to open SD2XPT screen.

  2. Clear the value in "Source Data" field.  Click on the Enter button.

  3. Verify there is a warning message displayed.

    • The field (Source Data) contains a missing value.

  4. Type an invalid path such as "C:\temp\cdiscbld\invalid" in "Source Data" field.  Click on the Enter button.

  5. Verify there is a warning message displayed.

    • Source data path entered does not exist.

  6. Click OK button to close this message.

  7. Choose a source data path by clicking on [...] button.  Navigate to a path that does not have any datasets.

  8. Verify the list of datasets is empty.

  9. Create a folder with the name is longer than 200 characters, such as:


     

  10. Click on [...] button next to Source Data text input.

  11. Navigate to that folder and click 'OK' button.

  12. Verify that there is a warning message:

    • You cannot select a path longer than 200 characters using Select dialog. Please enter the path directly to the Source Data field.

  13. Click OK button to close this message.

  14. Click on [...] button next to Source Data text input.

  15. Navigate to folder that contains some datasets, such as: "input\sd2xpt" folder.

  16. Verify that some datasets will be displayed in Data Sets list box.

Instructions 2
Start the CDISC Builder application from the icon in desktop.

  1. Navigate to "C:\temp\cdiscbld\input\sd2xpt".  Verify there are 4 datasets : "AE", "CM", "DM" and "AE1" in this folder.

  2. Click SD2XPT to open SD2XPT screen.

  3. Type "C:\temp\cdiscbld\input\sd2xpt" in the "Source Data" field.  Click on the Enter button.

  4. Verify there are 4 datasets listed above in list of datasets: 

  5. Choose "AE" dataset.  Click Preview button.  Verify there is a report displayed to show the content of this dataset.

  6. Submit the following program:

    libname testlib "C:\temp\cdiscbld\input\sd2xpt";

    proc print data=testlib.ae;

    run;

  7. Verify that the result of clicking on Preview button is similar with the result of proc print command.

  8. Click Select All button.  Verify all datasets are selected.

  9. Click Select All button again.  Verify all datasets are deselected.

  10. Click CDISC button.  Verify all CDISC datasets are selected.

  11. Click CDISC button again.  Verify all CDISC datasets are deselected.

Instructions 3
Start the CDISC Builder application from the icon in desktop.

  1. Click SD2XPT to open SD2XPT screen.

  2. Type a path such as "C:\temp\cdiscbld\input\sd2xpt" in "Source Data" field.  Click on the Enter button.

  3. Type an invalid path such as "C:\temp\cdiscbld\invalid" in "Output Path" field.  Click OK.

  4. Verify there is a warning message displayed

    • The field (Output Path) contains an invalid directory.

  5. Click OK button to close this message.

  6. Create a folder with the name is longer than 200 characters, such as:


     

  7. Click on [...] button next to "Output Path" field.

  8. Navigate to that folder and click 'OK' button.

  9. Verify that there is a warning message:

    • You cannot select a path longer than 200 characters using Select dialog. Please enter the path directly to the Output Path field. 

  10. Click OK button to close this message.

  11. Click on [...] button next to "Output Path" field.

  12. Navigate to folder "C:\temp\cdiscbld\input\sd2xpt".

  13. Verify this path is displayed in "Output Path" field.

  14. Type "C:\temp\cdiscbld\input\sd2xpt" in "Source Data" field.

  15. Clear value in "Output Path" field.

  16. Click Cancel button to close this screen.

  17. Click SD2XPT to open SD2XPT screen again.

  18. Verify "C:\temp\cdiscbld\input\sd2xpt" is displayed in "Output Path"  field.

Instructions 4
Start the CDISC Builder application from the icon in desktop.

  1. Click SD2XPT to open SD2XPT screen.

  2. Type a path such as "C:\temp\cdiscbld\input\sd2xpt" in "Source Data" field.  Click on the Enter button.

  3. Type a path such as "C:\temp\cdiscbld\output\sd2xpt" in "Output Path" field.  

  4. Type "testforinvalid.sas" in "Output File".

  5. Click OK button.  Verify a warning message is displayed:
     The field (Output File) does not contain valid extension (.xpt).

  6. Click on the OK button to close the message.

  7. Click OK button to close this message.

  8. Type in the Output File the name of file xpt such as:
    testforinvalid.xpt

  9. Click on the OK button.

  10. Verify that the message is displayed such as:
    File name in 'Output File' cannot contain more than 8 characters.

  11. Click on the OK button to close the message.

  12. Clear value in "Output File" field.

  13. Choose "CM" dataset in list of datasets.  Verify "DM.XPT" is displayed in "Output File".

Instructions 5
Start the CDISC Builder application from the icon in desktop.

  1. Click SD2XPT to open SD2XPT screen.

  2. Type a path such as "C:\temp\cdiscbld\input\sd2xpt" in "Source Data" field.  Click on the Enter button.

  3. Type a path such as "C:\temp\cdiscbld\output\sd2xpt" in "Output Path" field.  

  4. Type "cm.xpt" in "Output File" field.

  5. Clear value in "Base Code" field.

  6. Choose "CM" dataset.  Verify "sd2xpt_cm.sas" is displayed in "Base Code" field.

  7. Click on [...] button near "Base Code" field.  Navigate to "C:\temp\cdiscbld\output\sd2xpt".  Type "cm.sas" in "File Name".  Click Save button.

  8. Verify "C:\temp\cdiscbld\output\sd2xpt\cm.sas" is displayed in "Base Code" field.

Instructions 6
Start the CDISC Builder application from the icon in desktop.

  1. Click SD2XPT to open SD2XPT screen.

  2. Type a path such as "C:\temp\cdiscbld\input\sd2xpt" in "Source Data" field.  Click on the Enter button.

  3. Choose "CM" dataset.

  4. Type a path such as "C:\temp\cdiscbld\output\sd2xpt" in "Output Path" field.  

  5. Type "cm.xpt" in "Output File".

  6. Type "C:\temp\cdiscbld\output\sd2xpt\basecode.sas" in "Base Code" field. 

  7. Click OK button.

  8. Click Back on "View Code" screen if it appears.

  9. Navigate to "C:\temp\cdiscbld\output\sd2xpt".  Verify "cm.xpt" and "basecode.sas" are created.

  10. Open "cm.xpt" and verify this contains the same value as cm.xpt. 

  11. Delete "cm.xpt" and "basecode.sas".

  12. Click Cancel button to back to main screen.

  13. Click SD2XPT to open SD2XPT screen.

  14. Verify all values inserted from step 2 to 6 are displayed.

  15. Click Cancel button.

  16. Navigate to "C:\temp\cdiscbld\output\sd2xpt".  Verify "cm.xpt" and "basecode.sas" are not created.

Instructions 7
Start the CDISC Builder application from the icon in desktop.

  1. Click SD2XPT to open SD2XPT screen.

  2. Type a path such as "C:\temp\cdiscbld\input\sd2xpt" in "Source Data" field.  Click on the Enter button.

  3. Choose "CM" dataset.

  4. Type a path such as "C:\temp\cdiscbld\output\sd2xpt" in "Output Path" field. 

  5. Type "cm.xpt" in "Output File".

  6. Type "C:\temp\cdiscbld\output\sd2xpt\basecode.sas" in "Base Code" field.

  7. Click Save Code button.

  8. Verify Save Code screen is displayed.

  9. Type "C:\temp\cdiscbld\output\sd2xpt" in "Path" field.

  10. Type "s_cm" in "File Name".

  11. Click OK button.  Verify View Code screen is displayed to show the content of save code file.

  12. Click Back to close "View Code" screen.

  13. Navigate to "C:\temp\cdiscbld\output\sd2xpt".  Verify "s_cm.sas" is created.

  14. Delete "cm.xpt" and "basecode.sas" if they exist.

  15. Right mouse click on "s_cm.sas" and select "Batch Submit".

  16. Verify "cm.xpt" and "basecode.sas" are created.

For more information, please contact MXI .

 
     Meta-Xceed Inc. © 2009