Download SAS Base Programming for SAS (r) 9.A00-211.PassGuide.2018-06-19.131q.tqb

Vendor: SASInstitute
Exam Code: A00-211
Exam Name: SAS Base Programming for SAS (r) 9
Date: Jun 19, 2018
File Size: 3 MB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
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 2
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
Question 3
Read the table:
  
Given the SAS data set SASUSER.HOUSES:
Obs    style    bedrooms    baths    price    sqteet    street 
1    CONDO    2    1.5    80050    1200    MAIN 
2    CONDO    3    2.5    79350    1300    ELM 
3    CONDO    4    2.5    127150    1400    OAK 
4    CONDO    2    2.0    110700    1100    FIFTH 
5    TWOSTORY    4    3.0    107250    2100    SECOND 
6    TWOSTORY    2    1.0    55650    1600    WEST 
7    TWOSTORY    2    1.0    69250    1450    NORTH 
6    TWOSTORY    4    2.5    102950  2000    SOUTH 
The following SAS program is submitted:
proc report data = sasuser.houses nowd headline; 
column style price; 
where price It 100000; 
<insert DEFINE statement here> 
define price / mean width = 9 format = dollar12.; 
title; 
run; 
The following output is desired:
style    price 
-------    ------ 
CONDO    $79,700 
TWOSTORY    $62550 
Which DEFINE statement completes the program and produces the desired output?
  1. define style / width = 9,
  2. define style / orderwidth = 9;
  3. define style / group width = 9;
  4. define style / display width = 9;
Correct answer: C
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!