Ensurepass

QUESTION 61

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?

 

A.

The descending option applies to the variable CODE.

B.

The variable CODE is sorted by ascending order.

C.

The PSORT data set is stored in the SASUSER library.

D.

The descending option applies to the DATE and COST variables.

 

Answer: B

 

 

QUESTION 62

This question will ask you to provide a missing option.

 

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

 

clip_image002

 

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

 

 

 

 

 

A.

intype=data

B.

memtype=data

C.

entrytype=data

D.

include=data

 

Answer: B

 

 

QUESTION 63

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

 

Given the input SAS data set LABRAW:

 

clip_image004

 

Which DO LOOP will create the output SAS data set WORK.LAB_NEW?

 

A.

 

do i=1 to 2;

visit=i;

date=dat{i};

result=num{i};

output;

end;

B.

do i=1 to 2;

visit=i;

date=dat{i};

result=num{i};

end;

output;

C.

do i=1 to 2;

do j=1 to 2;

visit=i;

date=dat{j};

result=num{j};

output;

end;

D.

do i=1 to 2;

do j=1 to 2;

visit=i;

date=dat{j};

result=num{j};

end;

output;

end;

 

Answer: A

 

 

QUESTION 64

Given the following vital signs data:

 

 

 

 

 

clip_image006

 

Baseline is defined as the last non-missing value prior to Day 1.

 

What is the value for the change from baseline for Week 1 for Subject 2?

 

A.

-23

B.

11

C.

-11

D.

23

 

Answer: C

 

 

QUESTION 65

Given the following data set:

 

 

 

 

 

clip_image008

 

Which SAS program produced this output?

 

A.

proc sort data=one(where=(age>50)) out=two;

by subjid;

run;

B.

proc sort data=one(if=(age>50)) out=two;

by subjid;

run;

C.

proc sort data=one out=two;

where=(age>50);

by subjid;

run;

D.

proc sort data=one out=two;

if age>50;

by subjid;

run;

 

Answer: A

 

 

QUESTION 66

 

This question will ask you to provide lines of missing code.

 

clip_image010

 

Which ODS statements, inserted respectively in the two locations indicated above, create a report stored in a PDF file?

 

A.

ods pdf open=’AE.pdf’;

ods pdf close;

B.

ods file open=’AE.pdf’ type=pdf;

ods file close;

C.

ods pdf file=’AE.pdf’;

ods pdf close;

D.

ods file pdf=’AE.pdf’;

ods file close;

 

Answer: C

 

 

QUESTION 67

Which SAS program will apply the data set label ‘Demographics’ to the data set named DEMO?

 

A.

data demo (label=’Demographics’);

set demo;

run;

B.

data demo;

set demo (label=’Demographics’);

run;

C.

data demo (label ‘Demographics’);

set demo;

 

 

 

 

run;

D.

data demo;

set demo;

label demo= ‘Demographics’;

run;

 

Answer: A

 

 

QUESTION 68

CORRECT TEXT

 

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

 

You want to present a column header that contains breaks within the header as indicated below.

 

clip_image012

 

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

 

clip_image014

Answer:SPLIT=’*’;,SPLIT=”*”;,SPLIT=’*’,SPLIT=”*”,SPLIT=’*’;,SPLIT=”*”;,SPLIT=’*’,SPLIT=”*”,SPLI T=’*’;,SPLIT=”*”;,SPLIT=’*’,SPLIT=”*”,SPLIT=’*’;,SPLIT=”*”;,SPLIT=’*’,SPLIT=”*”

 

A.

 

B.

 

C.

 

D.

 

 

Answer:

 

 

QUESTION 69

 

The following SAS program is submitted:

 

clip_image016

 

What will be the result when the program executes?

 

A.

num3 assigned a missing value

B.

num3 assigned a value of 0

C.

num3 assigned a value of 1

D.

An error due to mixed variable types in the assignment statement.

 

Answer: A

 

 

QUESTION 70

A SAS report procedure results in the log below.

 

clip_image018

 

What should you add to the PROC REPORT to address the blue note in this log?

 

A.

Use DEFINE statements with the WIDTH= option set large enough to print all values for each variable

B.

Specify COLWIDTH= option with a value large enough to print all values in the data

C.

Use DEFINE statements where FLOW is specified for each numeric variable

D.

Use a FORMAT statement with formats large enough to print all values for each numeric variable

 

 

 

 

 

Answer: D

 

Free VCE & PDF File for SAS A00-280 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …

 

Comments are closed.