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:


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:


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:


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:


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:


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:


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:


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: