Your success in SAS Institute A00-212 is our sole target and we develop all our A00-212 braindumps in a way that facilitates the attainment of this target. Not only is our A00-212 study material the best you can find, it is also the most detailed and the most updated. A00-212 Practice Exams for SAS Institute A00-212 are written to the highest standards of technical accuracy.
Q65. 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) > (select avg(cost) from one);
quit;
Which one of the following reports is generated?
A. REP AVERAGE JONES 200
B. REP AVERAGE JONES 320
C. REP AVERAGE SMITH 320
D. REP AVERAGE SMITH 500
Answer: D
Q66. 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 dept = %str(research%&development);
C. %let dept = %nrstr(research&development);
D. %let dept = %nrstr(research%&development);
Answer: C
Q67. 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 function
B. A different sequence of random numbers with each program execution
C. A random number between 0 and 123
D. A consistent sequence of random numbers with each program execution
Answer: D
Q68. Given the following SAS data set ONE: ONE CATEGORY AGE SALARY BONUS
M 28 200 . M 25 100 10 F 18 100 50 F 25 200 10 The following SAS program is submitted: proc sql; create table two as select category, salary + bonus as EARNINGS from one; quit;
Which one of the following represents the data values stored in the data set TWO?
A. CATEGORY EARNINGS M 200 M 110 F 150 F 210
B. CATEGORY EARNINGS
M . M 110 F 150 F 210
C. CATEGORY SALARY BONUS EARNINGS M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210
D. CATEGORY SALARY BONUS EARNINGS M 200 . . M 100 10 110 M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210
Answer: B
Q69. Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?
A. RENAME statement only
B. CHANGE statement only
C. MODIFY and RENAME statements
D. MODIFY and CHANGE statements
Answer: B
Q70. When is it appropriate to create indexes on a SAS data set for efficient processing?
A. if small subsets of data are often retrieved
B. if the key variable has very few unique values
C. if the data are often used for BY group processing
D. if the SAS data set file page count is less than three pages
Answer: A
Q71. Which one of the following options is available for SAS macro debugging?
A. MLOGIC
B. MDEBUG
C. MSGLEVEL
D. MAUTOSOURCE
Answer: A
Q72. 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 TABLE
B. LIST TABLE
C. VALIDATE TABLE
D. CREATE TABLE
Answer: A