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: A
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: C
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: D
Q20. Which one of the following SAS SORT procedure options eliminates identical consecutive observations?
A. NODUP
B. UNIQUE
C. DISTINCT
D. NODUPKEY
Answer: A
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: A
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: A
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: B
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: D