Download SASInstitute.A00-211.Test4Prep.2019-06-18.159q.vcex

Download Exam

File Info

Exam SAS Base Programming for SAS (r) 9
Number A00-211
File Name SASInstitute.A00-211.Test4Prep.2019-06-18.159q.vcex
Size 2 MB
Posted Jun 18, 2019
Download SASInstitute.A00-211.Test4Prep.2019-06-18.159q.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

The following SAS program is submittad:
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 2

Given the following raw data record:
----I----10---I----20---I----30 
son Travis, 
The following output is desired:
Obs relation firstname 
1 son Travis 
Which SAS program correctly reads in the raw data?


  1. data family ( dIm = ‘,’); infile ‘tile specification’; input relation $ firstname $; run;
  2. options dIm = ‘,’; data family; infile ‘file specification’; input relation $ firstname $; run;
  3. data family; infile ‘file specification’ dIm = ‘,’; input relation $ firstname $; run;
  4. data family; infile ‘file specification’; input relation $ firstname $ / dim = ‘,’; run;
Correct answer: C



Question 3

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
Explanation:



Question 4

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 5

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 6

Given the SAS data set PRICES:
PRICES 
 
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?


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



Question 7

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 8

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{12}.
Correct answer: B



Question 9

Given the SAS data set EMPLOYEES:
EMPLOYEES 
NAME  SALARY 
--------   ------------ 
Innis    60000 
Jolli    50000 
Ellis    55000 
Liu    45000 
The following SAS program is submitted:
proc print data = employees; where name like ‘_i%’; 
run; 
What is contained in the output?


  1. Liu only
  2. Innis and Ellis only
  3. Innis, Ellis, and Liu only
  4. Innis, Jolli, Ellis, and Liu
Correct answer: A



Question 10

Given the SAS data set ONE:
ONE 
Obs    Dte 
-----    -------- 
1    09JAN2005 
2    12JAN2005 
The following SAS program is submitted:
data two; 
set one; 
day = <insert expression here>; 
format dte date9.; 
run; 
The data set TWO is created:
TWO     
Obs    Dte    Day 
1    09JAN2005    1 
12    JAN2005    4 
Which expression successfully completed the program and created the variable DAY?


  1. day(dte)
  2. weekday(dte)
  3. dayofweek(dte)
  4. datdif(dte,’01jan2005’d,’act/act’)
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