Exam Dumps A00-282 Practice Free Latest SASInstitute Practice Tests [Q26-Q42]

QUESTION 26
Given two data sets with the following variables:

Why is the blue note showing in the log?

The variable VISIT occurs in both data sets but is not included in the BY statement.

There are no observations with matching values for SUBJID in either data set.

There are multiple observations with the same value for SUBJID in both data sets.

One of the two data sets has multiple observations with the same value for SUBJID.

QUESTION 27
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?

the number of rows to be read from the Excel file

the number of columns to be read from the Excel file

multiple value types within a single column

multiple value types within a single row

QUESTION 28
Which statement correctly creates a SAS date variable from a character variable?

sasdate = input(chardate,date9.);

sasdate = ‘chardate’d;

sasdate = put(chardate,date9.);

sasdate = date(chardate,date9.);

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

Which output will be created by the program?

Option A

Option B

Option C

Option D

QUESTION 30
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?

ODS SELECT NONE:

ODS EXCLUDE ALL;

ODS SELECT Summary;

ODS EXCLUDE CrossTabFreqs;

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

ACROSS

ANALYSIS

DISPLAY

GROUP

QUESTION 32
Given the following data set DEMOG:

Which selection below would be considered hard-coding?

if sexcd eq 1 then sex = “Male”; else if sexcd eq 2 then sex = “Female”;

if site eq 1 then sexcd = 2; else if site eq 2 then sexcd = 1;

if site eq 1 and sexcd ne 2 then check = 1; else if site eq 2 and sexcd ne 1 then check = 2;

birthdt = input(dob, mmddyy10.);

QUESTION 33
Which date is presented using an ISO-8601 format?

19800117

01/17/1980

17/01/1980

17JAN1980

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

currdt=”&sysdate.”;

currdt=”%sysdate.”;

currdt=”sysdate.”;

currdt=”#sysdate.”;

QUESTION 35
A SAS program is submitted and the following log is written.

What is the cause of this error message?

The ARRAY declaration is syntactically incorrect.

The IF statement is syntactically incorrect.

The DO loop tries to get a value from a variable which does not exist.

The IF statement tries to get ARRAY elements which are not declared.

QUESTION 36
Which statement describes an aspect of all Phase II clinical trials?

randomized controlled multicenter trials on large patient groups

designed to assess the pharmacovigilance, pharmacokinetics, and pharmacodynamics of a drug

in vitro and in vivo experiments using wide-ranging doses of the drug

designed to assess how well the drug works and further assess safety

QUESTION 37
Which of these tasks is NOT required for a validating programmer to state that an output has been independently validated using double programming once a PROC COMPARE has been run and shows the output electronically validates?

The Statistical Analysis Plan has been approved and signed off by the sponsor.

The output is using the correct title specified in the Statistical Analysis Plan.

Counts displayed in the columns are coherent.

The output is correctly paginated.

QUESTION 38
The following SAS program is submitted:

Which alternative program creates an equivalent BASE_BP data set?

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

data BASE_BP;
set VS (keep=usubjid vsstresn);
if vstestcd in(‘DIABP’,’SYSBP’);
run;

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

data BASE_BP (keep=usubjid vsstresn vstestcd);
set VS (drop=vstestcd);
if vstestcd in(‘DIABP’,’SYSBP’);
run;

QUESTION 39
Given the following partial output data set:

Which code was used to create AGECAT?

if age <18 then AGECAT=1; if 18<=AGE<=40 then AGECAT=2; else AGECAT=3;

if age <=18 then do AGECAT=1; else if 18<AGE<=40 then do AGECAT=2; else do AGECAT=3;

if age <18 then AGECAT=1; else if 18<=AGE<=40 then AGECAT=2; else AGECAT=3;

if age <=18 then AGECAT=1; else if 18<AGE<=40 then AGECAT=2; else AGECAT=3;

QUESTION 40
Given the following information from the annotated CRF:

Which programming code will calculate the subjects’ duration (days) of an AE?

AEDUR = AESTDT – AEENDT + 1

AEDUR = AEENDT – AESTDT + 1

AEDUR = AEENDTM – AESTTM + 1

AEDUR = AESTTM – AEENDTM + 1

QUESTION 41
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.

BYSUBJID;

id;
PTON run;

BYSUBJID;
BYSUBJID;

BYSUBJID;
run;

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