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:


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:


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:


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:


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:


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:


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: