Download SASInstitute.CertDumps.A00-211.2018-06-27.1e.173q.vcex

SASInstitute.CertDumps.A00-211.2018-06-27.1e.173q.vcexSASInstitute.CertDumps.A00-211.2018-06-27.1e.173q.vcexSASInstitute.CertDumps.A00-211.2018-06-27.1e.173q.vcexSASInstitute.CertDumps.A00-211.2018-06-27.1e.173q.vcexSASInstitute.CertDumps.A00-211.2018-06-27.1e.173q.vcexSASInstitute.CertDumps.A00-211.2018-06-27.1e.173q.vcex
Exam SAS Base Programming for SAS (r) 9
Number A00-211
File Name SASInstitute.CertDumps.A00-211.2018-06-27.1e.173q.vcex
Size 2.72 Mb
Posted August 08, 2018

Download




How to open VCEX & EXAM Files?

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

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
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?


  • 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. 
    The DATA step fails execution due to syntax errors.
Question 2

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

Given the raw data record DEPT:
----|----10---|----20---|----30 
Printing 750 
The following SAS program is submitted:
data bonus; 
infile ‘dept’; 
inputdept$ 1-11 number 13- 15; 
<insert statement here> 
run; 
Which SAS statement completes the program and results in a value of ‘Printing750’ for the DEPARTMENT variable?


  • A: department = dept II number;
  • B: department = left(dept) II number;
  • C: department = trim(dept) number;
  • D: department=trim(dept)||put(number,3.);
Question 4

The following SAS program is submitted:
data one; 
addressl = ‘214 London Way’; 
run; 
data one; 
set one; 
address = tranwrd(address1, ‘Way’, ‘Drive’); run; 
What are the length and value of the variable ADDRESS?


  • A: Length is 14; value is ‘214 London Dri’.
  • B: Length is 14; value is ‘214 London Way’.
  • C: Length is 16; value is ‘214 London Drive’.
  • D: Length is 200; value is ‘214 London Drive’.
Question 5

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?


  • A: merge work.employee 
    work.salary (fname = name);
  • B: merge work.employee 
    work.salary (name = fname);
  • C: merge work.employee 
    work.salary (rename = (fname = name));
  • D: merge work.employee 
    work.salary (rename = (name = fname));
Question 6

Which program displays a listing of all data sets in the SASUSER library?


  • A: proc contents lib = sasuser.all; run;
  • B: proc contents data = sasuser.all; run;
  • C: proc contents lib = sasuser._alI_; run;
  • D: proc contents data = sasuser._all_; run;
Question 7

The following SAS program is submitted:
proc sort data = work.employee; 
by descending fname; 
proc sort data = work.salary; 
by descending fname; 
data work.empdata; 
merge work.employee 
work.salary; 
by fname; 
run; 
Why does the program rail to execute?


  • A: The SORT procedures contain invalid syntax.
  • B: The merged data sets are not permanent SAS data sets.
  • C: The RUN statement was omitted alter each or the SORT procedures.
  • D: The data sets were not merged in the order by which they were sorted.
Question 8

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?


  • A: data family ( dIm = ‘,’); infile ‘tile specification’; input relation $ firstname $; run;
  • B: options dIm = ‘,’; data family; infile ‘file specification’; input relation $ firstname $; run;
  • C: data family; infile ‘file specification’ dIm = ‘,’; input relation $ firstname $; run;
  • D: data family; infile ‘file specification’; input relation $ firstname $ / dim = ‘,’; run;
Question 9

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?


  • A: 0
  • B: 1
  • C: 2
  • D: 3
Question 10

Given the SAS data set PRICES:
PRICES 
prodid  price 
K12S    5.10    producttype 
NETWORK    sales 
15    returns 

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?


  • A: 0
  • B: 2
  • C: 3
  • D: 4



Comments