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

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

Question No.91

Given the SAS data set PRICES: PRICES

Prodid priceproducttypesalesreturns K1255.10NETWORK152

B132S 2.34HARDWARE30010 R18KY2 1.29SOFTWARE255 3KL8BY 6.37HARDWARE12515 DY65DW 5.60HARDWARE455 DGTY23 4.55HARDWARE672

The following SAS program is submitted: data hware inter cheap;

set prices(keep = productype price);

if producttype = `HARDWARE#39; then output hware; else if producttype = `NETWORK#39; then output inter; if price le 5.00;

run;

if producttype = `HARDWARE#39; then output hware; else if producttype = `NETWORK#39; then output inter; if price le 5.00;

run;

How many observations does the HWARE data set contain?

A.	0
B.	2
C.	3
D.	4

Correct Answer: D

Question No.92

Which statement is true concerning the SAS automatic variable _ERROR_?

1. It cannot be used in an if/then condition.

2. It cannot be used in an assignment statement.

3. It can be put into a keep statement or keep= option.

4. It is automatically dropped.

Correct Answer: D

Question No.93

Given the contents of the raw data file TYPECOLOR:

-I10-I20-I 30

Daisyyellow

The following SAS program is submitted: data flowers;

infile `typecolor#39;;

input type$ 1-5 1 color$; run;

What are the values of the variables TYPE and COLOR?

1. type color daisygreen

2. type color daisy ellow

3. type color

   daisyyellowquot; quot;(missing character value)

4. No values are stored for the TYPE and COLOR variables.

   Correct Answer: B

   Question No.94

   Given the SAS data set PEPM.STUDENTS: PERM.STUDENTS NAME AGE

   Alfred 14 Alice13 Barbara13 Carol14

   The following SAS program is submitted: libname perm `SAS data library#39;;

   data students;

   set perm.students; file `file specification#39;;

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

   What is written to the output raw data file?

   A. I10-I20-I 30

   Alfred 14

   Alice 13

   Barbara 13

   Carol 14

   B. I10-I20-I 30

   Alfr14 Alic13 Barb13a Carol 4

   C. I10-I20-I 30

   Alfr14ed Alic130 Barb13ara Caro141

   D. I10-I20-I 30

   Alfred14 Alice13 Barbara13 Carol14

   Correct Answer: B

   Question No.95

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

   array items{3} _temporary_; run;

   What are the names of the variable(s) in the WORKTEST data set?

   1. ITEMS

   2. ITEMS1, ITEMS2, ITEMS3

   3. No variables are created because it is a temporary array.

   4. The program fails to execute because there are no variables listed on the ARRAY statement.

Correct Answer: C

Question No.96

The following SAS program is submittad: data work.sales;

do year = 1 to 5; do month=1 to 12;

x 1;

output end; end; run;

How many observations are written the WORK SALES data set?

A.	0
B.	1
C.	5
D.	60

Correct Answer: D

Question No.97

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

destination = `cph#39;; select(destination); when(#39;LHR#39;) city = `London#39;;

when(#39;CPH#39;) city = `Copenhagen#39;; otherwise city = `Other#39;;

end; run;

What is the value of the CITY variable?

1. Other

2. Copenh

3. Copenhagen

4. “(missing character value)

Correct Answer: A

Question No.98

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

1. data january;

2. set allmonths(keep = product month num_sold cost); 107 if month = `Jan#39; then output january;

108 sales = cost * num_sold; 109 keep = product sales;

– 22

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

!,

!!, amp;, *,**, , -,/, lt;,lt; =, lt;gt;, =, gt;, gt;lt;, gt;=,

AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR,^=,|,II,

110 run;

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: A

Question No.99

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

cost = `20000#39;; total= .10* cost run;

What is the result?

1. The value of the variable TOTAL in the output data set is 2000. No messages are written to the SAS log.

2. The value of the variable TOTAL in the output data set is 2000. A note that conversion has taken place is written to the SAS log.

3. The value of the variable TOTAL in the output data set is missing. An error message is written to the SAS log.

4. The variable TOTAL in the output data set has no value. The program fails to execute due to a syntax error.

Correct Answer: B

Question No.100

Read the table

The following SAS program is submitted: proc freq data = sales;

lt;insert TABLES statement heregt; run;

The following output is created by the FREQUENCY procedure:

Which TABLES statement(s) completed the program and produced the output?

1. tables region product;

2. tables region * product;

3. tables product * region;

4. tables product; tables region;

Correct Answer: B

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