SAS Certified Clinical Trials Programmer Using SAS 9

Question 1

The following SAS program is submitted, but fails due to syntax errors.

What is the cause of the syntax errors?

A. An array cannot be referenced on a keep= data set option.

B. An array can only be referenced in a KEEP statement and not within a keep= data set option.

C. The keep= data set option should be (keep=MonthExp).

D. The keep= data set option should be (keep=MonthExp*).

Correct Answer: A

Question 2

This question will ask you to provide a line of missing code.

Which statement must be added to the following program to create a page break in the report after each RACE grouping?

A. break after race / page;

B. break page / race;

C. break after race;

D. break race / page;

Correct Answer: A

Question 3

CORRECT TEXT
This question will ask you to provide a line of missing code.
Given the following data set LABS(only first 10 lines shown):

In the space below, enter the statement that completes the program to produce the desired output (Case is ignored. Do not add leading or trailing spaces to your answer.).

Correct Answer:

IDLABTEST;,IDLABTEST;,IDLABTEST

Question 4

This question will ask you to provide a line of missing code.
Given the dataset RAWBP that is sorted by SUBJECT TEST WEEK:

Which statement must be added to the program to calculate relative change in percent (percent change) from baseline?

A. pct_chg = ((value - baseline) /value)*100;

B. pct_chg = ((baseline - value) /baseline)*100;

C. pct_chg = ((value - baseline) /baseline)*100;

D. pct_chg = ((baseline - value) /value)*100;

Correct Answer: C

Question 5

Which statement assigns the current date to the character variable CURRDT?

A. currdt="&sysdate.";

B. currdt="sysdate.";

C. currdt="%sysdate.";

D. currdt="#sysdate.";

Correct Answer: A

Question 6

The following SAS program is submitted:

What is the value of the variable day when the data step completes?

A. 1

B. 7

C. 8

D. 6

Correct Answer: C

Question 7

You have been asked to import an Excel spreadsheet. What will lead to substantial differences between the original Excel spreadsheet and the resulting SAS data set?

A. multiple value types within a single row

B. the number of rows to be read from the Excel file

C. multiple value types within a single column

D. the number of columns to be read from the Excel file

Correct Answer: C

Question 8

The following SAS program is submitted:

Which alternative program creates an equivalent BASE_BP data set?

A. proc sort data=VS (keep=usubjid vsstresn vstestcd)
out=BASE_BP (drop=vstestcd);
by usubjid;
if vstestcd in('DIABP','SYSBP');
run;

B. data BASE_BP; set VS (keep=usubjid vsstresn); if vstestcd in('DIABP','SYSBP'); run;

C. proc sort data=VS (keep=usubjid vsstresn vstestcd)
out=BASE_BP (drop=vstestcd);
where vstestcd in('DIABP','SYSBP');
by usubjid;
run;

D. data BASE_BP (keep=usubjid vsstresn vstestcd);
set VS (drop=vstestcd);
if vstestcd in('DIABP','SYSBP');
run;

Correct Answer: C

Question 9

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.

Which program was used to produce WORK.DATA_BB?

A. proc sort data=cm out=data_bb (keep=usubjid cmstdtc cmtrt);
by usubjid CMSTDTC;
where cmtrt in('BLOCKER');
run;

B. proc sort data=CM (keep=usubjid cmstdtc cmtrt) out=data_bb; by usubjid CMSTDTC; where cmtrt contains 'BLOCKER'; run;

C. data data_bb;
set cm (keep=usubjid cmstdtc cmtrt);
by usubjid CMSTDTC;
where cmtrt in('BLOCKER');
run;

D. data data_bb;
set cm (where=(find(cmtrt,'BLOCKER','i')>0));
by usubjid CMSTDTC;
run;

Correct Answer: B

Question 10

The following output is displayed:

Which SAS program created this output?

A. proc freq data=WORK.TESTDATA; tables answer * gender / nocol norow nopercent; run;

B. proc freq data=WORK.TESTDATA;
tables gender * answer / nocol norow nopercent missing;
run;

C. proc freq data=WORK.TESTDATA; tables gender * answer / nocol norow nopercent; run;

D. proc freq data=WORK.TESTDATA;
tables answer * gender / nocol norow nopercent missing;
run;

Correct Answer: C

SASInstitute SAS Certified Clinical Trials Programmer Using SAS 9 - A00-280 Exam Practice Test

Latest Update

Useful Links

Contact Us