Exambible offers free demo for A00-212 exam. "SAS Advanced Programming Exam for SAS 9", also known as A00-212 exam, is a SAS Institute Certification. This set of posts, Passing the SAS Institute A00-212 exam, will help you answer those questions. The A00-212 Questions & Answers covers all the knowledge points of the real exam. 100% real SAS Institute A00-212 exams and revised by experts!
Q33. 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
Answer: C,D
Q34. Which one of the following statements is true?
A. The WHERE statement can be executed conditionally as part of an IF statement.
B. The WHERE statement selects observations before they are brought into the PDV.
C. The subsetting IF statement works on observations before they are read into the PDV.
D. The WHERE and subsetting IF statements can be used interchangeably in all SAS programs.
Answer: B
Q35. Which one of the following programs contains a syntax error?
A. proc sql;
select product.*, cost.unitcost, sales.quantity
from product p, cost c, sales s
where p.item = c.item and
B. item = s.item;
quit;
C. proc sql;
select product.*, cost.unitcost, sales.quantity
from product, cost, sales
where product.item = cost.item and
product.item = sales.item;
quit;
D. proc sql;
select p.*, c.unitcost, s.quantity
from product as p, cost as c, sales as s
where p.item = c.item and
E. item = s.item;
quit;
F. proc sql;
select p.*, c.unitcost, s.quantity
from product, cost, sales
where product.item = cost.item and
product.item = sales.item;
quit;
Answer: D
Q36. Which one of the following automatic SAS macro variables contains the return code from a previously executed step?
A. &RC
B. &ERR
C. &SYSRC
D. &SYSERR
Answer: D
Q37. The following SAS program is submitted:
%macro test(var);
proc print data = sasuser.class;
where age > &var;
run;
%mend;
Which type of parameter is the macro variable VAR?
A. default
B. keyword
C. positional
D. command
Answer: C
Q38. The SAS data set ONE consists of five million observations and has 25 variables.
Which one of the following SAS programs successfully creates three new variables
TOTREV, TOTCOST, and PROFIT and requires the least CPU time to be processed?
A. data two;
set one;
totrev = sum(price * quantity);
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
if totrev > 1000;
run;
B. data two;
set one;
totrev = sum(price * quantity);
if totrev > 1000;
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
run;
C. data two;
set one;
totrev = sum(price * quantity);
where totrev > 1000;
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
run;
D. data two;
set one;
where totrev > 1000;
totrev = sum(price * quantity);
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
run;
Answer: B
Q39. Which one of the following statements about compressed SAS data sets is always true?
A. Each observation is treated as a single string of bytes.
B. Each observation occupies the same number of bytes.
C. An updated observation is stored in its original location.
D. New observations are added to the end of the SAS data set.
Answer: A
Q40. The following SAS program is submitted:
%let value = 9;
%let value2 = 5;
%let newval = %eval(&value / &value2);
Which one of the following is the resulting value of the macro variable NEWVAL?
A. 1
B. 2
C. 1.8
D. null
Answer: A