Free A00-212 Exam Braindumps
SAS Advanced Programming Exam for SAS 9 Questions 86–90 (page: 19)

Given the following SAS data set ONE:
ONE
CATEGORY AGE SALARY BONUS
----
M 28 200 .
M 25 100 10
F 18 100 50
F 25 200 10
The following SAS program is submitted:
proc sql;
create table two as
select category, salary + bonus as EARNINGS
from one; quit;

Which one of the following represents the data values stored in the data set TWO?

Which one of the following SAS SORT procedure options eliminates identical consecutive observations?

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?

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?

Which one of the following SAS programs uses the most amount of memory resources for output buffers?