SAS Institute A00-212 SAS Advanced Programming Exam for SAS 9 Online Training
SAS Institute A00-212 Online Training
The questions for A00-212 were last updated at Nov 23,2024.
- Exam Code: A00-212
- Exam Name: SAS Advanced Programming Exam for SAS 9
- Certification Provider: SAS Institute
- Latest update: Nov 23,2024
Question #71
Given the following SAS data sets ONE and TWO:
ONE TWO
YEAR QTR BUDGET YEAR QTR SALES
2001 3 500 2001 4 300
2001 4 400 2002 1 600
2002 1 700
The following SAS program is submitted:
proc sql;
select one.*, sales
from one, two;
quit;
Which one of the following reports is generated?
- A . YEAR QTR BUDGET SALES 2001 4 400 300 2002 1 700 600
- B . YEAR QTR BUDGET SALES 2001 3 500 2001 4 400 300 2002 1 700 600
- C . YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 600
- D . YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 300 2001 3 500 600 2001 4 400 600 2002 1 700 600
Question #72
Given the following SAS data set ONE:
ONE
NUM VAR
1 A
2 B
3 C
Which one of the following SQL programs deletes the SAS data set ONE?
- A . proc sql; delete table one; quit;
- B . proc sql; alter table one drop num, var; quit;
- C . proc sql; drop table one; quit;
- D . proc sql; delete from one; quit;
Question #73
The SAS data set TEMP has the following distribution of values for variable A:
A Frequency
1 500,000
2 500,000
6 7,000,000
8 3,000
Which one of the following SAS programs requires the least CPU time to be processed?
- A . data new;
set temp;
if a = 8 then
b = ‘Small ‘;
else if a in(1, 2) then
b = ‘Medium’;
else if a = 6 then
b = ‘Large’;
run; - B . data new;
set temp;
if a in (1, 2) then
b = ‘Medium’;
else if a = 8 then
b = ‘Small’;
else if a = 6 then
b = ‘Large’;
run; - C . data new;
set temp;
if a = 6 then
b = ‘Large ‘;
else if a in (1, 2) then
b = ‘Medium’;
else if a = 8 then
b = ‘Small’; - D . data new;
set temp;
if a = 6 then
b = ‘Large ‘;
if a in (1, 2) then
b = ‘Small’;
run;
Latest A00-212 Dumps Valid Version with 184 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
thank you