CLINICAL SAS CERTIFICATION

1. The first six (6) records from the LABS data set are shown below:

  SUBJID   SAMPLDAT CALCIUM    GLUCOSE    HEMOGLOBIN
  11001    12OCT1987 9.50000 112 14.9000
  11001    19OCT1987 8.80000 91 13.2000
  11001    25OCT1987 9.20000 76 12.7000
  11002    12OCT1987 9.20000 103 12.7000
  11002    18OCT1987 8.40000 209 9.2000

The following SAS program is written to reshape this data set and place it in a new data set named LBTR.

proc transpose data=labs out=lbtr(rename = (col1 = value));
by subjid sampldat;
var Calcium Glucose Hemoglobin;
run;

Which of the following DATA steps produces a data set that is equivalent to the LBTR data set created by the PROC TRANSPOSE step above?

1 point

A

B

C

D

Clear selection

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

Given the data set RAWBP that is sorted by SUBJECT TEST WEEK:

SUBJECT WEEK TEST VALUE
101 0 DBP 90
101 1 DBP 87
101 2 DBP 85
101 3 DBP 80
101 0 SBP 160
101 1 SBP 140
101 2 SBP 130
101 3 SBP 120

The following SAS program is submitted:

data bp;
set rawbp;
by subject test week;
retain baseline;
if first.test then baseline = .;
if week = 0 then baseline = value;
else if week > 0 then do;
<insert code here>
end;
run;

Which statement must be added to the program to calculate percent change from baseline?

1 point

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

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

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

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

Clear selection

3. Given the data set RAWBP that is sorted by SUBJECT TEST WEEK:

SUBJECT TEST WEEK VALUE
101 DBP 0 90
101 DBP 1 87
101 DBP 2 85
101 DBP 3 80
101 SBP 0 160
101 SBP 1 140
101 SBP 2 130
101 SBP 3 120

Baseline is defined as the week 0 value. Your colleague provides the following SAS program to calculate change from baseline:

data bp;
set rawbp;
by subject test week;
retain baseline;
if first.subject then baseline = value;
if week > 0 then change = value - baseline;
run;

What does the code calculate as the change from baseline for systolic blood pressure (SBP) at week 3?

1 point

40

-40

30

-30

Clear selection

4. What is the definition for treatment-emergent adverse event (TEAE)?

1 point

AE that started or worsened after the first dose of study drug

AE that continued after the first dose of study drug

AE that started 6 months after the last dose of study drug

AE that improved after the first dose of study drug

Clear selection

5. Given the data set below, which SAS program correctly counts the of number of unique subjects for each combination of system organ class and treatment?

1 point

a

b

c

d

Clear selection

6. This item will ask you to determine the missing code.

In the data shown below, each record represents a single treatment period and contains a character SUBJID and non-missing numeric dates EXSTDT and EXENDT. The Duration of Treatment (in days) for a single period is defined as Treatment End Date - Treatment Start Date + 1. For each subject, the Total Duration (in days) is defined as the sum of durations of treatment across all treatment periods.

EXSTDT(Treatment EXENT(Treatment

SUBJID Start Date) End Date)

001. 28-Aug-18 3-Sep-18

001 11-Sep-18. 17-Sep-18

001 18_Sep-18 21-Sep-18

001 22-Sep-18 24-Sep-18

002 29-Jnn-20 1-Feb-20

002 5-Feb-20 8-Feb-20

002. 4-Apr-18 1-May-18

002 2-May-18 28-May-18

Which code segment generates the new data set, EX2, which contains a single record per subject and includes the Duration of Treatment?

data EX2
set EX;
by subjid exstdt exendt;
<insert code here>
run;

1 point

a

b

c

d

Clear selection

7. Given the data set WORK.BP with the following variable list:

# Variable Type Len Label
1 DIABP Num 8 Diastolic Blood Pressure
2 PTNO Char 4 Patient Number

The following SAS program is submitted:

ods select ExtremeObs;
proc univariate data=WORK.BP;
var DIABP;
id PTNO;
run;

Which type of output will be created by the program?

1 point

a table of the highest and lowest values of DIABP over all observations

a table of the highest five and lowest five values of DIABP over all observations

a table of the highest and lowest values of DIABP for each level of PTNO

a table of the highest five and lowest five values of DIABP for each level of PTNO

Clear selection

8. A subject visit data set (Visits) includes variables for subject ID (SubjID) and visit date (VisitDT). Which DATA step creates a data set with one record per subject and creates a variable (Visits) that computes the total number of visits for that subject?

Select one:

1 point

a

b

c

d

Option 5

Clear selection

9. A dataset contains systolic blood pressure values stored in the variable SYSBP. Which program displays the median systolic blood pressure over all participants?

1 point

a

b

c

d

Clear selection

10. The following SAS program is submitted:

proc univariate data=WORK.STUDY;
by VISIT;
class REGION TREAT;
var HBA1C GLUCOSE;
run;

You want to store all calculated means and standard deviations in one SAS data set.

Which statement must be added to the program?

Select one:

1 point

ods output mean=m1 m2 std=s1 s2;

output out=WORK.RESULTS mean=m1 m2 std=s1 s2;

ods output out=WORK.RESULTS mean=m1 m2 std=s1 s2;

output mean std;

Clear selection

11. The following text is displayed in your SAS log:

Output Added:
-------------
Name: Statistics
Label: Statistics
Template: Stat.TTest.Statistics
Path: Ttest.ENDPT.Statistics
-------------
Output Added:
-------------
Name: ConfLimits
Label: Confidence Limits
Template: Stat.TTest.ConfLimits
Path: Ttest.ENDPT.ConfLimits
-------------
Output Added:
-------------
Name: TTests
Label: T-Tests
Template: Stat.TTest.TTests
Path: Ttest.ENDPT.TTests
-------------
Output Added:
-------------
Name: Equality
Label: Equality of Variances
Template: Stat.TTest.Equality
Path: Ttest.ENDPT.Equality
-------------
Which statement is necessary to store the p-values of the t-test in a data set called PVALUES in the WORK library?

Select one:

1 point

ods output TTests=WORK.PVALUES;

ods output T-Tests=WORK.PVALUES;

ods TTests=WORK.PVALUES;

ods T-Tests=WORK.PVALUES;

Clear selection

12. Which percentage in the table is calculated incorrectly, assuming the cell counts are correct? Percentages are rounded to the nearest whole percent.

1 point

54

40

44

52

Clear selection

13. A statistical analysis plan asks you to create a table with the following counts of adverse events:

the number adverse events in each system organ class (AESOC)within each level of system organ class, the number of adverse events with each preferred term (AEPT).

Which code produces the counts requested?

Select one:

1 point

proc freq data =AE; tables AESOC*AEPT; run

proc freq data=AE; tables AESOC(AEPT); run;

proc freq data =AE; tables AESOC (AEPT); run;

proc freq data=AE: tables AESOC, AEPT; run;

Clear selection

14. Review the following procedure code:

proc ttest data=DATA1;
class GROUPVAR1;
var VAR1;
run;

Which variable is most appropriate to be analyzed as variable VAR1?

Select one:

1 point

Treatment, with possible values of "Placebo" or "Active"

Age, with possible values of any integer between and including 18 and 65

Number of infections, with possible values of 0, 1, or 2

Systolic blood pressure, with possible values of "<120", "120 - 139", "140 - 159", "160 - 179", and "180+"

Clear selection

15. In a Statistical Analysis Plan (SAP) the following statement is written:

To test the association between the pain intensity reported by the patient and the treatment the patient has been administered, a Cochran-Mantel-Haenszel test will be performed adjusting for the country of the patient's investigational site.

The following variables and levels are used:

· Pain intensity (PAIN): "No pain", "Mild pain", "Moderate pain", "Severe pain", "Most severe pain"

· Treatment group (TREAT): "Placebo", "Drug A", "Drug B"

· Country (COUNTRY): Eight different values.

The following program is written to perform this analysis:

proc freq data=pain;
by COUNTRY;
tables PAIN * TREAT / cmh;
run;

This code does not produce the analysis requested by the SAP. What is wrong with this code?

Select one:

1 point

The option CMH should be on the PROC FREQ statement instead of on the TABLES statement.

The variables PAIN and TREAT should be on the BY statement, and the variable COUNTRY should be on the TABLES statement.

The variable PAIN should be on the BY statement along with the variable COUNTRY.

The variable COUNTRY should be on the TABLES statement instead of the BY statement.

Clear selection

16. The print below shows the first four observations from the TEST2 dataset. Variable names are given in the first row.

  subjid     _NAME_ TRT FinalBP
201027    DIABP A 88
221058    DIABP A 75
211046    DIABP B 89
221000 DIABP B 80

The statistical analysis plan (SAP) requests that a two sample t-test be performed to compare the mean of variable FINALBP for levels of the variable TRT. You review the following code from a colleague:

proc ttest data=test2;
by trt;
var finalbp;
run;

This code does not produce the analysis requested by the SAP. What is wrong with this code?

Select one:

1 point

Variable FINALBP should be specified on a TWOSAMP statement instead of a VAR statement.

Variable TRT should be specified on a CLASS statement instead of a BY statement.

Variable FINALBP should be specified on a TEST statement instead of a VAR statement.

Variable TRT should be specified on a WEIGHT statement instead of a BY statement.

Clear selection

17. Given the definition for the macro MTOTOBS:

%macro mtotobs(inset=) ;
   data _null_ ;
      set &inset end=lastrec ;
      total+1 ;
      if lastrec then call symputx("totobs", put(total,best5.));
   run ;
%mend ;

1 point

The macro definition needs a %LOCAL statement added.

The macro definition needs a %GLOBAL statement added.

The macro variable call needs another ampersand (&&totobs).

&totobs needs the INPUT function to convert it to a numeric value for use in calculations.

Clear selection

18. Given the following complete dataset (WORK.TESTDM) with the variables USUBJID (character) and AGE (numeric):

OBS USUBJID AGE
1 X111-100-1001 17.1
2 X111-100-1002 17.7
3 X111-200-1001 4.4
4 X111-200-1002 3.8
5 X111-201-1000 6.3

