Ucertify offers free demo for A00-211 exam. "SAS Base Programming for SAS ® 9", also known as A00-211 exam, is a SAS Institute Certification. This set of posts, Passing the SAS Institute A00-211 exam, will help you answer those questions. The A00-211 Questions & Answers covers all the knowledge points of the real exam. 100% real SAS Institute A00-211 exams and revised by experts!
Q33. Given the SAS data set PERM.STUDENTS:
PERM.STUDENTS NAMEAGE
---------------- Alfred14
Alice13
Barbara13
Carol14
The following SAS program is submitted:
libname perm ‘SAS data library’;
data students;
set perm.students;
file ‘file specification’;
put name $ age;
<insert statement here>
run;
The following double-spaced file is desired as output
Alfred 14
Alice 13
Barbara 13
Carol 14
Which statement completes the program and creates the desired file?
A. put
B. put/;
C. double;
D. put _null_;
Answer: A
Q34. The following SAS program is submitted:
What is the initial value of the variable Total in the following program?
A. 0
B. Missing
C. The value of the first observations Wagerate
D. Cannot be determined from the information given
Answer: B
Q35. Given the SAS data set ONE:
Given the SAS data set WORK.ONE:
The following SAS program is submitted:
Which report is produced?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: B
Q36. The following SAS program is submitted:
data work.clients;
calls = 6;
do while (calls le 6);
calls + 1;
end; run;
Which one of the following is the value of the variable CALLS in the output data set?
A. 4
B. 5
C. 6
D. 7
Answer: D
Q37. Given the SAS data set WORK.ONE:
The following SAS program is submitted:
The data set WORK.TWO is created, where Day would be 1 for Sunday, 2 for Monday, 3 for Tuesday, ... :
Which expression successfully completed the program and creates the variable DAY?
A. day(BeginDate)
B. weekday(BeginDate)
C. dayofweek(BeginDate)
D. getday(BeginDate,today())
Answer: B
Q38. Given the SAS data set WORK.ONE:
And the SAS data set WORK.TWO: The following program is submitted:
What is the first observation in the SAS data set WORK.BOTH?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q39. The following SAS program is submitted:
data work.test;
set work.staff (keep = jansales febsales marsales);
array diff_sales{3} difsales1 - difsales3;
array monthly{3} jansales febsales marsales;
run;
What new variables are created?
A. JANSALES, FEBSALES and MARSALES
B. MONTHLY1, MONTHLY2 and MONTHLY3
C. DIFSALES1, DIFSALES2 and DIFSALES3
D. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3
Answer: C
Q40. A SAS PRINT procedure output of the WORK.LEVELS data set is listed below:
Obs name level 1 Frank 1 2 Joan 2 3 Sui 2 4 Jose 3 5 Burt 4 6 Kelly . 7 Juan 1 The following SAS program is submitted: data work.expertise; set work.levels; if level = . then expertise = 'Unknown' else if level = 1 then expertise = 'Low'
else if level = 2 or 3 then
expertise = 'Medium'
else
expertise = 'High'
run;
Which of the following values does the variable EXPERTISE contain?
A. Low, Medium, and High only
B. Low, Medium, and Unknown only
C. Low, Medium, High, and Unknown only
D. Low, Medium, High, Unknown, and ' ' (missing character value)
Answer: B