Proper study guides for Refresh SAS Institute SAS Base Programming for SAS ® 9 certified begins with SAS Institute A00-211 preparation products which designed to deliver the Downloadable A00-211 questions by making you pass the A00-211 test at your first time. Try the free A00-211 demo right now.

Q113. The following SAS program is submitted: 

What will the data set WORK.TEST contain? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer:


Q114. The following SAS program is submitted: 

proc format 

value score 1 - 50 = ‘Fail’ 

51 - 100 = ‘Pass’; 

run; 

proc report data = work.courses nowd; 

column exam; 

define exam / display format = score.; 

run; 

The variable EXAM has a value of 50.5. 

How will the EXAM variable value be displayed in the REPORT procedure output? 

A. Fail 

B. Pass 

C. 50.5 

D. (missing numeric value) 

Answer:


Q115. The following SAS program is submitted: 

data work.report; set work.sales_info; if qtr(sales_date) ge 3; run; 

The SAS data set WORK.SALES_INFO has one observation for each month in the year 2000 and the variable SALES_DATE which contains a SAS date value for each of the twelve months. 

How many of the original twelve observations in WORK.SALES_INFO are written to the WORK.REPORT data set? 

A. 2 

B. 3 

C. 6 

D. 9 

Answer:


Q116. Consider the following data step: 

data WORK.NEW; 

set WORK.OLD; 

Count+1; 

run; 

The varaible Count is created using a sum statement. Which statement regarding this variable is true? 

A. It is assigned a value 0 when the data step begins execution. 

B. It is assigned a value of missing when the data step begins execution. 

C. It is assigned a value 0 at compile time. 

D. It is assigned a value of missing at compile time. 

Answer:


Q117. Consider the following data step: 

The computed variables City and State have their values assigned using two different methods, a 

RETAIN statement and an Assignment statement. Which statement regarding this program is true? 

A. The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted. 

B. Both the RETAIN and assignment statement are being used to initialize new variables and are equally efficient. Method used is a matter of programmer preference. 

C. The assignment statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted. 

D. City's value will be assigned one time, State's value 5 times. 

Answer:


Q118. Which step sorts the observations of a permanent SAS data set by two variables and stores the sorted observations in a temporary SAS data set? 

A. proc sort out=EMPLOYEES data=EMPSORT; by Lname and Fname; run; 

B. proc sort data=SASUSER.EMPLOYEES out=EMPSORT; 

by Lname Fname; 

run; 

C. proc sort out=SASUSER.EMPLOYEES data=WORK.EMPSORT; 

by Lname Fname; 

run; 

D. proc sort data=SASUSER.EMPLOYEES out=SASUSER.EMPSORT; 

by Lname and Fname; 

run; 

Answer:


Q119. The following SAS program is submitted: 

data test; 

infile ‘file specification’; 

input name $ amount@@; 

run; 

Which of the following is true? 

A. Two @@ together are the same as one c. 

B. Two @@ hold the data records until the bottom of the DATA step. 

C. Two @@ hold the raw data record across iterations of the DATA step. 

D. Two @@ are invalid syntax and will cause the program to fail to execute. 

Answer:


Q120. The following SAS program is submittad: 

data work.sales; 

do year = 1 to 5; 

do month=1 to 12; 

x+1; 

output 

end; 

end; 

run; 

How many observations are written the WORK SALES data set? 

A. 0 

B. 1 

C. 5 

D. 60 

Answer: