A00-211 Actual Exam Questions

Last updated on Dec. 14, 2024.
Vendor:SAS Institute
Exam Code:A00-211
Exam Name:SAS Base Programming for SAS 9
Exam Questions:270
 

Topic 1 - Volume A

Question #1 Topic 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;
Reveal Solution Hide Solution   Discussion   2

Correct Answer: C 🗳️

Question #2 Topic 1

The following SAS program is submitted:
data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;
The SAS 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
Reveal Solution Hide Solution   Discussion   7

Correct Answer: A 🗳️

Question #3 Topic 1

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
Reveal Solution Hide Solution   Discussion   2

Correct Answer: B 🗳️

Question #4 Topic 1

Given the SAS data set SASDATA TWO:

SASDATA TWO -

X Y -
-- --
5 2
3 1
5 6
The following SAS program is submitted:
data sasuser.one two sasdata.three;
set sasdata two;
if x = 5 then output sasuser.one;
else output sasdata two;
run;
What is the result?

  • A. data set SASUSER.ONE has 5 observations data set SASUSER.TWO has 5 observations data set WORK.OTHER has 3 observations
  • B. data set SASUSER.ONE has 2 observations data set SASUSER.TWO has 2 observations data set WORK.OTHER has 1 observations
  • C. data set SASUSER.ONE has 2 observations data set SASUSER.TWO has 2 observations data set WORK.OTHER has 5 observations
  • D. No data sets are output.
Reveal Solution Hide Solution   Discussion   4

Correct Answer: A 🗳️

Question #5 Topic 1

The following SAS program is submitted:
footnote1 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
Reveal Solution Hide Solution   Discussion   1

Correct Answer: B 🗳️

file Viewing page 1 out of 54 pages.
Viewing questions 1-5 out of 270 questions
Next Questions
Browse atleast 50% to increase passing rate cup
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago