|
Add a sequence number for multiple
observations per subject
%addseq (data = input data,
rdomain = related domain,
usubjid = subject id variable,
idvar = identifier variable,
sort = sort order,
basecode = SAS program);
|
Where |
Is Type... |
And represents... |
|
data | C
(200) | The
input SAS dataset to have sequence added. |
|
rdomain |
C (200 Optional) |
Related domain abbreviation to the
current dataset. Some valid domain names include:
AE Adverse Events
AU Autopsy Findings
BM Bone Mineral Density (BMD) Data Findings
BR Biopsy Findings
CM Concomitant Meds Interventions
CO Comments Special Purpose
CP Compliance Findings
DC Disease Characteristics Findings
DM Demographics Special Purpose
DR Disease Response Findings
DS Disposition Events
DV Protocol Deviations Findings
DY Diary Data Findings
EE EEG Findings
EG ECG Findings
EX Exposure Interventions
FH Family History Events
HU Healthcare Resource Utilization Findings
IE Inclusion / Exclusion Findings
IM Imaging Findings
LB Laboratory Data Findings
MB Microbiology Findings
MH Medical History Events
ML Meal Data Interventions
NE Neurological Exam Findings
OM Organ Measurements Findings
PC PK Concentration Findings
PE Physical Exam Findings
PP PK Parameters Findings
QS Questionnaires Findings
SC Subject Characteristics Findings
SE Subject Elements Study Design
SG Surgery Interventions
SK Skin Test Findings
SL Sleep (Polysomnography) Data Findings
SS Signs and Symptoms Findings or Events
ST Stress (Exercise) Test Data Findings
SU Substance Use Interventions
SV Subject Visits Trial Design
TA Trial Arms Trial Design
TE Trial Elements Trial Design
TI Trial Inclusion/Exclusion Criteria Trial Design
TV Trial Visits Trial Design
VS Vital Signs Findings
NOTE: Only the first two characters is needed to be specified in this
parameter. |
|
usubjid | C
(200) |
Unique Subject Identifier found in the
input dataset. |
|
idvar | C
(200 optional) |
Identification variable that
uniquely identifies each observation. |
|
sort | C
(200 optional) |
Sort the order by the specified
domain, usubjid and idvar. The original sort order will be
retained if "no" is selected. Valid values include: |
|
basecode |
C (200 optional) |
Saved location of SAS Base code
that is used to create the relational records dataset. |
|
data |
C (40 chars) |
This is a two level dataset specification as
in: libname.dataset separated by spaces. If
only a one level libname is specified, all the datasets in
the libname will be captured. |
|
output |
C (200 chars) |
The name of the output file. This can
include path and name of RTF file. If none is
specified, the default would be ANNOCRF.RTF which will be
saved at the current location. | Details
This tool will add a sequence variable along with a domain variable
as specified. It will sort the data by the specified idvar and
create a counter variable SEQNUM. It is optional to have the data
retain its original sort order through the sort option.
Example %addseq(data=TMP2.AE,
rdomain=AE,
usubjid=usubjid,
idvar=aestdtc,
basecode=..\basecode\addseq_ae.sas);
|
