Cause all that matters here is passing the SAS Institute A00-211 exam. Cause all that you need is a high score of A00-211 SAS Base Programming for SAS ® 9 exam. The only one thing you need to do is downloading Examcollection A00-211 exam study guides now. We will not let you down with our money-back guarantee.

Q121. Given the contents of the raw data file TYPECOLOR: 

----I----10---I----20---I----30 

Daisyyellow 

The following SAS program is submitted: 

data flowers; 

infile ‘typecolor’; 

input type$ 1-5+1 color$; 

run; 

What are the values of the variables TYPE and COLOR? 

A. type color 

daisyyellow 

B. type color 

daisyyellow 

C. type color 

daisyyellow” “(missing character value) 

D. No values are stored for the TYPE and COLOR variables. 

Answer:


Q122. Given the raw data file AMOUNT: 

----I---- 10---I----20---I----30 

$1,234 

The following SAS program is submitted: 

data test; 

infile ‘amount’; 

input@1 salary 6.; 

if_error_then description = ‘Problems’; 

else description = ‘No Problems’; 

run; 

What is the result? 

A. The value of the DESCRIPTION variable is No Probl. 

B. The value of the DESCRIPTION variable is Problems. 

C. The value of the DESCRIPTION variable is No Problems. 

D. The value of the DESCRIPTION variable can not be determined. 

Answer:


Q123. The following SAS program is submitted: 

data work.test; 

First = 'Ipswich, England' 

City_Country = substr(First,1,7)!!', '!!'England' 

run; 

Which one of the following is the length of the variable CITY_COUNTRY in the output data set? 

A. 6 

B. 7 

C. 17 

D. 25 

Answer:


Q124. The following SAS program is submitted: 

data work.products; 

Product_Number = 5461; 

Item = '1001' 

Item_Reference = Item'/'Product_Number; 

run; 

Which one of the following is the value of the variable ITEM_REFERENCE in the output data set? 

A. 1001/5461 

B. 1001/ 5461 

C. . (missing numeric value) 

D. The value can not be determined as the program fails to execute due to errors. 

Answer:


Q125. Given the AIRPLANES data set 

AlRPLANES TYPE MPG 

F-18 105 

C-130 25 

Harrier 75 

A-6 110 

The following SAS program is submitted: 

data gt100; 

set airplanes(keep = type mpg load); 

load = mpg * 150; 

run; 

The program fails to execute due to syntax errors. 

What is the cause of the syntax error? 

A. MPG is not a numeric variable. 

B. LOAD is not a variable in the data set GT100. 

C. LOAD is not variable in the data set AIRPLANES. 

D. LOAD must be defined prior to the SET statement. 

Answer:


Q126. The Excel workbook REGIONS.XLS contains the following four worksheets: EAST 

WEST 

NORTH 

SOUTH 

The following program is submitted: 

libname MYXLS 'regions.xls' 

Which PROC PRINT step correctly displays the NORTH worksheet? 

A. proc print data=MYXLS.NORTH; run; 

B. proc print data=MYXLS.NORTH$; run; 

C. proc print data=MYXLS.'NORTH'e; run; 

D. proc print data=MYXLS.'NORTH$'n; run; 

Answer:


Q127. After a SAS program is submitted, the following is written to the SAS log: 

105 data WORK.JANUARY; 

106 set WORK.ALLYEAR(keep=Product Month Quantity Cost); 

107 if Month='JAN' then output WORK.JANUARY; 

108 Sales=Cost * Quantity; 

109 drop=Month Quantity Cost; 

ERROR 22-322: Syntax error, expecting one of the following: !, 

!!, , *, **, +, -, 

, <=, <>, =, >, >=, 

AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, 

NOTIN, OR, ^=, |, ||, ~=. 

110 run; 

What data set option could be attached to WORK.JANUARY to replace the DROP statement that generated the error in the log? 

A. (drop Month Quantity Cost) 

B. (drop Month, Quantity, Cost) 

C. (drop=Month, Quantity, Cost) 

D. (drop=Month Quantity Cost) 

Answer:


Q128. Given the SAS data set PRICES: 

PRICES 

Prodid priceproducttypesalesreturns 

K1255.10NETWORK152 

B132S 2.34HARDWARE30010 

R18KY2 1.29SOFTWARE255 

3KL8BY 6.37HARDWARE12515 

DY65DW 5.60HARDWARE455 

DGTY23 4.55HARDWARE672 

The following SAS program is submitted: 

data hware inter cheap; 

set prices(keep = productype price); 

if producttype = ‘HARDWARE’ then output hware; else if producttype = ‘NETWORK’ then 

output 

inter; if price le 5.00; 

run; 

if producttype = ‘HARDWARE’ then output hware; else if producttype = ‘NETWORK’ then output 

inter; if price le 5.00; 

run; 

How many observations does the HWARE data set contain? 

A. 0 

B. 2 

C. 3 

D. 4 

Answer: