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:


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:


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:


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:


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:


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:


Q71. Which one of the following options is available for SAS macro debugging? 

A. MLOGIC 

B. MDEBUG 

C. MSGLEVEL 

D. MAUTOSOURCE 

Answer:


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: