A00-212 exam

Which one of the following automatic SAS macro variables contains the return code from a previously executed step?A . &RCB . &ERRC . &SYSRCD . &SYSERRView AnswerAnswer: D

Given the SAS data set ONE: ONE NUM VAR 1 A 2 B 3 C Which SQL procedure program deletes the data set ONE?A . proc sql; Drop table one; Quit;B . proc sql; Remove table one; Quit;C . proc sql; Delete table one; Quit;D . proc sql; Delete from...

The following SAS program is submitted: data temp; set sasuser.history(kep=date); format date qtr <insert BY statement here> if first.date then total=0; total+1; if last.date; run; proc print data=temp; run SASUSER.HISTORY is sorted by the SAS date variable DATE. The following output is required: Date Total 1 13 3 15 4...

Which one of the following statements is true regarding a SAS DATA step view?A . It allows write capabilities.B . It contains global statements.C . It contains data and a descriptor portion.D . It contains a partially compiled DATA step.View AnswerAnswer: D

What is generated as a result of submitting the RANUNI function with a seed of 123?A . A missing value because 123 is an invalid argument for the RANUNI functionB . A different sequence of random numbers with each program executionC . A random number between 0 and 123D ....

Given the following SAS data set ONE: ONE REP COST SMITH 200 SMITH 400 JONES 100 SMITH 600 JONES 100 JONES 200 JONES 400 SMITH 800 JONES 100 JONES 300 The following SAS program is submitted: proc sql; select rep, avg(cost) as AVERAGE from one group by rep having avg(cost)...

The following SAS program is submitted: %let test=one; %let one=two; %let two=three; %let three=last; %put what displays is &&&&&test; What is the written to the SAS log?A . What displays is threeB . What displays is twoC . What displays is oneD . What displays is lastView AnswerAnswer: B

The following SAS program is submitted: data new(bufsize = 6144 bufno = 4); set old; run; What is the difference between the usage of BUFFSIZE= and BUFNO= options?A . BUFSIZE=specifies the size of the output buffer in kilobytes; BUFNO=specifies the number of output buffersB . BUFSIZE= specifies the size of...

Given the SAS data set ONE: ONE DIVISION SALES A 1234 A 3654 B 5678 The following SAS program is submitted: Data_null_; Set one; By divition; If first.division then Do; %let mfirst=sales; end; run; What is the value of the macro variable MFRIST when the program finishes execution?A . 1234B...

Given the SAS dataset ONE ONE SALARY 200 205 523 The following SAS program is submitted Proc sql; Select * from one <Insert Where expression here>; quit; The following output is desired: SALARY 200 205 523 Which WHERE expression completes the program and generates the desired output?A . Where salary...