Latest 2014 Pass4sure and Lead2pass SAS A00-201 Practice Tests (B 1-10)

Part: B
1: The SAS data set EMPLOYEE_INFO is listed below:

The following SAS program is submitted:
proc sort data = employee_info;
      <insert BY statement here>
run;
Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?
A.by descending IDNumber Expenses;
B.by (IDNumber Expenses) descending;
C.by IDNumber descending Expenses descending;
D.by descending IDNumber descending Expenses;
Answers: D

2: The following SAS program is submitted:

data test;
     set sasuser.employees;
     if 2 le years_service le 10 then
        amount = 1000;
     else if years_service gt 10 then
         amount = 2000;
     else
         amount = 0;
     amount_per_year = years_service / amount;
run;

Which one of the following values does the variable AMOUNT_PER_YEAR contain if an employee has been with the company for one year?
A.0
B.1000
C.2000
D.. (missing numeric value)
Answers: D

3: Which one of the following is true of the RETAIN statement in a SAS DATA step program?
A.It can be used to assign an initial value to _N_ .
B.It is only valid in conjunction with a SUM function.
C.It has no effect on variables read with the SET, MERGE and UPDATE statements.
D.It adds the value of an expression to an accumulator variable and ignores missing values.
Answers: C

4: The following SAS program is submitted:

libname  rawdata1 ‘location of SAS data library’;
filename rawdata2 ‘location of raw data file’;
data work.testdata;
      infile <insert item here>;
      input sales1 sales2;
run;

Which one of the following is needed to complete the program correctly?
A.rawdata1
B.rawdata2
C.’rawdata1′
D.’rawdata2′
Answers: B

5: The following SAS program is submitted:data work.passengers;

data work.passengers;
      if OrigPassengers = . then
         OrigPassengers = 100;
     TransPassengers = 100;
      OrigPassengers = .;
      NonPaying = 10;
      TotalPassengers = OrigPassengers + TransPassengers;
run;

Which one of the following is the value of the TOTALPASSENGERS variable in the output data set?
A.100
B.110
C.200
D.. (missing numeric value)
Answers: D

6: The SAS data set named COMPANY.PRICES is listed below:

The following SAS program is submitted:

libname company ‘SAS-data-library’;
data hware inter soft;
     set company.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.4
D.6
Answers: B

7: The contents of the raw data file TYPECOLOR are listed below:

—-|—-10—|—-20—|—-30
daisyyellow
The following SAS program is submitted:
data flowers;
      infile ‘typecolor’;
      input type $ 1-5 +1 color $;
run;

Which one of the following represents the values of the variables TYPE and COLOR?

Answers: B

8: Click the Exhibit button to view the output of a FREQ procedure.
The variable STYLE has a permanent label of “Style of homes” and the variable BEDROOMS has a permanent label of “Number of bedrooms”.
Which one of the following SAS programs produced the output shown in the exhibit?

A.proc freq data = sasuser.houses;
tables style and bedrooms;
run;
B.proc freq data = sasuser.houses;
tables style * bedrooms;
run;
C.proc freq data = sasuser.houses;
tables style , bedrooms;
run;
D.proc freq data = sasuser.houses;
tables style;
tables bedrooms;
run;
Answers: D

9: The contents of the raw data file EMPLOYEE are listed below:

—-|—-10—|—-20—|—-30
Ruth  39 11
Jose  32 22
Sue   30 33
John  40 44

The following SAS program is submitted:

data test;
     infile ’employee’;
     input employee_name $ 1-4;
     if employee_name = ‘Ruth’ then input idnum 10-11;
     else input age 7-8;
run;

Which one of the following values does the variable IDNUM contain when the name of the employee is “Ruth”?
A.11
B.22
C.32
D.. (missing numeric value)
Answers: B

10: The following SAS program is submitted and reads 100 records from a raw data file:

data work.total;
      infile ‘file-specification’ end = eof;
      input name $ salary;
      totsal + salary;
      <insert IF statement here>
run;

Which one of the following IF statements writes the last observation to the output data set?
A.if end = 0;
B.if eof = 0;
C.if end = 1;
D.if eof = 1;
Answers: D

If you want to pass the SAS A00-201 exam sucessfully, recommend to read latest SAS A00-201 Braindumps full version.