SAS_Institute
A00-280 · Question #25
A00-280 Question #25: Real Exam Question with Answer & Explanation
The correct answer is B. proc sort data=CM (keep=usubjid cmstdtc cmtrt) out=data_bb; by usubjid cmstdtc; where cmtrt contains 'BLOCKER'; run;. See the full explanation below for the reasoning.
Question
The data set CM has eight variables including CMTRT and is sorted by STUDYID USUBJID CMSEQ. DATA_BB is created by selecting records from CM where the character string "BLOCKER" is included in CMTRT.
Alphabetical List of Variables and Attributes
Variable Type Len Label
1 CMSTDTC Char 18 Start date/Time of Medication 2 CMTRT Char 200 Reported Name of Drug, Med, or Therapy 1 USUBJID Char 40 Unique Subject Identifier SortedBy USUBJID CMSTDTC Which program was used to produce WORK.DATA_BB?Options
- Aproc sort data=cm out=data_bb (keep=usubjid cmstdtc cmtrt); by usubjid cmstdtc; SAS Institute A00-280 : Practice Test where cmtrt in('BLOCKER'); run;
- Bproc sort data=CM (keep=usubjid cmstdtc cmtrt) out=data_bb; by usubjid cmstdtc; where cmtrt contains 'BLOCKER'; run;
- Cdata data_bb; set cm (where=(find(cmtrt, 'BLOCKER', 'i')>0)); by usubjid cmstdtc; run;
- Ddata data_bb; set cm (keep=usubjid cmstdtc cmtrt); by usubjid cmstdtc; where cmtrt in('BLOCKER'); run;
Community Discussion
No community discussion yet for this question.