The following documentation contains test scripts
and expected results for validating the CDISC Builder
Addseq 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 an
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 match list in documentation.
If CDISC
dataset is selected, related domain
is defaulted.
|
Instructions
3
|
|
Identification
Variable |
List
of variables matches what is in the selected
dataset. Verify via PROC CONTENTS.
Default
to the first "SEQ" variable it finds.
|
Instructions 4
|
|
Unique Subject
ID |
List
of variables matches what is in the selected
dataset. Verify via PROC CONTENTS.
Default
to the first "Subject" variable it finds.
|
Instructions 5
|
|
Base Code |
Default
base program is the name of the selected
dataset with the extension of .sas.
|
Instructions 6 |
|
OK/Cancel |
OK button
applies all selected parameters.
Memory
of all fields are retained.
Cancel
does not apply logic.
|
Instructions 7 |
|
Save Code |
Program
is saved with proper comments
Generated
program is submitted and results verified
|
Instructions 8 |
|
Find Sequence |
A report
is generated with correct index of all
variables with sequence. Verify
by program with sort and (FIRST.) logic.
|
Instructions 9 |
Instructions
1
Start the CDISC Builder application from the icon in
desktop.
-
Create the
following path if it does not already exist.
c:\temp\cdiscbld\input\addseq
-
Submit the
following program:
libname testlib 'c:\temp\cdiscbld\input\addseq';
data testlib.shoes;
set sashelp.shoes;
run;
data testlib.company;
set sashelp.company;
run;
data testlib.manage;
set sashelp.manage;
run;
-
Click on the ADDSEQ button.
-
Enter an invalid path ( path which does not exist ) in
Source Data field.
-
Press on Enter button. Verify that there is a dialog box displayed
with the message saying that "Source Data does not exist.".
-
Click OK to close the message dialog box.
-
Create the directory with the following name in c:\
test for long name path test for long name path test for
long name path test for long name path test for long name
path test for long name path test for long name path test
for long name path test for long name path
-
Copy all datasets from addseq directory into this directory.
-
Enter this path which is longer then 200 characters into
Source Data field and Press on Enter button.
-
Verify that there is a dialog box displayed with the message
saying that "Source Data does not exist.".
-
Rename the directory so the path will shorter then 200
characters.
-
Enter this path into Source Data field and
Press on Enter button.
-
Verify that there is no error message.
-
Verify that all the dataset in this directory are listed on
the Data Sets list.
-
Click on the [...] button next to the Source Data.
-
Verify that the Select dialog will be displayed.
-
Select a certain directory which has no dataset and click
OK.
-
Verify that there is a dialog box displayed with the message
saying that "There is no dataset in this path.".
-
Click OK to close the message box.
-
Click Cancel and then Exit to close the application.
Instructions
2
Start the CDISC Builder application from the icon in
desktop.
-
Click on
the ADDSEQ button from the main screen.
-
Click on
the [...] button and select a directory which does not
contain any datasets.
-
Verify that
there is a dialog box displayed with the message saying
that "There is no dataset in this path.".
-
Verify that
the Data Sets list is empty.
-
Select
c:\temp\cdiscbld\input\addseq as Source Data.
-
Verify that
the three datasets shoes, company and manage are listed
on the Data Sets list.
-
Select
dataset company from the list and click on the Preview
button.
-
Verify that
a report will be generated and displayed on the screen.
-
Do a PROC
PRINT against dataset company and compare the result
with the report to verify that the information is the
same.
-
Click
Cancel and then Exit to close the application.
Instructions
3
Start the CDISC Builder application from the icon
in desktop.
-
Submit the following program.
libname testlib 'c:\temp\cdiscbld\input\addseq';
data testlib.ae (label="Adverse Events");
set sashelp.shoes;
run;
data testlib.dm (label="Demographics");
set sashelp.company;
run;
-
Click on
the ADDSEQ button from the main screen.
-
Click on the Related Domain list.
-
Verify that all the domains from the
documentation are on this list.
-
Select AE
from the Data Sets list.
-
Verify that
the related domain will be defaulted to AE.
-
Select DM
from the Data Sets list.
-
Verify that
the related domain will be defaulted to DM.
-
Click
Cancel and then Exit to close the application.
Instructions
4
Start the CDISC Builder application from the icon
in desktop.
-
Submit the
following program.
libname testlib 'c:\temp\cdiscbld\input\addseq';
data testlib.shoes;
attrib Region length=$25;
attrib Product length=$14;
attrib Subsidiary length=$12;
attrib seqnum length=8;
set sashelp.shoes;
run;
-
Click on
the ADDSEQ button from the main screen.
-
Select
SHOES from the dataset list.
-
Verify that
the value of the Identification Variable list will be
defaulted to seqnum.
-
Do a PROC
CONTENTS against dataset shoes.
-
Verify that
all variables in dataset shoes are
listed on the Identification Variable
list.
-
Click on
Cancel and then Exit to close the
application.
Instructions
5
Start the CDISC Builder application from the icon
in desktop.
-
Submit the
following program.
libname testlib 'c:\temp\cdiscbld\input\addseq';
data testlib.shoes;
attrib region length=$25;
attrib testvar label="Subject ID";
set sashelp.shoes;
testvar='';
run;
data testlib.manage;
attrib project length=$60;
attrib usubjid label="Patient ID";
set sashelp.manage;
usubjid='';
run;
-
Click on the
ADDSEQ button from the main screen.
-
Select SHOES
from the dataset list.
-
Verify that
the value of Unique Subject ID list will
be defaulted to testvar.
-
Select
MANAGER from the dataset list.
-
Verify that
the value of Unique Subject ID list will
be defaulted to usubjid.
-
Do a PROC
CONTENTS against dataset manage.
-
Verify that
all variables in dataset manage are
listed on the Unique Subject ID list.
-
Click on
Cancel and then Exit to close the
application.
Instructions
6
Start the CDISC Builder application from the icon
in desktop.
-
Click on the
ADDSEQ button from the main screen.
-
Select SHOES
from the dataset list.
-
Verify that
Base Code field will be defaulted to
shoes.sas.
-
Select
MANAGE from the dataset list.
-
Verify that
Base Code field will be defaulted to
manage.sas.
-
Click on
Cancel and then Exit to close the
application.
Instructions
7
Start the CDISC Builder application from the icon
in desktop.
-
Make a backup
version named ae2 of ae dataset .
-
Click on the ADDSEQ
button from the main screen.
-
Select
C:\temp\cdiscbld\input\addseq as Source Data.
-
Select AE from
dataset list.
-
Select Sales as
Identification Variable.
-
Select Product as
Unique Subject ID.
-
Select
C:\temp\cdiscbld\output\ae.sas as Base Code.
-
Click on the OK
button.
-
Compare the two
dataset ae and ae2.
-
Verify that there
are two new variables named domain and aeseq have
been added into ae.
-
Verify that all the values of domain
is AE which are the same as selected
in the screen.
-
Verify that the
sequence number is generated based on each group of
product and sales as selected in the screen.
-
Verify that there is
a base code program named ae.sas created in
C:\temp\cdiscbld\output as select from the
screen.
-
Click on the Cancel
button to close the ADDSEQ screen.
-
Open the ADDSEQ
screen again from the main screen.
-
Verify that all the
values from the previous time still retain in the
screen.
-
Delete the ae
dataset from addseq directory.
-
Make a version of ae
from ae2.
-
Click on the Cancel
button from the screen.
-
Do a proc compare to
verify that dataset ae is the same as ae2.
-
Click on the Exit
button to close the application.
Instructions
8
Start the CDISC Builder application from the icon
in desktop.
-
Click on the ADDSEQ
button from the main screen.
-
Select company from
dataset list.
-
Select DEPTHEAD as
Identification Variable.
-
Select LEVEL2 as
Unique Subject ID.
-
Click on the Save
Code button.
-
Select
C:\temp\cdiscbld\output as file path.
-
Enter addseq_company
as file name and click OK.
-
Verify that the View
Code screen will be displayed with the contents of
the addseq_company.sas.
-
Verify that the
header of the program contains the information
similar as follows ( The user name and time may be
different).
/*----------------------------------------------------*
* Program: addseq_company.sas
* Path: C:\temp\cdiscbld\output
* Description: Add a sequence number for multiple
observations
* per subject.
* By: Bui Nguyen Tuan Anh, %addseq, 02/14/2006,
11:55:38 am
*-----------------------------------------------------*/
-
Verify that all the
parameters in the addseq_company.sas are the same as
selected from the screen.
-
Click on Back to
close the View Code screen.
-
Make a backup
version named company2 from company dataset.
-
Go to the output
directory.
-
Right mouse click on
the addseq_company.sas program and select Batch
Submit.
-
Verify that there is
no error message in the log file.
-
Verify that it
created a report named addsequence.html in the
output directory.
-
Verify that dataset
company has been added two new variables aeseq and
domain.
-
Verify that all values of domain are AE as selected from the screen.
-
Verify that the
sequence number is generated based on each group of
LEVEL2 and DEPTHEAD as selected in the screen.
-
Click on Cancel and
then Exit to close the application.
Instructions
9
Start the CDISC Builder application from the icon
in desktop.
-
Submit the following
program.
libname testlib 'c:\temp\cdiscbld\input\addseq';
data testlib.company;
set sashelp.company;
run;
-
Click on the ADDSEQ
button from the main screen.
-
Select
C:\temp\cdiscbld\input\addseq as Source Data.
-
Select company from
dataset list.
-
Select AE from
Related Domain list.
-
Select JOB1 as
Identification Variable.
-
Select LEVEL2 as
Unique Subject ID.
-
Check the "Sorted by
Unique ID and ID Variable".
-
Click OK.
-
Verify that there is
a report displayed with the contents of company
dataset.
-
Do a PROC PRINT
against dataset company and compare the output
result with the report to make sure they are the
same.
-
Rename dataset
company to company2.
-
Submit the program
in step 1 to re-create dataset company.
-
Submit the program
in the View Code screen.
-
Compare the two
dataset to verify that they are the same.
-
Click on the Cancel
button and then Exit to close the application.
For more information, please contact MXI
.
|
