CDISC Builder™  2.1 - Installation Test Scripts - Fmtsum
The following documentation contains test scripts and expected results for validating the CDISC Builder Fmtsum 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
Format Path Format path greater than 200.
Verify Format invalid path.
Verify path with out format catalog.
Verify [...] button containing formats.

 Instructions 3
Back Code Verify invalid path.
Verify full path and name longer than 200 characters.
Default name is "fmtsum_" concatenate with name of selected data with file extension of .sas.
Verify the [...] button navigation and path assignment.

 Instructions 4

Output 

 Verify default output file is fmtsum.html in current default directory.
Verify name that is long over 200 characters.  Proper warning message is presented.
Verify the [...] returns the correct 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 path if it does not already exist.

    "c:\temp\cdiscbld\input\fmtsum".
    "c:\temp\cdiscbld\output\fmtsum".

  2. Submit the following program:

    libname testlib 'c:\temp\cdiscbld\input\fmtsum'
    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 FMTSUM to open FMTSUM 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

    • The field (Source Data) contains non-existing directory.

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

  7. Verify the list of datasets is empty.

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


     

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

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

  11. 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.

  12. Click OK button to close this message.

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

  14. Navigate to folder that contains some datasets, such as: "input\fmtsum" folder.

  15. 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\fmtsum".  Verify there are 4 datasets : "AE", "CM", "DM" and "AE1" in this folder.

  2. Click FMTSUM to open FMTSUM screen.

  3. Type "C:\temp\cdiscbld\input\fmtsum" 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\fmtsum";

    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. Navigate to "C:\temp\cdiscbld\input\fmtsum".  Delete format catalog if it exists.

  2. Click FMTSUM to open FMTSUM screen.

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

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


     

  5. Click on [...] button next to "Format Path" text input.

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

  7. 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 Format Path field.

  8. Click OK button to close this message.

  9. Type "C:\temp\cdiscbld\input\invalid" in "Format Path" field.

  10. Click OK button.  Verify there is a warning message displayed.

    • The field (Format Path) contains a non-existing directory.

  11. Click OK button to close this message.

  12. Type "C:\temp\cdiscbld\input\fmtsum" in "Format Path" field.

  13. Click OK button.  Verify there is a warning message displayed.

    • Could not find a format catalog at specified location.

  14. Click OK button to close this message.

  15. Submit the following program:

    libname inlib 'C:\temp\cdiscbld\input\fmtsum';
    proc format library=inlib;
    value $cfmt
    "TOKYO" = "TOKYO Format"
    "LONDON" = "LONDON Format"
    ;
    run;
     

  16. Click on [...] button near the "Format Path" field.

  17. Navigate to "C:\temp\cdiscbld\input\fmtsum". 

  18. Click OK button.  Verify there is no warning message. 

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

  1. Click FMTSUM to open FMTSUM screen.

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

  3. Submit the following program:

    libname inlib 'C:\temp\cdiscbld\input\fmtsum';
    proc format library=inlib;
    value $cfmt
    "TOKYO" = "TOKYO Format"
    "LONDON" = "LONDON Format"
    ;
    run;
     

  4. Type a path such as "C:\temp\cdiscbld\input\fmtsum" in "Format Path" field.

  5. Type "C:\temp\cdiscbld\input\invalid" in "Back Code" field.

  6. Click OK button.  Verify there is a warning message displayed.

    • The field (Back Code) contains an invalid directory.

  7. Click OK button to close this message.

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


     

  9. Click on [...] button next to "Back Code" text input.

  10. Navigate to that folder and type "backcode.sas" in "File Name". Click Save button.

  11. Verify that there is a warning message:

    • You cannot select a path longer than 200 characters using Select dialog. Please enter the path and file name directly to the Back Code field.

  12. Click OK button to close this message.

  13. Clear value in "Back Code" field.

  14. Choose "CM" dataset.  Verify "fmtsum_cm.sas" is displayed in "Back Code" field.

  15. Click on [...] button near the "Back Code" field.

  16. Navigate to "C:\temp\cdiscbld\input\fmtsum".  Type "backcode.sas" in "File Name".  Click Save button. 

  17. Verify "C:\temp\cdiscbld\input\fmtsum\backcode.sas" is displayed in "Back Code" field. 

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

  1. Click FMTSUM to open FMTSUM screen.

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

  3. Submit the following program:

    libname inlib 'C:\temp\cdiscbld\input\fmtsum';
    proc format library=inlib;
    value $cfmt
    "TOKYO" = "TOKYO Format"
    "LONDON" = "LONDON Format"
    ;
    run;
     

  4. Type a path such as "C:\temp\cdiscbld\input\fmtsum" in "Format Path" field.

  5. Type "C:\temp\cdiscbld\input\fmtsum\backcode.sas" in "Back Code" field.

  6. Clear value in "Output" field.

  7. Click Cancel button.

  8. Click FMTSUM icon again.

  9. Verify "Output" field contains "fmtsum.html" with the current path.

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


     

  11. Click on [...] button next to "Output" text input.

  12. Navigate to that folder and type "fmtsum.html" in "File Name". Click Save button.

  13. Verify that there is a warning message:

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

  14. Click OK button to close this message.

  15. Click on [...] button next to "Output" field.

  16. Navigate to "C:\temp\cdiscbld\input\fmtsum" and type "fmtsum.html" in "File Name". Click Save button.

  17. Verify "C:\temp\cdiscbld\input\fmtsum\fmtsum.html" is displayed in "Output" field.

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

  1. Click FMTSUM to open FMTSUM screen.

  2. Type a path such as "C:\temp\cdiscbld\input\fmtsum" in "Source Data" field.  Click on the Enter button.  Choose "DM" from list of datasets.

  3. Submit the following program:

    libname inlib 'C:\temp\cdiscbld\input\fmtsum';
    proc format library=inlib;
    value $cfmt
    "TOKYO" = "TOKYO Format"
    "LONDON" = "LONDON Format"
    ;
    run;
    data inlib.dm;
    set inlib.dm;
    format level2 $cfmt.;
    run;
     

  4. Type a path such as "C:\temp\cdiscbld\input\fmtsum" in "Format Path" field.

  5. Type "C:\temp\cdiscbld\output\fmtsum\backcode.sas" in "Back Code" field.

  6. Type "C:\temp\cdiscbld\output\fmtsum\fmtsum.html" in "Output" field.

  7. Click OK button.

  8. Verify a report is displayed to show the format of this dataset. 

  9. Navigate to "C:\temp\cdiscbld\output\fmtsum".  Verify "fmtsum.html" is created.

  10. Delete this html file.

  11. Click Back to back to main screen.

  12. Click FMTSUM to open FMTSUM again.

  13. Verify all valued inserted from step 2 to 6 are displayed in screen.

  14. Click Cancel button.

  15. Verify there is no report displayed.

  16. Navigate to "C:\temp\cdiscbld\output\fmtsum".  Verify "fmtsum.html" is not created.

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

  1. Click FMTSUM to open FMTSUM screen.

  2. Type a path such as "C:\temp\cdiscbld\input\fmtsum" in "Source Data" field.  Click on the Enter button.  Choose "DM" from list of datasets.

  3. Submit the following program:

    libname inlib 'C:\temp\cdiscbld\input\fmtsum';
    proc format library=inlib;
    value $cfmt
    "TOKYO" = "TOKYO Format"
    "LONDON" = "LONDON Format"
    ;
    run;
    data inlib.dm;
    set inlib.dm;
    format level2 $cfmt.;
    run;
     

  4. Type a path such as "C:\temp\cdiscbld\input\fmtsum" in "Format Path" field.

  5. Type "C:\temp\cdiscbld\output\fmtsum\backcode.sas" in "Back Code" field.

  6. Type "C:\temp\cdiscbld\output\fmtsum\fmtsum.html" in "Output" field.

  7. Click Save Code button.

  8. Verify Save Code screen is displayed.

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

  10. Type "s_dm" 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\fmtsum".  Verify "s_cm.sas" is created.

  14. Delete fmtsum.html if it exists.

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

  16. Verify "fmtsum.html" is created.

For more information, please contact MXI .

 
     Meta-Xceed Inc. © 2009