Master the A00-212 SAS Advanced Programming Exam for SAS 9 content and be ready for exam day success quickly with this Pass4sure A00-212 braindumps. We guarantee it!We make it a reality and give you real A00-212 questions in our SAS Institute A00-212 braindumps.Latest 100% VALID SAS Institute A00-212 Exam Questions Dumps at below page. You can use our SAS Institute A00-212 braindumps and pass your exam.

Q17. The following SAS program is submitted: 

%macro location; 

data _null_; 

call symput ('dept','sales'); 

run; 

%let country=Germany; 

%put_global_; 

%mend; 

%let company = ABC; 

%location; 

Which macro variables are written to the SAS log? 

A. COMPANY and DEPT only 

B. COMPANY,COUNTRY and DEPT 

C. COMPANY Only 

D. COMPANY and COUNTRY only 

Answer:


Q18. The following SAS program is submitted: 

data one; 

do i = 1 to 10; 

ptobs = ceil(ranuni(0) * totobs); 

set temp point = ptobs 

nobs = totobs; 

output; 

end; 

stop; 

run; 

The SAS data set TEMP contains 2,500,000 observations. Which one of the following represents the possible values for PTOBS? 

A. any integer between 1 and 10 

B. any real number between 0 and 1 

C. any integer between 1 and 2,500,000 

D. any real number between 1 and 2,500,000 

Answer:


Q19. The following SAS program is submitted: 

%let lib = %upcase(sasuser); 

proc sql; 

select nvar 

from dictionary.tables 

where libname = "&lib"; 

quit; 

Given that several SAS data sets exist in the SASUSER library, which one of the following is generated as output? 

A. no result set 

B. a syntax error in the log 

C. a report showing the names of each table in SASUSER 

D. a report showing the number of columns in each table in SASUSER 

Answer:


Q20. Which one of the following SAS SORT procedure options eliminates identical consecutive observations? 

A. NODUP 

B. UNIQUE 

C. DISTINCT 

D. NODUPKEY 

Answer:


Q21. Given the following SAS data sets ONE and TWO: 

ONE TWO 

OBS COMMON X OBS COMMON Y 

1 A 10 1 A 1 

2 A 13 2 A 3 

3 A 14 3 B 4 

4 B 9 4 B 2 

5 C 8 5 C 5 

6 C 14 

The following SAS DATA step is submitted: 

data combine; 

merge one two; 

by common; 

run; 

Which one of the following represents the data values stored in data set COMBINE? 

A. OBS COMMON X Y 1 A 10 1 2 A 13 3 3 A 14 3 4 B 9 4 5 B 9 2 6 C 8 5 7 C 14 5 

B. OBS COMMON X Y 1 A 10 1 2 A 13 3 3 B 9 4 4 C 8 5 

C. OBS COMMON X Y 1 A 10 1 2 A 13 3 3 B 14 4 4 B 9 2 5 C 8 5 

D. OBS COMMON X Y 1 A 10 1 2 A 13 1 3 A 14 1 4 A 10 3 5 A 13 3 6 A 14 3 7 B 9 4 8 B 9 2 9 C 8 5 10 C 14 5 

Answer:


Q22. The following SAS program is submitted: 

%let dept=prod; 

%let prod=merchandise; 

The following message is written to the SAS log: 

The value is "merchandise" 

Which SAS System option writes this message to the SAS log? 

A. %put the value is "&&&dept"; 

B. %put the value is "&&&dept"; 

C. %put the value is "&&&dept"; 

D. %put the value is %quote(&&&dept); 

Answer:


Q23. 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 procedure clause completes the program and generates the desired output? 

A. having avg(cost) < select avg(cost) from one); 

B. Having avg(cost)>(select avg(cost) from one); 

C. Where avg(cost)>(select avg(cost) from one); 

D. Where calculated average > (select avg(cost) from one); 

Answer:


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

Answer: