Pass A00-282 Exam to Get SAS Institute Certification

1. Given the following SCORE data set:





Based on the concept of Last Observation Carried Forward, what will be the value for SCORE for the Week 12 -

2. Given the data set HE:





What will the values be of variable HOSPDURD for the two subjects?

3. Given the following two data sets EX and AE:





Which output data set is produced by the submitted SAS program?

4. Given the SAS data set WORK.BP





What is the result?

5. 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:





The following SAS program is submitted:

%macro p_demog(bylist, varlist, statlist=);

proc sort data=derived.dm out=dm;

by &bylist;

proc means data=dm;

by &bylist;

var &varlist;

output out=stats &statlist;

run;

%mend p_demog;

Which call to the p_demog macro provides only the MEAN of AGE by SEX into the output dataset STATS?

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





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?

7. You are working on validating the ADSL data set which contains the variables subject, sex, age, birth date, baseline height, and baseline weight. These variables are brought in from SDTM, and you derive new variables baseline BMI (from baseline height and weight) and age categorization (from age).





You get the following in the SAS log:





To reconcile this difference, which variable values will be most helpful to provide to the production programmer?

8. The following SAS program is submitted:

%let Av=age;

%macro LABD(Av=weight);

%let Av=gend; %mend;

%LABD(Av=height)

%put Av is &Av;

What will be written to the SAS log?

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

proc sgplot data = work.adlb;

histogram AVAL;



run;

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

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





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?

11. In CDISC, which of the following describes the usage of controlled terms, code lists, or formats?

12. A report that you are working on will require the following header lines:





Which code adds the second line of the header "Adverse Events"?

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

The following program is submitted to create a transport file for multiple data sets:





Which option will limit the files that are copied to type data?

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

15. 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?

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

Given the following log entry:





Which line of code would produce the merge issue notes in the log?

17. What is an international ethical and scientific quality standard for designing, conducting, recording and reporting trials that involve the participation of human subjects

18. The following output is displayed:





Which SAS program created this output?

19. 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.





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;



run;

20. The programmer runs a validation program of the SDTM DM domain which produces the following in the log in SAS:





What does the validator need to check?

21. 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?

22. Review the following procedure format:

PROC TTEST date=date;

class group-variable;

var variable;

run;

What is the required type of data for the variable in this procedure?

23. 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?

24. 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?

25. Which statement describes an aspect of all Phase II clinical trials?

26. A Statistical Analysis Plan defines study day as the number of days between the visit date and the date of randomization plus one day.

The following SAS program is submitted using a macro from the project's library:





How is the STUDYDAY macro defined?

27. Which two features are captured by the events general observation class of SDTM? (Choose two.)

28. The PROC COMPARE code below is intended to validate the results from a PROC FREQ.

Both the ProdFreqData and ValFreqData data sets contain 10 observations of the variable Frequency. No other variables are present in these data sets.

proc compare base = ProdFreqData

comp = ValFreqData

out = FreqDiffs

outbase outcomp outdif outnoeq

method = exact

noprint;

run;

After successfully executing this PROC COMPARE step, what is a possible reason for the FreqDiffs file to contain 30 records?

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

30. A Statistical Analysis Plan (SAP) defines the selection process for baseline records. This instructs the programmer to choose the last non-missing analyte value prior to first study drug administration (date/time).

The DEMO data set contains the date/time of first study drug administration for subject:





What will be the resulting baseline values, as selected per the SAP instructions?

31. The following SAS program is submitted:





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

Which statement must be added to the program?

32. Given the following data set DEMOG:





Which selection below would be considered hard-coding?

33. Which statement will create a report footnote that identifies the date and time that the SAS program was executed?

34. What is the main focus of 21 CFR Part 11?

35. The following SAS program is submitted:

proc sort data=SASUSER.VISIT out=PSORT; by code descending date cost; run;

Which statement is true regarding the submitted program?

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

37. The following SAS program is submitted: data WORK.ALL;





How will the data sets ONE and TWO be combined?

38. 1.The following partial output was produced from the SAS Dictionary Tables.





Which SQL statement produced this output?

39. Where would you store a value collected on a case report form but not defined in an SDTM domain?

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





Which line of code would produce the blue notes in the log?

41. Which CDISC filename contains these items?

- Variable attributes

- Controlled terminology

- Computational methods

42. 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?

43. The following question will ask you to provide a line of missing code. The following program is submitted to output observations from data set ONE that have more than one record per patient.





Please enter the line of code that will correctly complete the program. Note: Case is ignored. Do not add leading or trailing spaces to your answer.