Download SASInstitute.A00-211.TestKing.2019-06-21.151q.vcex

Download Exam

File Info

Exam SAS Base Programming for SAS (r) 9
Number A00-211
File Name SASInstitute.A00-211.TestKing.2019-06-21.151q.vcex
Size 3 MB
Posted Jun 21, 2019
Download SASInstitute.A00-211.TestKing.2019-06-21.151q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%





Demo Questions

Question 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?


  1. data set SASUSER.ONE has 5 observations 
    data set SASUSER.TWO has 5 observations 
    data set WORK.OTHER has 3 observations
  2. data set SASUSER.ONE has 2 observations 
    data set SASUSER.TWO has 2 observations 
    data set WORK.OTHER has 1 observations
  3. data set SASUSER.ONE has 2 observations 
    data set SASUSER.TWO has 2 observations 
    data set WORK.OTHER has 5 observations
  4. No data sets are output. 
    The DATA step fails execution due to syntax errors.
Correct answer: D



Question 2

The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:
WORK.EMPLOYEE WORK.SALARY 
fname age name salary 
Bruce 30 Bruce 25000 
Dan 40 Bruce 35000 
Dan 25000 
The following SAS program is submitted:
data work.empdata; 
by fname; 
totsal + salary; 
run; 
Which one of the following statements completes the merge of the two data sets by the FNAME variable?


  1. merge work.employee 
    work.salary (fname = name);
  2. merge work.employee 
    work.salary (name = fname);
  3. merge work.employee 
    work.salary (rename = (fname = name));
  4. merge work.employee 
    work.salary (rename = (name = fname));
Correct answer: D



Question 3

The following SAS program is submitted:
data work.sales; 
do year = 1 to 5; 
do month=1 to 12; 
x+1; 
output 
end; 
end; 
run; 
How many observations are written the WORK SALES data set?


  1. 0
  2. 1
  3. 5
  4. 60
Correct answer: D



Question 4

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?


  1. 0
  2. 1
  3. 2
  4. 3
Correct answer: A



Question 5

Given the SAS data set PRICES:
PRICES 
prodid  price 
K12S    5.10    producttype 
NETWORK    sales 
15    returns 
2 
B132S  2.34    HARDWARE    300    10 
R18KY21.29    SOFTWARE    25    5 
3KL8BY 6.37    HARDWARE    125    15 
DY65DW 5.60    HARDWARE    45    5 
DGTY23 4.55    HARDWARE    67    2 
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?


  1. 0
  2. 2
  3. 3
  4. 4
Correct answer: B



Question 6

Which ODS statement option terminates output being written to an HTML rile?


  1. END
  2. QUIT
  3. STOP
  4. CLOSE
Correct answer: D



Question 7

The SAS data set PETS is sorted by the variables TYPE and BREED. 
The following SAS program is submitted:
proc print data = pets; 
var type breed; 
sum number; 
run; 
What is the result?


  1. The SUM statement produces only a grand total of NUMBER.
  2. The SUM statement produces only subtotals of NUMBER for each value of TYPE.
  3. The SUM statement produces both a grand total of NUMBER and subtotals of NUMBER for each value of TYPE.
  4. Nothing is produced by the SUM statement; the program fails to execute.
Correct answer: A



Question 8

The following SAS program is submitted:
data work.passengers; 
if OrigPassengers = . then' 
OrigPassengers = 100; 
TransPassengers = 100; 
OrigPassengers = .; 
TotalPassengers = sum (OrigPassengers, TransPassengers) +0; 
run; 
What is the value of the TOTALPASSENGERS variable in the output data set?


  1. 0
  2. 100
  3. 200
  4. (missing numeric value)
Correct answer: B



Question 9

The following SAS program is submitted:
  
How many observations are written to the WORK.SALES data set?


  1. 0
  2. 1
  3. 5
  4. 60
Correct answer: B



Question 10

The following SAS program is submitted:
  
The program fails execution due to syntax errors. What is the cause of the syntax error?


  1. The variable MONTHSALES does not exist.
  2. An array cannot be referenced on a KEEP data set option.
  3. The KEEP= data set option should be (KEEP = MONTHSALES).
  4. The KEEP= data set option should be the statement KEEP MONTHSALES.
Correct answer: B









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files