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

11: Click the Exhibit button to view a listing of the SASUSER.HOUSES data set. 
The following SAS program is submitted:

proc report data = sasuser.houses nowd headline;
     column style price;
     where price lt 100000;
     <insert DEFINE statement here>
     define price / mean width = 9;
     title;
run;

The following ouput is created by the REPORT procedure:
 
Which one of the following DEFINE statements completes the above program and produces the above output?

A.define style / order width = 9;
B.define style / group width = 9;
C.define style / across width = 9;
D.define style / display width = 9;
Answers: B

12: The following SAS program is submitted:

data work.staff;
     JobCategory = ‘FA’;
     JobLevel = ‘1’;
    JobCategory = JobCategory || JobLevel;
run;

Which one of the following is the value of the variable JOBCATEGORY in the output data set?
A.FA
B.FA1
C.FA 1
D.’ ‘ (missing character value)
Answers: A

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

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

15: The following SAS SORT procedure step generates an output data set:

proc sort data = sasuser.houses out = report;
      by style;
run;

In which library is the output data set stored?
A.WORK
B.REPORT
C.HOUSES
D.SASUSER
Answers: A

16: A raw data record is shown below:

07Jan2002
 
Which one of the following informats would read this value and store it as a SAS date value?
A.date9.
B.ddmonyy9.
C.ddMMMyy9.
D.ddmmmyyyy9.
Answers: A

17: The following SAS DATA step is submitted:

libname temp ‘SAS-data-library’;
data temp.report;
     set sasuser.houses;
     newvar = price * 1.04;
run;

Which one of the following statements is true regarding the program above?
A.The program is reading from a temporary data set and writing to a temporary data set.
B.The program is reading from a temporary data set and writing to a permanent data set.
C.The program is reading from a permanent data set and writing to a temporary data set.
D.The program is reading from a permanent data set and writing to a permanent data set.
Answers: D

18: A raw data record is listed below:

—-|—-10—|—-20—|—-30
Printing    750
The following SAS program is submitted:
data bonus;
      infile ‘file-specification’;
      input dept $ 1 – 11 number 13 – 15;
      <insert code here>
run;

Which one of the following SAS statements completes the program and results in a value of ‘Printing750’ for the DEPARTMENT variable?
A.department = trim(dept) || number;
B.department = dept || input(number,3.);
C.department = trim(dept) || put(number,3.);
D.department = input(dept,11.) || input(number,3.);
Answers: C

19: The contents of two SAS data sets named EMPLOYEE and SALARY are listed below:
 
The following SAS program is submitted:

data work.empsalary;
    merge work.employee (in = inemp)
               work.salary (in = insal);
    by name;
    if inemp and insal;
run;

How many observations will the data set WORK.EMPSALARY contain?
A.2
B.4
C.5
D.6
Answers: B

20: Which one of the following statements is true regarding the name of a SAS array?
A.It is saved with the data set.
B.It can be used in procedures.
C.It exists only for the duration of the DATA step.
D.It can be the same as the name of a variable in the 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.