Exam Name:
SAS Base Programming for SAS (r) 9
Exam Type:
SAS
Exam Code:
A00-211
Total Questions:
70
Question: 1
The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a
permanent label of “Asking Price”. Which SAS program temporarily replaces the label “Asking
Price” with the label “Sale Price” in the output?
A - proc print data = sasuser.houses; label price = “Sale Price”; run;
B - proc print data = sasuser.houses label; label price “Sale Price”; run;
C - proc print data = sasuser.houses label; label price = “Sale Price”; run;
D - proc print data = sasuser.houses; price = “Sale Price”; run;
Answer: C
Question: 2
The following GAS program is submitted:
data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;
The SAG data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7
observations. How many observations will the data set WORK.EMPSALARY contain?
A - 0
B - 5
C - 7
D - 12
Answer: A
Question: 3
The following SAS program is submitted:
data work.accounting;
set work.dept1 work.dept2;
jobcode = ‘FA1’;
length jobcode $ 8;
run;
A character variable named JOBCODE is contained in both the WORK.DEPT1 and
WORK.DEPT2 SAS data sets. The variable JOBCODE has a length of 5 in the WORK.DEPT1
data set and a length of 7 in the WORK.DEPT2 data set. What is the length of the variable
JOBCODE in the output data set?
A - 3
B - 5
C - 7
D - 8
Answer: B
Question: 4
Given the SAS data set SASDATA.TWO:
Page 1 of 31

This ** preview** has intentionally

**sections.**

*blurred***to view the full version.**

*Sign up*
Exam Name:
SAS Base Programming for SAS (r) 9
Exam Type:
SAS
Exam Code:
A00-211
Total Questions:
70
SASDATA.TWO
X
Y
--
__
5
2
5
4
3
6
The following SAS program is submitted:
data sasuser.one one sasdata.three;
set sasdata two;
if x = 5 then output sasuser.one;
else output sasdata three;
run;
What is the result?
A - The data set SASUSER.ONE has 0 observations, the data set ONE has 0 observations, and
the data set SASDATA.THREE has 0 observations.
B - The data set SASUSER.ONE has 2 observations, the data set ONE has 0 observations, and
the data set SASDATA.THREE has 1 observation.
C - The data set SASUSER.ONE has 2 observations, the data set ONE has 3 observations, and
the data set SASDATA.THREE has 1 observation.
D - No data sets are output. The DATA step fails execution due to errors.
Answer: B
Question: 5
The following SAS program is submitted:
footnote 1 ‘Sales Report for Last Month’;
footnote2 ‘Selected Products Only’;
footnote3 ‘All Regions’;
footnote4 ‘All Figures in Thousands of Dollars’;
proc print data = sasuser.shoes;
footnote2 ‘All Products’;
run;
Which footnote(s) is/are displayed in the report?
A - All Products
B - Sales Report for Last Month All Products
C - All Products All Regions All Figures in Thousands of Dollars
D - Sales Report for Last Month All Products All Regions All Figures in Thousands of Dollars
Answer: B
Question: 6
Given the raw data record DEPT:
----|----10---|----20---|----30
Printing 750
The following SAS program is submitted:
Page 2 of 31