Latest 2014 Pass4sure and Lead2pass SAS A00-201 Practice Tests (B 11-20)

 

11: A SAS PRINT procedure output of the WORK.LEVELS data set is listed below:

The following SAS program is submitted:

data work.expertise;
      set work.levels;
      if level = . then
         expertise = ‘Unknown’;
      else if level = 1 then
         expertise = ‘Low’;
      else if level = 2 or 3 then
         expertise = ‘Medium’;
      else
         expertise = ‘High’;
run;

Which of the following values does the variable EXPERTISE contain?
A.Low, Medium, and High only
B.Low, Medium, and Unknown only
C.Low, Medium, High, and Unknown only
D.Low, Medium, High, Unknown, and ‘ ‘ (missing character value)
Answers: B

12: A raw data file is listed below:

—-|—-10—|—-20—|—-30
1901 2
1905 1
1910 6
1925 .
1941 1

The following SAS program is submitted and references the raw data file above:

data coins;
      infile ‘file-specification’;
      input year quantity;
      <insert statement(s) here>
run;

Which one of the following completes the program and produces a non-missing value for the variable TOTQUANTITY in the last observation of the output data set?
A.totquantity + quantity;
B.totquantity = sum(totquantity + quantity);
C.totquantity 0;
sum totquantity;
D.retain totquantity 0;
totquantity = totquantity + quantity;
Answers: A

13: 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 ascending expense values within each ascending IDNUMBER value?
A.by Expenses IDNumber;
B.by IDNumber Expenses;
C.by ascending (IDNumber Expenses);
D.by ascending IDNumber ascending Expenses;
Answers: B

14: The contents of the raw data file TEAM are listed below:

—-|—-10—|—-20—|—-30
Janice         10
Henri          11
Michael        11
Susan          12
 
The following SAS program is submitted:

data group;
      infile ‘team’;
      input name $15. age 2.;
      file ‘file-specification’;
      put name $15. +5 age 2.;
run;

Which one of the following describes the output created?
A.a raw data file only
B.a SAS data set named GROUP only
C.a SAS data set named GROUP and a raw data file
D.No output is generated as the program fails to execute due to errors.
Answers: C

15: The SAS data set named WORK.TEST is listed below:

Which one of the following SAS programs created this data set?
A.data work.test;
capacity = 150;
if 100 le capacity le 200 then
airplanetype = ‘Large’ and staff = 10;
else airplanetype = ‘Small’ and staff = 5;
run;
B.data work.test;
capacity = 150;
if 100 le capacity le 200 then
do;
airplanetype = ‘Large’;
staff = 10;
end;
else
do;
airplanetype = ‘Small’;
staff = 5;
end;
run;
C.data work.test;
capacity = 150;
if 100 le capacity le 200 then
do;
airplanetype = ‘Large’;
staff = 10;
else
do;
airplanetype = ‘Small’;        
airplanetype = ‘Small’;
staff = 5;
end;
run;
D.data work.test;D.data work.test;
capacity = 150;
if 100 le capacity le 200 then;
airplanetype = ‘Small’;     
airplanetype = ‘Small’;
staff = 5;
else;
airplanetype = ‘Large’;     
airplanetype = ‘Large’;
staff = 10;
run;
Answers: B

16: The contents of the raw data file AMOUNT are listed below:

—-|—-10—|—-20—|—-30
$1,234

The following SAS program is submitted:

data test;
     infile ‘amount’;
     input @1 salary 6.;
     if _error_ then description = ‘Problems’;
     else description = ‘No Problems’;
run;

Which one of the following is the value of the DESCRIPTION variable?
A.Problems
B.No Problems
C.’ ‘  (missing character value)
D.The value can not be determined as the program fails to execute due to errors.
Answers: A

17: The following SAS program is submitted:

data work.month; d
    ate = input(’13mar2000′,date9.);
run;

Which one of the following represents the type and length of the variable DATE in the output data set?
A.numeric, 8 bytes
B.numeric, 9 bytes
C.character, 8 bytes
D.character, 9 bytes
Answers: A

18: The following SAS program is submitted:

data work.new;
     length word $7;
     amount = 7;
     if amount = 5 then word = ‘CAT’;
     else if amount = 7 then word = ‘DOG’;
     else word = ‘NONE!!!’;
     amount = 5;
run;

Which one of the following represents the values of the AMOUNT and WORD variables?

Answers: A

19: The following SAS program is submitted:

data work.clients;
     calls = 6;
     do while (calls le 6);
          calls + 1;
     end;
run;

Which one of the following is the value of the variable CALLS in the output data set?
A.4
B.5
C.6
D.7
Answers: D

20: The following SAS program is submitted:

data work.total;
     set work.salary(keep = department wagerate);
     by department;
     if first.department then payroll = 0;
     payroll + wagerate;
     if last.department;
run;

The SAS data set named WORK.SALARY contains 10 observations for each department, currently ordered by DEPARTMENT.
Which one of the following is true regarding the program above?
A.The BY statement in the DATA step causes a syntax error.
B.FIRST.DEPARTMENT and LAST.DEPARTMENT are variables in the WORK.TOTAL data set.
C.The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.
D.The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORK.SALARY data set.
Answers: C

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