SAS Base Programming for SAS 9: A00-211 Exam
A00-211 Questions & Answers
Exam Code: A00-211
Exam Name: SAS Base Programming for SAS 9
Q & A: 221 Q&As
Given the SAS data set AGES:
AGES
AGE
———
The variable AGE contains character values. The following SAS program is submitted:
data subset;
set ages;
where age> 12;
run;
How many observations are written out to the data set SUBSET?
A. 0
B. 1
C. 2
D. 3
Answer: A QUESTION 2
Given the SAS data set PRICES:
PRICES
prodid price
K12S5.10producttype
NETWORKsales
15returns
B132S 2.34HARDWARE30010
R18KY21.29SOFTWARE255
3KL8BY 6.37HARDWARE12515
DY65DW 5.60HARDWARE455
DGTY23 4.55HARDWARE672
The following SAS program is submitted:
data hware inter soft;
set prices (keep = producttype price);
if price le 5.00;
if producttype = `HARDWARE’ then output HWARE;
else if producttype = `NETWORK’ then output INTER;
else if producttype = `SOFTWARE’ then output SOFT;
run;
How many observations does the HWARE data set contain?
A. 0
B. 2
C. 3
D. 4 Answer: B
QUESTION 3
The following SAS program is submitted:
data work.accounting;
set work.department;
length jobcode $ 12;
jobcode=’FAl’;
run;
The WORK.DEPARTMENT data set contains a character variable named JOBCODE with a length
of 5. What is the result?
A. The length of the variable JOBCODE is 3.
B. The length of the variable JOBCODE is 5.
C. The length of the variable JOSBODE is 12.
D. The program fails to execute due to errors.
Answer: B
QUESTION 4
Which ODS statement option terminates output being written to an HTML rile?
A. END
B. QUIT
C. STOP
D. CLOSE
Answer: D
QUESTION 5
Given the AIRPLANES data set
AlRPLANES
TYPE MPG
——– ——
F-18 105
C-130 25
Harrier 75
A-6 1 10
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
QUESTION 6
Given the raw data file EMPLOYEE:
—-I—-1 0—I—-20—I—-30
Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44
The following SAS program is submitted:
data test;
infile `employee’;
input employee_name $ 1-4;
if employee_name = `Ruth’ then input idnum 10-11;
else input age 7-8;
run;
What value does the variable IDNUM contain when the name of the employee is “Ruth”?
A. 11
B. 22
C. 33
D. (missing numeric value)
Answer: B
QUESTION 7
The following SAS program is submitted:
data temp.x;
set sasuser.y;
run;
What must be submitted prior to this SAS program for the program to execute successfully?
A. A LIBNAME statement for the libref TEMP only must be submitted.
B. A LIBNAME statement for the libref SASUSER only must be submitted.
C. LIBNAME statements for the librefs TEMP and SASUSER must be submitted.
D. No LIBNAME statement needs to be submitted.
Answer: A QUESTION 8
The data set RALESTATE has the variable LOCALFEE with a format or 9. and a variable
COUNTRYFEE with a format or 7.;
The following SAS program is submitted:
data history;
format local fee country fee percent6.;
set realestate;
local fee = local fee / 100;
country fee = country fee / 100;
run;
What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?
A. LOCALFEE has format of 9. and COUNTRYFEE has a format of 7.
B. LOCALFEE has format of 9. and COUNTRYFEE has a format of percent6.
C. LOCALFEE has format of percent6. and COUNTRYFEE has a format of percent6.
D. The data step fails execution; there is no format for LOCALFEE
Answer: C
QUESTION 9
The following SAS program is submitted:
proc freq data = class;
tables gender * age / <insert option here>;
run;
The following report is created:
The FREQ Procedure
Table of gender by age
Row Column
Gender ageFrequencyPercent Percent Percent
F11110.0020.0050.00
12220.0040.0040.00
13220.0040.0066.67
Total550.00100.00
M11110.0020.0050.00
12330.0060.0060,00
13110.0020.0033.33
Total550.00100.00
Total11220.00100.00
12550.00100.00
13330.00100.00
Total10100.00
Which option correctly completes the program and creates the report?
A. LIST
B. NOCOLS
C. CROSSLIST
D. NOCROSSTAB Answer: C
QUESTION 10
The value 110700 is stored in a numeric variable named SALARY.
Which FORMAT statement displays the value as $110,700.00 in a report?
A. format salary comma11.2;
B. format salary dollar8.2;
C. format salary dollar11.2;
D. format salary comma8.2 dollar8.2;
Answer: C … http://www.lead2pass.com/a00-211.html