[Free] 2019(Nov) EnsurePass SAS Institute A00-201 Dumps with VCE and PDF 21-30

Get Full Version of the Exam
http://www.EnsurePass.com/A00-201.html

Question No.21

The following SAS program is submitted:

lt;_insert_ods_code_gt;

proc means data=SASUSER.SHOES; where Product in (#39;Sandal#39; , #39;Slipper#39; , #39;Boot#39;); run;

lt;_insert_ods_code_gt;

Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?

  1. ods html open=#39;sales.html#39;; ods html close;

  2. ods file=#39;sales.html#39; / html; ods file close;

  3. ods html file=#39;sales.html#39;; ods html close;

  4. ods file html=#39;sales.html#39;; ods file close;

Correct Answer: C

Question No.22

The following SAS program is submitted, creating the SAS data set ONE: data one;

infile `file specification#39;; input num chars$;

run; ONE

NUMCHAR

The following SAS program is submitted: proc print data = one;

where char = 23; run;

What is output?

  1. NUM CHAR 1 77

  2. NUM CHAR 1 23

    3 23

  3. NUM CHAR 1 23

    3 23

    1 77

  4. No output is generated.

Correct Answer: D

Question No.23

The following SAS program is submitted: footnote1 `Sales Report for Last Month#39;; footnote2 `Selected Products Only#39;; footnote3 `All Regions#39;;

footnote4 `All Figures in Thousands of Dollars#39;; proc print data = sasuser.shoes;

footnote2 `All Products#39;; run;

Which footnote(s) is/are displayed in the report?

  1. All Products

  2. Sales Report for Last Month All Products

  3. All Products All Regions All Figures in Thousands of Dollars

  4. Sales Report for Last Month All Products All Regions All Figures in Thousands of Dollars

Correct Answer: B

Question No.24

The following SAS program is submitted:

lt;insert ODS statement heregt;

proc means data = sasuser.shoes;

where product in (`Sandal#39; , `Slipper#39; , `Boot#39;); run;

lt;insert ODS statement heregt;

Which ODS statements complete the program and send the report to an HTML file?

  1. ods html = `sales.html#39;; ods html close;

  2. ods file = `sales.html#39;; ods file close;

  3. ods file html = `sales.html#39;; ods file close;

  4. ods html file = `sales.html#39;; ods html close;

Correct Answer: D

Question No.25

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 WORKSALARY contains 10 observations for each department, and is currently ordered by DEPARTMENT.

Which statement is true?

  1. The BY statement in the DATA step causes a syntax error.

  2. The statement payroll wagerate; in the DATA step causes a syntax error.

  3. The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.

  4. The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORKSALARY data set.

Correct Answer: C

Question No.26

What describes the SAS automatic _ERROR_ variable?

  1. The _ERROR_ variable contains the values `TRUE#39; or `FALSE.#39;

  2. The _ERROR variable maintains a count of the number of data errors.

  3. The _ERROR_ variable can be used in expressions or calculations in the DATA step.

  4. The ERROR_variable contains the number or the observation that caused the error.

Correct Answer: C

Question No.27

The following SAS program is submitted:

proc contents data = sashelp.class varnum; quit; What does the VARNUM option print?

  1. a list of variable names

  2. the total number of variables

  3. a list of the variables in alphabetic order

  4. a list of the variables in the order they were created

Correct Answer: D

Question No.28

What is the purpose or the MISSOVER option on the INFILE statement?

  1. It prevents SAS from loading a new record when the end of the current record is reached.

  2. It enables SAS to scan the input data records until the character string that is specified in the

    @`character-string#39; expression is round.

  3. It enables SAS to continue to read the next input data record if it does not find values in the current input tine for all the variables in the statement.

  4. It causes the DATA step to stop processing if an INPUT statement reaches the end of the current record without finding values for all variables in the statement.

    Correct Answer: A

    Question No.29

    The following SAS program is submitted: data work.sets;

    do until (prod gt 6); prod 1;

    end; run;

    What is the value of the variable PROD in the output data set?

    A.

    6

    B.

    7

    C.

    8

    D.

    (missing numeric)

    Correct Answer: B

    Question No.30

    The SAS data set WORK.ONE contains a numeric variable named Num ana character variable named Char:

    WORK.ONE

    Num Char

    – 1 23

    3 23

    1 77

    The following SAS program is submitted: proc print data=WORK.ONE;

    where Num=#39;1#39;; run;

    What is output?

    1. Num Char

      1 23

    2. Num Char

      1 23

      1 77

    3. Num Char

      1 23

      3 23

      1 77

    4. No output is generated.

Correct Answer: D

Get Full Version of the Exam
A00-201 Dumps
A00-201 VCE and PDF

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.