A00-212 exam

Given the SAS data set ONE: ONE REP COST SMITH 200 SMITH 400 JONES 100 SMITH 600 JONES 100 The following SAS program is submitted: Proc sql; Select rep, avg(cost) as AVERAGE From one Group by rep <insert SQL procedure clause here> quit; The following output is desired: Which SQL...

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...

The following SAS program is submitted: %macro check(num=4); %let result=%eval(&nm gt 5); %put result is &result; %mend; %check (num=10) What is written to the SAS log?A . result is trueB . result is 10 gt 5C . result is 1D . result is 0View AnswerAnswer: C

Given the following partial SAS log: NOTE: SQL table SASHELP.CLASS was created line Create table SASHELP.CLASS(bufsize=4096) ( Name char(8); Gender Char(1); Age num; Height num; Weight num ); Which SQL procedure statement generated this output?A . DESCRIBE TABLEB . LIST TABLEC . VALIDATE TABLED . CREATE TABLEView AnswerAnswer: A

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...

The following SAS program is submitted: date view=sauser.ranch; describe; run; What is the result?A . The program creates a DATA step view called SASUSEB . RANCH and places the program cod in the current editor windowC . The program retrieves the SAS source code that creates the view and places...

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?A . 10B . 20C . 30D . 40View AnswerAnswer: C

The SAS data set ONE contains fifty million observations and contains the variable PRICE, QUANTITY, FIXED and VARIABLE. Which SAS program successfully creates three new variables TOTREV, TOTCOST and PROFIT and requires the least amount of CPU resources to be processed?A . data two; Set one; Where totrev>1000; Totrev=sum(price*quantity); Totcost=sum(fixed,variable);...

Which SQL procedure program deletes rows from the data set CLASS?A . proc sql; Select * from class Where age<(select stop_age from threshold); Quit;B . proc sql; Modify table class Delete where age<(select stop_age from threshold); QuitC . proc sql; Delete from class Where age<(select stop_age from threshold); Quit;D ....

What is an advantage of using a hash object in a SAS DATA step?A . The hash object persists after the DATA step has executedB . The hash object key values can be multiple numeric and character data valuesC . The hash object automatically sorts the dataD . The hash...