The VISIT data set is multiple records per subject, sorted by usubjid vistdtc vistm and contains the following variables:

# Variable Type Len
1 VISITNUM Char 2
2 VISDT Char 19
3 VISTM Char 5
4 usubjid Num 8

The DEATH data set is one record per subject, sorted by usubjid vistdtc vistm and contains the following variables:

# Variable Type Len
1 DEREFID Char 8
2 DTHDT Char 200
3 VISTDTC Char 19
4 VISTM Char 5
5 usubjid Num 8

Which program will combine the DEATH and VISIT data sets by matching records?

Question

The VISIT data set is multiple records per subject, sorted by usubjid vistdtc vistm and contains the following variables:

# Variable Type Len
1 VISITNUM Char 2
2 VISDT Char 19
3 VISTM Char 5
4 usubjid Num 8

The DEATH data set is one record per subject, sorted by usubjid vistdtc vistm and contains the following variables:

# Variable Type Len
1 DEREFID Char 8
2 DTHDT Char 200
3 VISTDTC Char 19
4 VISTM Char 5
5 usubjid Num 8

Which program will combine the DEATH and VISIT data sets by matching records?

Accepted Answer

A. data data_1;
 merge death visit;
 by usubjid vistdtc vistm;
run;

Answer

B. data data_1;
 merge death visit;
run;

Answer

C. data data_1;
 set death visit;
 by usubjid vistdtc vistm;
run;

Answer

D. data data_1;
 merge death visit;
 by usubjid vistdtc;
run;

A00-280 Question #10: Real Exam Question with Answer & Explanation