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

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

Question No.161

Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?

  1. libname sasdata #39;SAS-data-library#39;; data sasdata.mydata;

    copy mydata;

    run;

  2. libname sasdata #39;SAS-data-library#39;; data sasdata.mydata;

    keep mydata; run;

  3. libname sasdata #39;SAS-data-library#39;; data sasdata.mydata;

    save mydata; run;

  4. libname sasdata #39;SAS-data-library#39;; data sasdata.mydata;

set mydata; run;

Correct Answer: D

Question No.162

The following SAS program is submitted:

image

What is the value of the second variable in the data set WORK.AUTHORS?

  1. Hemingway

  2. Hemingwa

  3. #39; #39; (a missing value)

  4. The program contains errors. No variables are created.

Correct Answer: B

Question No.163

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

JobCategory = #39;FA#39;; JobLevel = #39;1#39;;

JobCategory = JobCategory || JobLevel; run;

Which one of the following is the value of the variable JOBCATEGORY in the output data set?

  1. FA

  2. FA1

  3. FA 1

  4. #39; #39; (missing character value)

Correct Answer: A

Question No.164

On which portion(s) of a SAS data set does the PRINT procedure report?

  1. the data portion only

  2. the descriptor portion only

  3. the descriptor portion and the data portion

  4. neither the data portion nor the descriptor portion

Correct Answer: A

Question No.165

A SAS program is submitted and the following SAS log is produced: 2 data gt100;

  1. set ia.airplanes

  2. if mpg gt 100 then output; 22 202

ERROR: File WORK.IF.DATA does not exist. ERROR: File WORK.MPG.DATA does not exist. ERROR: File WORK.GT.DATA does not exist. ERROR: File WORK.THEN.DATA does not exist. ERROR: File WORK.OUTPUT.DATA does not exist.

ERROR 22-322: Syntax error, expecting one of the following: a name,

a quoted string, (, ;, END, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.

ERROR 202-322: The option or parameter is not recognized and will be ignored. 5 run;

The IA libref was previously assigned in this SAS session. Which one of the following corrects the errors in the LOG?

  1. Delete the word THEN on the IF statement.

  2. Add a semicolon at the end of the SET statement.

  3. Place quotes around the value on the IF statement.

  4. Add an END statement to conclude the IF statement

    Correct Answer: B

    Question No.166

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

    Author = #39;Agatha Christie#39;;

    First = substr(scan(author,1,#39; ,#39;),1,1); run;

    Which one of the following is the length of the variable FIRST in the output data set?

    A.

    1

    B.

    6

    C.

    15

    D.

    200

    Correct Answer: D

    Question No.167

    Consider the following data step:

    image

    The computed variables City and State have their values assigned using two different methods, a RETAIN statement and an Assignment statement. Which statement regarding this program is true?

    1. The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.

    2. Both the RETAIN and assignment statement are being used to initialize new variables and are equally efficient. Method used is a matter of programmer preference.

    3. The assignment statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.

    4. City#39;s value will be assigned one time, State#39;s value 5 times.

Correct Answer: D

Question No.168

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

Product_Number = 5461;

Item = #39;1001#39;;

Item_Reference = Item#39;/#39;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

  1. . (missing numeric value)

  2. The value can not be determined as the program fails to execute due to errors.

Correct Answer: D

Question No.169

After a SAS program is submitted, the following is written to the SAS log:

image

What changes should be made to the KEEP statement to correct the errors in the LOG?

  1. keep=(Product Sales);

  2. keep Product, Sales;

  3. keep=Product, Sales;

  4. keep Product Sales;

Correct Answer: D

Question No.170

Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?

  1. non-missing numeric variable values only

  2. missing numeric variable values and non-missing numeric variable values only

  3. non-missing character variables and non-missing numeric variable values only

  4. missing character variables, non-missing character variables, missing numeric variable values, and non-missing numeric variable values

Correct Answer: A

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