QUESTION: 57

The following SAS program is submitted:

<insert statement here>;
%let development = ontime;
proc print data = sasuser.highway;
title "For &dept";
title2 "This project was completed &development";
run;

Which one of the following statements completes the above and resolves title1 to "For research&development"?

%let dept = %str(research&development);
%let dept = %str(research%&development);
%let dept = %nrstr(research&development);
%let dept = %nrstr(research%&development);

Answer(s): C

Reveal Solution Next Question

QUESTION: 58

Which one of the following options controls the pagesize of a SAS data set?

SIZE=
BUFNO=
BUFSIZE=
PAGESIZE=

Answer(s): C

Reveal Solution Next Question

QUESTION: 59

Given the following SAS data set ONE: ONE
ONE
REP COST
SMITH 200
SMITH 400
JONES 100
SMITH 600
JONES 100
JONES 200
JONES 400
SMITH 800
JONES 100
JONES 300
The following SAS program is submitted:
proc sql;
select rep, avg(cost) as AVERAGE
from one
group by rep
having avg(cost) > (select avg(cost) from one);
quit;

Which one of the following reports is generated?

REP AVERAGE JONES 200
REP AVERAGE JONES 320
REP AVERAGE SMITH 320
REP AVERAGE SMITH 500

Answer(s): D

Reveal Solution Next Question

QUESTION: 60

The following SAS program is submitted:

proc sort data = sales tagsort;
by month year;
run;

Which of the following resource(s) is the TAGSORT option reducing?

I/O usage only
CPU usage only
I/O and CPU usage
temporary disk usage

Answer(s): D

Reveal Solution Next Question

Free A00-212 Exam Braindumps (page: 15)

QUESTION: 57

QUESTION: 58

QUESTION: 59

QUESTION: 60