A00-202 Online Practice Questions and Answers

The following SAS program is submitted:

;

%let development = ontime;

proc print data = sasuser.highway;

title "For anddept";

title2 "This project was completed anddevelopment"; run;

Which one of the following statements completes the above and resolves title1 to "For researchanddevelopment"?

A. %let dept = %str(researchanddevelopment);

B. %let dept = %str(research%anddevelopment);

C. %let dept = %nrstr(researchanddevelopment);

D. %let dept = %nrstr(research%anddevelopment);

Given the following SAS data set ONE:

ONE REP AREA COST

SMITH NORTH 100 SMITH SOUTH 200 JONES EAST 100 SMITH NORTH 300 JONES WEST 100 JONES NORTH 200 JONES NORTH 400 SMITH NORTH 400 JONES WEST 100 JONES WEST 300

The following SAS program is submitted: proc sql;

select rep, area, count(*) as TOTAL

from one group by rep, area;

quit;

Which one of the following reports is generated?

A. REP AREA COUNT

JONES EAST 100

JONES NORTH 600

JONES WEST 500

SMITH NORTH 800

SMITH SOUTH 200

B. REP AREA TOTAL

JONES EAST 100

JONES NORTH 600

JONES WEST 500

SMITH NORTH 800

SMITH SOUTH 200

C. REP AREA TOTAL

JONES EAST 1

JONES NORTH 2

JONES WEST 3

SMITH NORTH 3

JONES WEST 3

SMITH NORTH 3

SMITH SOUTH 1

D. REP AREA TOTAL

JONES EAST 1

JONES NORTH 2

JONES WEST 3

SMITH NORTH 3

SMITH SOUTH 1

SMITH NORTH 3

SMITH SOUTH 1

The following SAS FORMAT procedure is submitted:

proc format lib = sasuser;

value tempc low < 0 = 'BELOW FREEZING'

0 < 5 = 'COLD'

5 < 10 = 'MILD'

10 < 15 = 'WARM'

15 high = 'HOT';

run;

How is the value 10 displayed when the format TEMPC is applied?

A. 10

B. MILD

C. WARM

D. BELOW FREEZING

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?

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

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

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

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

Which one of the following displays the definition of a stored SQL procedure view in the SAS log?

A. ECHOVIEW option

B. EXPANDVIEW option

C. VALIDATE VIEW statement

D. DESCRIBE VIEW statement

The following SAS program is submitted:

%let a = cat;

%macro animal(a = frog);

%let a = bird;

%mend;

%animal(a = pig)

%put a is anda;

Which one of the following is written to the SAS log?

A. a is anda

B. a is cat

C. a is pig

D. a is bird

Which one of the following options is available for SAS macro debugging?

A. MLOGIC

B. MDEBUG

C. MSGLEVEL

D. MAUTOSOURCE

The following SAS program is submitted:

data temp;

array points{2,3}_temporary_;

run;

Which one of the following is the maximum number of elements that are stored?

A. 2

B. 3

C. 5

D. 6

The following SAS program is submitted:

data temp;

array points{3,2}_temporary_ (10,20,30,40,50,60); score = points{2,1}

run;

Which one of the following is the value of the variable SCORE in the data set TEMP?

A. 10

B. 20

C. 30

D. 40

Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?

A. RENAME statement only

B. CHANGE statement only

C. MODIFY and RENAME statements

D. MODIFY and CHANGE statements