Latest 2014 Pass4sure and Lead2pass SAS A00-201 Practice Tests (B 21-30)

21: Which one of the following SAS system options prevents the page number from appearing on a report?

A.NONUM
B.NOPAGE
C.NONUMBER
D.NOPAGENUM
Answers: C

22: The following SAS program is submitted:

<insert ODS statement here>
proc means data = sasuser.shoes;
     where product in (‘Sandal’ , ‘Slipper’ , ‘Boot’);
run;

Which one of the following ODS statements completes the program and sends the report to an HTML file?
A.ods html = ‘sales.html’;
B.ods file = ‘sales.html’;
C.ods file html = ‘sales.html’;
D.ods html file = ‘sales.html’;
Answers: D

23: The following SAS DATA step executes on Monday, April 25, 2000:

data newstaff;
      set staff;
      start_date = today();
run;

Which one of the following is the value of the variable START_DATE in the output data set?
A.a character string with the value ’04/25/2000′
B.a character string with the value ‘Monday, April 25, 2000’
C.the numeric value 14725, representing the SAS date for April 25, 2000
D.the numeric value 04252000, representing the SAS date for April 25, 2000
Answers: C

24: The value 110700 is stored in a numeric variable.
Which one of the following SAS formats is used to display the value as $110,700.00 in a report?
A.comma8.2
B.comma11.2
C.dollar8.2
D.dollar11.2
Answers: D

25: A raw data record is listed below:

—-|—-10—|—-20—|—-30 s
on,Travis,

The following output is desired:

Which one of the following SAS programs reads the data correctly?
A.data family / dlm = ‘,’;
infile ‘file-specification’;
input relation $ firstname $;
run;
B.options dlm = ‘,’;
data family;
infile ‘file-specification’;
input relation $ firstname $;
run;
C.data family;
infile ‘file-specification’ dlm = ‘,’;
input relation $ firstname $;
run;
D.data family;
infile ‘file-specification’;
input relation $ firstname $ / dlm = ‘,’;
run;
Answers: C

26: A realtor has two customers.  One customer wants to view a list of homes selling for less than $60,000.  The other customer wants to view a list of homes selling for greater than $100,000.
Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations?
A.proc print data = sasuser.houses;
where price lt 60000;
where price gt 100000;
run;
B.proc print data = sasuser.houses;
where price lt 60000 or price gt 100000;
run;
C.proc print data = sasuser.houses;
where price lt 60000 and price gt 100000;
run;
D.proc print data = sasuser.houses;
where price lt 60000 or where price gt 100000;
run;
Answers: B

27: 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;

Which one of the following statements explains why the program failed execution?
A.The SORT procedures contain invalid syntax.
B.The merged data sets are not permanent SAS data sets.
C.The data sets were not merged in the order by which they were sorted.
D.The RUN statements were omitted after each of the SORT procedures.
Answers: C

28: The following SAS program is submitted:

data _null_;
     set old;
     put sales1 sales2;
run;

Where is the output written?
A.the SAS log
B.the raw data file that was opened last
C.the SAS output window or an output file
D.the data set mentioned in the DATA statement
Answers: A

29: The following SAS program is submitted:

proc freq data = sales;
       <insert TABLES statement here>
run;

Click the Exhibit button to view the output from the FREQ procedure.
Which one of the following statements completes the program and produces the output?

A.tables region product;
B.tables region * product;
C.tables product region;
D.tables product * region;
Answers: B

30: The following SAS program is submitted:

data work.products;
      Product_Number = 5461;
      Item = ‘1001’;
      Item_Reference = Item||’/’||Product_Number;
run;

Which one of the following is the value of the variable ITEM_REFERENCE in the output data set?
A.1001/5461
B.1001/        5461
C.. (missing numeric value)
D.The value can not be determined as the program fails to execute due to errors.
Answers: B

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