Free A00-212 Exam Braindumps
SAS Advanced Programming Exam for SAS 9 Questions 56–60 (page: 13)

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

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"?

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

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?

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?