The following documentation contains test scripts
and expected results for validating the CDISC Builder
Comment 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
|
|
Related Domain
|
Verify list of domains matches list
in documentation.
If CDISC dataset is selected, related
domain is defaulted.
|
Instructions
3
|
|
Study Identifier
|
Verify name with special character
such as comma and quotes.
Proper warning message is presented.
|
Instructions 4
|
|
Comment Variables
|
List of variables match those from
selected dataset. Verify through
PROC CONTENTS.
Select all button toggles.
|
Instructions 5
|
|
Date Variable
|
List of variables match those from
selected dataset. Verify through
PROC CONTENTS.
First "date" variable is defaulted.
|
Instructions 6 |
|
Identification
Variable |
List of variables match what is
in the selected dataset. Verify
via PROC CONTENTS.
Default to the first "SEQ" variable
it finds.
|
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
Default to CO for dataset name.
|
Instructions 9 |
|
Base Code |
Default base program is the name
of the selected dataset with the extension
of .sas.
|
Instructions 10 |
|
OK/Cancel |
OK button applies all selected parameters.
Memory of all fields are retained.
Cancel does not apply logic.
|
Instructions 11 |
|
Find Comment |
Report is generated with all possible
comment fields reported with index.
Footnote describes location of data.
|
Instructions 12 |
|
Save Code |
Program is saved with proper comments
Generated program is submitted and
results verified
|
Instructions 13 |
Instructions
1
Start the CDISC Builder application from the icon in
desktop.
-
Create the following path if
it does not already exist.
c:\temp\cdiscbuilder\input
c:\temp\cdiscbuilder\source
c:\temp\cdiscbuilder\output
-
Submit the following program:
libname input
'C:\temp\cdiscbuilder\input'
libname source
'C:\temp\cdiscbuilder\source'
libname output
'C:\temp\cdiscbuilder\output'
data testlib.shoes;
set sashelp.shoes;
run;
data testlib.company;
set sashelp.company;
run;
data testlib.manage;
set sashelp.manage;
run;
data testlib.ae (label="Adverse
Events");
set sashelp.shoes;
run;
-
At the Main screen, select Source
Data as 'C:\temp\cdiscbuilder\input' and Data
Sets as AE.
-
Click on Comment icon to open
Comment screen.
-
Verify that Source Data is 'C:\temp\cdiscbuilder\input'
and Data Sets as AE.
-
Type an invalid path such as
'C:\invalid' in Source Data textbox and
Press on Enter button key.
-
Verify that there is a warning
message box as the following:
-
Click OK to close the message
box. Verify that Datasets list box is empty.
-
Type 'C:\temp\cdiscbuilder\input'
in Source Data textbox and Press on Enter
button key.
-
Verify that all datasets in
'C:\temp\cdiscbuilder\input' are inserted in
Datasets list box.
-
Type an empty directory such
as 'C:\temp\empty' in Source Data textbox and
Press on Enter button key.
-
Verify that Datasets list box
is empty.
-
Create a directory that is longer
than 200 characters such as:
C:\temp\This
is a test of long path. This is a test of long
path. This is a test of long path. This is a
test of long path. This is a test of long path.
This is a test of long path. This is a test
of long path. This is a test of long path.
-
Type this path in Source Data
textbox and Press on Enter button key. Verify that there
is no error.
-
Click on [...] button next to
Source Data textbox.
-
Select 'C:\temp\cdiscbuilder\input'
path and then click OK.
-
Verify that Datasets list box
is filled with all datasets in 'C:\temp\cdiscbuilder\input'.
-
Click on [...] button next to
Source Data textbox.
-
Select the path 'C:\temp\This
is a test of long path. This is a test of long
path. This is a test of long path. This is a
test of long path. This is a test of long path.
This is a test of long path. This is a test
of long path. This is a test of long path.'.
-
Click OK button. Verify that
there is a warning message as the following:
Instructions
2
Start the CDISC Builder application from the icon in
desktop.
-
Click on Comment icon to open
Comment screen.
-
At the Comment screen, type
'C:\temp\cdiscbuilder\input' in Source Data
textbox and Press on Enter button key.
-
Verify that all datasets in
'C:\temp\cdiscbuilder\input' are inserted in
Datasets list box and dataset AE is selected.
-
Click on Preview button. Verify
that the first 100 observations of dataset AE
are displayed.
-
Open SAS program and submit
the following code:
libname
input
'C:\temp\cdiscbuilder\input';
proc
print
data=input.ae;
run;
-
Verify that the result of the
above code is the same with the result of the
Preview button.
Instructions
3
Start the CDISC Builder application from the icon
in desktop.
-
Click on Comment icon to open
Comment screen.
-
At the Comment screen, type
'C:\temp\cdiscbuilder\input' in Source Data
textbox and Press on Enter button key.
-
Verify that all datasets in
'C:\temp\cdiscbuilder\input' are inserted in
Datasets list box and dataset AE is selected.
-
Click on Related Domain combo
box. Verify that all CDISC datasets are display.
-
Select dataset COMPANY in Datasets
list box. Verify that no domain in Related Domain
is selected.
-
Select dataset AE in Datasets
list box. Verify that domain AE in Related Domain
is selected.
Instructions
4
Start the CDISC Builder application from the icon
in desktop.
-
Click on Comment icon to open
Comment screen.
-
At the Comment screen, type
'C:\temp\cdiscbuilder\input' in Source Data
textbox and Press on Enter button key.
-
Verify that all datasets in
'C:\temp\cdiscbuilder\input' are inserted in
Datasets list box and dataset AE is selected.
-
Select 'AE - Adverse Events'
in the Related Domain.
-
Input Study Identifier with
value !@#$,."' (copy all these special characters
and paste to the Study Identifier textbox).
-
Type '12345' in Study Identifier
textbox.
-
Select 'Product' in Comment
Variables.
-
Select 'Region' in Unique Subject
ID Variable combo box.
-
Select Output with libname 'OUTPUT'
and dataset 'CO'.
-
Click OK button, verify that
there is no error or warning message.
Instructions
5
Start the CDISC Builder application from the icon
in desktop.
-
Click on Comment icon to open
Comment screen.
-
At the Comment screen, type
'C:\temp\cdiscbuilder\input' in Source Data
textbox and Press on Enter button key.
-
Verify that all datasets in
'C:\temp\cdiscbuilder\input' are inserted in
Datasets list box.
-
Select COMPANY from the Datasets
list box. Verify that Comment Variables list
box is filled with the variables in dataset
COMPANY.
-
Open SAS program and submit
the following code:
libname
input
'C:\temp\cdiscbuilder\input';
proc
contents
data=input.company;
run;
-
Verify that the variables in
the result are the same with variables in variables
in the Comment Variables list box.
-
Click on Select All button.
Verify that all datasets in Comment Variables
list box are selected.
-
Click on Select All button again.
Verify that no dataset in Comment Variable list
box is selected.
Instructions
6
Start the CDISC Builder application from the icon
in desktop.
-
Click on Comment icon to open
Comment screen.
-
At the Comment screen, type
'C:\temp\cdiscbuilder\input' in Source Data
textbox and Press on Enter button key.
-
Verify that all datasets in
'C:\temp\cdiscbuilder\input' are inserted in
Datasets list box.
-
Select COMPANY from the Datasets
list box. Verify that Date Variable combo box
is filled with the variables in dataset COMPANY.
-
Open SAS program and submit
the following code:
libname
input
'C:\temp\cdiscbuilder\input';
proc
contents
data=input.company;
run;
-
Verify that the variables in
the result are the same with variables in variables
in the Date Variable combo box.
Instructions
7
Start the CDISC Builder application from the icon in
desktop.
-
Click on Comment icon to open
Comment screen.
-
At the Comment screen, type
'C:\temp\cdiscbuilder\input' in Source Data
textbox and Press on Enter button key.
-
Verify that all datasets in
'C:\temp\cdiscbuilder\input' are inserted in
Datasets list box.
-
Select COMPANY from the Datasets
list box. Verify that Identification Variable
combo box is filled with the variables
in dataset COMPANY.
-
Open SAS program and submit
the following code:
libname
input
'C:\temp\cdiscbuilder\input';
proc
contents
data=input.company;
run;
-
Verify that the variables in
the result are the same with variables in variables
in the Identification Variable combo box.
Instructions
8
Start the CDISC Builder application from the icon in
desktop.
-
Click on Comment icon to open
Comment screen.
-
At the Comment screen, type
'C:\temp\cdiscbuilder\input' in Source Data
textbox and Press on Enter button key.
-
Verify that all datasets in
'C:\temp\cdiscbuilder\input' are inserted in
Datasets list box.
-
Select COMPANY from the Datasets
list box. Verify that Unique Subject ID combo
box is filled with the variables in dataset
COMPANY.
-
Open SAS program and submit
the following code:
libname
input
'C:\temp\cdiscbuilder\input';
proc
contents
data=input.company;
run;
-
Verify that the variables in
the result are the same with variables in variables
in the Unique Subject ID combo box.
Instructions
9
Start the CDISC Builder application from the icon
in desktop.
-
Click on Comment icon to open
Comment screen.
-
At the Comment screen, type
'C:\temp\cdiscbuilder\input' in Source Data
textbox and Press on Enter button key.
-
Verify that all datasets in
'C:\temp\cdiscbuilder\input' are inserted in
Datasets list box.
-
Select AE from the Datasets
list box.
-
Click on [...] button next to
Output combo box. Verify that Libname Management
is displayed.
-
Select library OUTPUT and then
click Back button.
-
Verify that the libname
OUTPUT is selected in the Output combo box and
the dataset textbox has the default value CO.
Instructions
10
Start the CDISC Builder application from the icon
in desktop.
-
Click on Comment icon to open
Comment screen.
-
At the Comment screen, type
'C:\temp\cdiscbuilder\input' in Source Data
textbox and Press on Enter button key.
-
Verify that all datasets in
'C:\temp\cdiscbuilder\input' are inserted in
Datasets list box.
-
Select AE from the Datasets
list box.
-
Verify that Base Code textbox
has value 'ae.sas'.
-
Select COMPANY from the Datasets
list box.
-
Verify that Base Code textbox
has value 'company.sas'.
Instructions
11
Start the CDISC Builder application from the icon
in desktop.
-
Click on Comment icon to open
Comment screen.
-
At the Comment screen, type
'C:\temp\cdiscbuilder\input' in Source Data
textbox and Press on Enter button key.
-
Verify that all datasets in
'C:\temp\cdiscbuilder\input' are inserted in
Datasets list box.
-
Select AE from the Datasets
list box.
-
Select 'AE - Adverse Events'
in the Related Domain.
-
Type '12345' in Study Identifier
textbox.
-
Select 'Product' in Comment
Variables.
-
Select 'Region' in Unique Subject
ID Variable combo box.
-
Select Output with libname 'OUTPUT'
and dataset 'CO'.
-
Click OK button. Verify that
there is a message box as the following:
-
Click OK button. Verify that
Comment Domain Dataset for SDTM of CDISC has
been generated.
-
Click Cancel button to return
to the Main screen.
-
Click on Comment icon. Verify
that Comment screen is displayed.
-
Verify that all parameters are
selected as the previous session.
Instructions
12
Start the CDISC Builder application from the icon
in desktop.
-
Click on Comment icon to open
Comment screen.
-
At the Comment screen, type
'C:\temp\cdiscbuilder\input' in Source Data
textbox and Press on Enter button key.
-
Verify that all datasets in
'C:\temp\cdiscbuilder\input' are inserted in
Datasets list box.
-
Select AE from the Datasets
list box.
-
Select 'AE - Adverse Events'
in the Related Domain.
-
Type '12345' in Study Identifier
textbox.
-
Select 'Product' in Comment
Variables.
-
Select 'Region' in Unique Subject
ID Variable combo box.
-
Select Output with libname 'OUTPUT'
and dataset 'CO'.
-
Click OK button. Verify that
there is a message box as the following:
-
Click OK button. Verify that
Comment Domain Dataset for SDTM of CDISC has
been generated.
-
Click Cancel button to return
to the Main screen.
-
Click on Comment icon. Verify
that Comment screen is displayed.
-
Verify that all parameters are
selected as the previous session.
Instructions
13
Start the CDISC Builder application from the icon
in desktop.
-
Click on Comment icon to open
Comment screen.
-
At the Comment screen, click
Save Code button. Verify that Save Code dialog
is displayed.
-
Input the path as 'C:\temp\cdiscbuilder'
and the file name as 'comment_AE'.
-
Click OK button. Verify that
View Code screen is displayed.
-
Review the code and verify that
all the parameters are inserted in the right
order of the macro.
-
Click Back button to return
to the Comment screen.
-
Navigate to the 'C:\temp\cdiscbuilder'
directory.
-
Submit the 'comment_AE.sas'
program and verify that the result is the same
with the result of the
Instruction 11.
For more information, please contact MXI
.
|