A00-212 exam

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"?A . %let dept = %str(research&development);B . %let...

What is the purpose of the SASFILE statement?A . It requests that SAS data set be opened and loaded into SAS memory one page at a timeB . It requests that a SAS data set the opened and loaded into SAS memory one variable at a timeC . It requests...

The following SAS program is submitted: %let a=cat; %macro animal(a=frog); %let a=bird; %mend; %animal(a=pig) %put a is &a; What is written to the SAS log?A . a is pigB . a set catC . a is frogD . a is birdView AnswerAnswer: B

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 p.item = s.item; quit;B . proc sql; select product.*, cost.unitcost, sales.quantity from product, cost, sales where product.item = cost.item and product.item...

Which SET statements option names a variable that contains the number of the observation to read during the current iteration of the DATA step?A . OBS=pointobsB . POINT=pointobsC . KEY=pointobsD . NOBS=pointobsView AnswerAnswer: B

Consider the following SAS log: 229 data sasuser.ranch sasuser.condo / view = sasuser.ranch; 230 set sasuser.houses; 231 if style = 'RANCH' then output sasuser.ranch; 232 else if style = 'CONDO' then output sasuser.condo; 233 run; NOTE: DATA STEP view saved on file SASUSER.RANCH. NOTE: A stored DATA STEP view cannot...

The following SAS ARRAY statement is submitted: array score{*} a4 - a10, a25 ; Which one of the following is the maximum number of elements stored?A . 3B . 7C . 8D . 11View AnswerAnswer: C

The following SAS program is submitted: %macro loop; data one; %do I=1 %to 3; var&I=&I; % end run; %mend; %loop After this program executes; the following is written to the SAS log: (LOOP): Beginning execution (LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3;...

The following SAS program is submitted: data new; do i=1,2,3 nextfile=compress('March' || |); infile abc filevar=nextfile end=eof; do until (eof); input dept $sales; end; run; What is the purpose of the FILEVAR=option on the INFILE statement?A . It names the variable NEXTFILE, whose value is output to the SAS data...

Given the SAS data sets ONE and TWO: The following SAS program is submitted: Proc sql; Select two.*,budget from one <insert JOIN operator here> two on one.year=two.year, Quit; The following output is desired: Which JOIN operator completes the program and generates the desired output?A . FULL JOINB . INNER JOINC...