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

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

Question No.191

The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below: WORK.EMPLOYEE WORK.SALARY

fname age fname salary Bruce 30 Bruce 25000

Dan 40 Bruce 35000

Dan 25000

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

merge work.employee work.salary;

by fname; totsal salary; run;

How many variables are output to the WORK.EMPDATA data set?

A.

3

B.

4

C.

5

D. No variables are output to the data set as the program fails to execute due to errors

Correct Answer: B

Question No.192

Given the SAS data set WORK.PRODUCTS:

image

How many observations does the WORK.OUTDOOR data set contain?

A.

1

B.

2

C.

3

D.

6

Correct Answer: B

Question No.193

The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY. The following SAS program is submitted:

proc sort data = work.test out = work.testsorted; by name;

run;

Which one of the following is the result of the SAS program?

  1. The data set WORK.TEST is stored in ascending order by values of the NAME variable.

  2. The data set WORK.TEST is stored in descending order by values of the NAME variable.

  3. The data set WORK.TESTSORTED is stored in ascending order by values of the NAME variable.

  4. The data set WORK.TESTSORTED is stored in descending order by values of the NAME variable.

Correct Answer: C

Question No.194

The following SAS program is submitted: data WORK.AUTHORS;

array Favorites{3} $ 8 (#39;Shakespeare#39;,#39;Hemingway#39;,#39;McCaffrey#39;); run;

What is the value of the second variable in the dataset 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.195

A realtor has two customers. One customer wants to view a list of homes selling for less than

$60,000. The other customer wants to view a list of homes selling for greater than $100,000. Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations?

  1. proc print data = sasuser.houses; where price lt 60000;

    where price gt 100000; run;

  2. proc print data = sasuser.houses; where price lt 60000 or price gt 100000; run;

  3. proc print data = sasuser.houses;

    where price lt 60000 and price gt 100000; run;

  4. proc print data = sasuser.houses;

where price lt 60000 or where price gt 100000; run;

Correct Answer: B

Question No.196

The following SAS program is submitted: proc print data = sasuser.houses;

run;

proc means data = sasuser.shoes; run;

Which one of the following OPTIONS statements resets the page number to 1 for the second report?

  1. options pageno = 1;

  2. options pagenum = 1;

  3. options reset pageno = 1;

  4. options reset pagenum = 1;

Correct Answer: A

Question No.197

Consider the data step:

image

Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?

  1. if Age not in(15,16) then Group=1; else Group=2;

  2. if (Age NE 16) or (Age NE 15) then Group=1; else Group=2;

  3. where Age not between 15 and 16 then Group=1; else Group=2;

  4. both A or C will work.

Correct Answer: A

Question No.198

The SASDATA.BANKS data set has five observations when the following SAS program is submitted:

libname sasdata #39;SAS-data-library#39;; data allobs;

set sasdata.banks; capital=0;

do year = 2000 to 2020 by 5; capital ((capital 2000) * rate); output;

end; run;

How many observations will the ALLOBS data set contain?

A. 5

B.

15

C.

20

D.

25

Correct Answer: D

Question No.199

The following SAS program is submitted:

proc sort data = sasuser.houses out = houses; by style;

run;

proc print data = houses; run;

Click on the Exhibit button to view the report produced. style bedrooms baths price

CONDO 2 1.5 80050

3 2.5 79350

4 2.5 127150

2 2.0 110700

RANCH 2 1.0 64000

3 3.0 86650

3 1.0 89100

1 1.0 34550

SPLIT 1 1.0 65850

4 3.0 94450

3 1.5 73650

TWOSTORY 4 3.0 107250

2 1.0 55850

2 1.0 69250

4 2.5 102950

Which of the following SAS statement(s) create(s) the report?

  1. id style;

  2. id style;

    var style bedrooms baths price;

  3. id style;

    by style;

    var bedrooms baths price;

  4. id style;

by style;

var style bedrooms baths price;

Correct Answer: C

Question No.200

The following SAS program is submitted:

image

How many raw data records are read during each iteration of the DATA step?

A.

1

B.

2

C.

3

D.

4

Correct Answer: B

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