The following code is executed:

proc sql;
select age into: age separated by ','
from testdm;
quit;

What is the value of the macro variable AGE?

Select one:

1 point

17, 17, 4, 3, 6

17.1 17.7 4.4 3.8 6.3

Blank, the code will not execute

17.1,17.7,4.4,3.8,6.3

Clear selection

19. Given the full data set SUBJECT.DEMO:

  Subject Gen
XMB111-500-1001 M
XMB111-500-1001 F
XMB111-600-1002 F
XMB111-600-1005 M

The following SAS program is submitted:

  %macro MP_ONE(pname=report);
    proc &pname data=SUBJECT.DEMO;
    run;
%mend;
%MP_ONE(print)
%MP_ONE()

Which PROC step(s), if any, execute?

Select one:

1 point

. No PROC steps execute

PROC PRINT only

PROC REPORT and PROC PRINT

PROC REPORT only

Clear selection

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

Given the following demography (DM) data set sorted by site with character variables SUBJID, SITE, SEX, RACE and numeric variables ENROLLDAT and DOB:

1 point

%p_demog(sex, age, statlist=%str(mean=mymeanvar))

%p_demog(sex age statlist=%str(mean=mymeanvar))

%p_demog(statlist=%str(mean=mymeanvar), sex, varlist=age)

%p_demog(statlist=%str(mean=mymeanvar), sex, age)

Clear selection

21. This question will ask you to provide a missing option.

Given an existing work data set (DM), the following code is submitted:

options <insert option here> ;

%MACRO prt(dsn=, version=) ;
%if &dsn ne DIARY %then %do ;
proc print data = &dsn ;
title "Print of WORK.&dsn data set" ;
footnote "Version Date: &version" ;
run ;
%end ;
%MEND prt ;

%prt(dsn=DM, version=2009-12-08)

Which OPTION causes the following messages to appear in the LOG file?

<option name>(PRT): Beginning execution.
<option name>(PRT): Parameter DSN has value DM
<option name>(PRT): Parameter VERSION has value 2009-12-08
<option name>(PRT): %IF condition &dsn ne DIARY is TRUE
<option name>(PRT): Ending execution.

Select one:

1 point

SYMBOLGEN

MRECALL

MLOGIC

MPRINT

Clear selection

22. Which OPTION displays all SAS language statements generated during macro execution?

Select one:

1 point

MSTORED

MLOGIC

MPRINT

MRECALL

Clear selection

23. Given the following code executed with system date and time of April 29, 2020 at 10:33 AM:

data _null_;
daytim=put("&sysdate"d,date9.)||" "||put("&systime"t,time8.);
call symputx("nowdate", daytim);
run;

%put &nowdate;

The output of the macro variable "nowdate" in the log will be:

Select one:

1 point

daytim

&nowdate

29APR2020 10:33:00

29APR2020 10:33 AM

Clear selection

24. Which statement assigns the system date and time to the character variable CURRDTTM?

Select one:

1 point

currdttm='&sysdate9 &systime';

currdttm="&sysdate9 &systime";

currdttm="%sysdate9 %systime";

currdttm='%sysdate9 %systime';

Clear selection

25. Which COMPUTE block correctly completes the code shown below to compute the ratio of the median Length to the median Weight?

1 point

A

B

C

D

Clear selection

26. In PROC REPORT, which usage creates a column in the report for each distinct formatted value of the variable listed in the DEFINE statement?

Select one:

1 point

ACROSS

ANALYSIS

GROUP

DISPLAY

Clear selection

27. Which code segment includes a statement that would reset the graphics counter and ensure a 6in by 4in image is produced?

Select one:

1 point

ods graphics / reset width = 6in height = 4in;

ods graphics / width = 6in height = 4in reset;

ods graphics / counter = 1 width = 6in height = 4in;

ods graphics / width = 6in height = 4in counter = 1 ;

Clear selection

28. By default, the PROC FREQ in the code below produces an output object named CrossTabFreqs and the PROC MEANS produces an output object named Summary.

<insert code here>

proc freq data = Work.AE;

table USUBJID*AEPTCD;
run;

proc means data = work.LB max;
class USUBJID;
var STUDYDY;
run;

Which code segment can be added prior to the PROC FREQ step to ensure that PROC MEANS produces its output object but PROC FREQ produces no output object?

Select one:

1 point

ODS SELECT Summary;

ODS SELECT NONE:

ODS EXCLUDE CrossTabFreqs;

ODS EXCLUDE ALL;

Clear selection

29. You are working with the VS data set that contains the variable Pulse. Which PROC SGPLOT step will produce the graph shown below?

1 point

A

B

C

D

Clear selection

30. The PROC SGPLOT step below needs to be modified to format the values on the horizontal axis.

proc sgplot data = work.adlb;
histogram AVAL;
<insert code here>
run;

Which statement CANNOT be used to format the values due to a syntax error?

Select one:

0 points

format AVAL 8.2;

format AVAL comma8.2;

xaxis valuesformat = 8.2;

xaxis valuesformat = comma8.2;

Clear selection