Easter Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

New Release A00-212 Advanced Programmer Questions

Page: 3 / 7
Total 184 questions

SAS Advanced Programming Questions and Answers

Question 9

Given the following SAS data set named WORK.INTERNAT:

WORK.INTERNAT

LOCATION SUM

USA 30

EUR 40

The following SAS program is submitted:

%let LOC = Usa;

proc sql;

select *

from internat

where location = "&Loc";

quit;

Which one of the following is the result when the above code is executed on the above data set?

Options:

A.

A report is generated with one destination.

B.

No report is generated as the case of the compared values is different.

C.

No report is generated as the case of the macro variable name is different.

D.

A report is generated with the two original observations as the where clause does not work.

Question 10

Assume today is Tuesday, July 23, 2002. Which one of the following statements submitted at the beginning of a SAS session assigns the value Tuesday, July 23, 2002 to the macro variable START?

Options:

A.

%let start = today(),weekdate.;

B.

%let start = today(),format=weekdate.;

C.

%let start = %sysfunc(today(),weekdate.);

D.

%let start = %sysfunc(%today(),weekdate.);

Question 11

CORRECT TEXT

The following SAS program is submitted:

%macro check(num=4);

%let result=%sysevalf(&num+0.5);

%put result is &result;

%mend;

%check(num=10)

What is the written to the SAS log?

Options:

Question 12

The SAS set WORK CHECK has an index on the variable Code and the following SAS program is submitted.

proc sort data=WORK.CHECK;

by Code;

run;

What describes the result of submitting SAS program?

Options:

A.

The index on Code is updates

B.

The sort does not execute

C.

The index on Code is deleted

D.

The index on the Code unaffected

Page: 3 / 7
Total 184 questions