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: B
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: B
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: D
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: D
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: C
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: D
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: A
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: D