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

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

Question No.121

Which one of the following is true when SAS encounters a data error in a DATA step?

  1. The DATA step stops executing at the point of the error, and no SAS data set is created.

  2. A note is written to the SAS log explaining the error, and the DATA step continues to execute.

  3. A note appears in the SAS log that the incorrect data record was saved to a separate SAS file for further examination.

  4. The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point.

Correct Answer: B

Question No.122

The following SAS program is submitted:

image

What will the data set WORK.TEST contain?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: A

Question No.123

Given the SAS data set WORK.ORDERS:

image

The variable Order_id is numeric; Customer is character; and Ship_date is a numeric containing a SAS date value.

A programmer would like to create a new variable called Note, that shows a character value with the Order_id and Ship_date shown with a date9. format. For the first observation, Note would look like the following: quot;Order 9341 shipped on 02FEB2009quot;.

Which of the following statement will correctly create the value and assign it to Note?

  1. note=catx(#39; #39;,#39;Order#39;,order_id,#39;shipped on#39;,input(ship_date,date9.));

  2. note=catx(#39; #39;,#39;Order#39;,order_id,#39;shipped on#39;,char(ship_date,date9.));

  3. note=catx(#39; #39;,#39;Order#39;,order_id,#39;shipped on#39;,transwrd(ship_date,date9.));

  4. note=catx(#39; #39;,#39;Order#39;,order_id,#39;shipped on#39;,put(ship_date,date9.));

Correct Answer: D

Question No.124

Consider the following data step: data WORK.NEW;

set WORK.OLD;

Count 1; run;

The varaible Count is created using a sum statement. Which statement regarding this variable is true?

  1. It is assigned a value 0 when the data step begins execution.

  2. It is assigned a value of missing when the data step begins execution.

  3. It is assigned a value 0 at compile time.

  4. It is assigned a value of missing at compile time.

Correct Answer: C

Question No.125

The contents of the raw data file AMOUNT are listed below:

-10-20-30

$1,234

The following SAS program is submitted: data test;

infile #39;amount#39;; input @1 salary 6.;

if _error_ then description = #39;Problems#39;; else description = #39;No Problems#39;;

run;

Which one of the following is the value of the DESCRIPTION variable?

  1. Problems

  2. No Problems

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

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

Correct Answer: A

Question No.126

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

image

The following SAS program is submitted:

image

What is output?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: D

Question No.127

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

x = 3;

y = 2;

z = x ** y; run;

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

  1. 6

  2. 9

  3. . (missing numeric value)

  4. The program fails to execute due to errors.

Correct Answer: B

Question No.128

The following SAS DATA step is submitted: libname temp #39;SAS-data-library#39;;

data temp.report; set sasuser.houses;

newvar = price * 1.04; run;

Which one of the following statements is true regarding the program above?

  1. The program is reading from a temporary data set and writing to a temporary data set.

  2. The program is reading from a temporary data set and writing to a permanent data set.

  3. The program is reading from a permanent data set and writing to a temporary data set.

  4. The program is reading from a permanent data set and writing to a permanent data set.

Correct Answer: D

Question No.129

The following SAS program is submitted: data _null_;

set old (keep = prod sales1 sales2); file #39;file-specification#39;;

put sales1 sales2; run;

Which one of the following default delimiters separates the fields in the raw data file created?

  1. : (colon)

  2. (space)

  3. , (comma)

  4. ; (semicolon)

Correct Answer: B

Question No.130

The SAS data set WORK.AWARDS is listed below: fname points

Amy 2

Amy 1

Gerard 3

Wang 3

Wang 1

Wang 2

The following SAS program is submitted: proc sort data = work.awards;

by descending fname points; run;

Which one of the following represents how the observations are sorted?

  1. Wang 3

    Gerard 3

    Wang 2

    Amy 2

    Wang 1

    Amy 1

  2. Wang 3

    Wang 2

    Wang 1

    Gerard 3

    Amy 2

    Amy 1

  3. Wang 3

    Wang 1

    Wang 2

    Gerard 3

    Amy 2

    Amy 1

  4. Wang 1

Wang 2

Wang 3

Gerard 3

Amy 1

Amy 2

Correct Answer: D

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

Leave a Reply

Your email address will not be published. Required fields are marked *

Proudly powered by WordPress