SASInstitute SAS Institute Systems Certification A00-201 Questions & Answers

• Question 41:

  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

  Correct Answer: A

• Question 42:

  The following SAS program is submitted:

  proc freq data = sales; 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;

  Correct Answer: B

• Question 43:

  The following SAS program is submitted:

  data_null_;

  set old;

  put sales 1 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

  Correct Answer: A

• Question 44:

  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?

  The SORT procedures contain invalid syntax.

  The merged data sets are not permanent SAS data sets. The data sets were not merged in the order by which they were sorted. The RUN statements were omitted after each of the SORT procedures.

  A.

  B.

  C.

  D.

  Correct Answer:

• Question 45:

  A raw data record is listed below:

  ----I----10---I----20---I----30 s On, Travis,

  The following output is desired:

  relation fristname son Travis

  Which one of the following SAS programs reads the data correctly?

  A. data family/dIm = ` , `; infile `file-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;

  Correct Answer: C

• Question 46:

  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 It 60000; where price gt 100000; run;

  B. proc print data = sasuser.houses; where price It 60000 or price gt 100000; run;

  C. proc print data = sasuser.houses; where price It 60000 and price gt 100000; run;

  D. proc print data = sasuser.houses; where price It 60000 or where price gt 100000; run;

  Correct Answer: C

• Question 47:

  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

  Correct Answer: C

• Question 48:

  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

  Correct Answer: D

• Question 49:

  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

  Correct Answer: C

• Question 50:

  The following SAS program is submitted:

  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';

  Correct Answer: D