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

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

Question No.151

The following program is submitted:

image

Why does the program fail?

  1. The PAGENO option is invalid in the OPTIONS statement.

  2. The RUN statement is missing after the FORMAT procedure.

  3. The format name contains a period in the VALUE statement.

  4. The LABEL option is missing from the PROC PRINT statement.

Correct Answer: C

Question No.152

Given the SAS data set WORK.ONE:

image

What value will SAS assign to Total?

A.

3

B.

1.6

C.

4.8

D.

The program fails to execute due to errors.

Correct Answer: B

Question No.153

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

length word $7;

amount = 7;

if amount = 5 then word = #39;CAT#39;;

else if amount = 7 then word = #39;DOG#39;; else word = #39;NONE!!!#39;;

amount = 5; run;

Which one of the following represents the values of the AMOUNT and WORD variables?

  1. amount word 5 DOG

  2. amount word 5 CAT

  3. amount word 7 DOG

  4. amount word

7 #39; #39; (missing character value)

Correct Answer: A

Question No.154

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

date = input(#39;13mar2000#39;,date9.); run;

Which one of the following represents the type and length of the variable DATE in the output data set?

  1. numeric, 8 bytes

  2. numeric, 9 bytes

  3. character, 8 bytes

  4. character, 9 bytes

Correct Answer: A

Question No.155

The following SAS program is submitted: libname rawdata1 #39;location of SAS data library#39;; filename rawdata2 #39;location of raw data file#39;; data work.testdata;

infile

input sales1 sales2; run;

Which one of the following is needed to complete the program correctly?

  1. rawdata1

  2. rawdata2

  3. #39;rawdata1#39;

  4. #39;rawdata2#39;

Correct Answer: B

Question No.156

The following program is submitted: proc contents data=_all_;

Which statement best describes the output from the submitted program?

  1. The output displays only a list of the SAS data sets that are contained in the WORK library.

  2. The output displays only the contents of the SAS data sets that are contained in the WORK library.

  3. The output displays only the variables in the SAS data sets that are contained in the WORK library.

  4. The output displays a list of the SAS data sets that are contained in the WORK library and displays their contents.

Correct Answer: D

Question No.157

A raw data file is listed below:

-10-20-30

squash 1.10

apples 2.25

juice 1.69

The following SAS program is submitted using the raw data file above: data groceries;

infile #39;file-specification#39;; input item $ cost;

run;

Which one of the following completes the program and produces a grand total for all COST values?

  1. grandtot = sum cost;

  2. grandtot = sum(grandtot,cost);

  3. retain grandtot 0;

    grandtot = sum(grandtot,cost);

  4. grandtot = sum(grandtot,cost); output grandtot

Correct Answer: C

Question No.158

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

-10-20-30

Janice 10

Henri 11

Michael 11

Susan 12

The following SAS program is submitted: data group;

infile #39;team#39;;

input name $15. age 2.; file #39;file-specification#39;;

put name $15. 5 age 2.; run;

Which one of the following describes the output created?

  1. a raw data file only

  2. a SAS data set named GROUP only

  3. a SAS data set named GROUP and a raw data file

  4. No output is generated as the program fails to execute due to errors.

    Correct Answer: C

    Question No.159

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

    Author = #39;Christie, Agatha#39;;

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

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

    1. A

    2. C

    3. Agatha

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

Correct Answer: A

Question No.160

A raw data file is listed below:

-10-20-30

John McCloskey 35 71

June Rosesette 10 43

Tineke Jones 9 37

The following SAS program is submitted using the raw data file as input: data work.homework;

infile #39;file-specification#39;;

input name $ age height; if age LE 10;

run;

How many observations will the WORK.HOMEWORK data set contain?

A.

0

B.

2

C.

3

D.

No data set is created as the program fails to execute due to errors.

Correct Answer: C

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