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

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

Question No.41

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

set work.staff (keep = jansales febsales marsales); array diff_sales{3} difsales1 – difsales3;

array monthly{3} jansales febsales marsales; run;

What new variables are created?

  1. JANSALES, FEBSALES and MARSALES

  2. MONTHLY1, MONTHLY2 and MONTHLY3

  3. DIFSALES1, DIFSALES2 and DIFSALES3

  4. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3

Correct Answer: C

Question No.42

Read the table:

Given the SAS data set SASUSER.HOUSES: Obsstylebedroomsbathspricesqteetstreet 1CONDO21.5800501200MAIN

2CONDO32.5793501300ELM

3CONDO42.51271501400OAK

4CONDO22.01107001100FIFTH

5TWOSTORY43.01072502100SECOND

6TWOSTORY21.0556501600WEST

7TWOSTORY21.0692501450NORTH

6TWOSTORY42.5102950 2000SOUTH

The following SAS program is submitted:

proc report data = sasuser.houses nowd headline; column style price;

where price It 100000;

lt;insert DEFINE statement heregt;

define price / mean width = 9 format = dollar12.; title;

run;

The following output is desired: styleprice

CONDO$79,700

TWOSTORY$62550

Which DEFINE statement completes the program and produces the desired output?

  1. define style / width = 9,

  2. define style / orderwidth = 9;

  3. define style / group width = 9;

  4. define style / display width = 9;

Correct Answer: C

Question No.43

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

run;

Which statement best describes the output from the submitted program?

  1. The output contains 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 contains a list of the SAS data sets that are contained in the WORK library and displays the contents of those data sets.

Correct Answer: D

Question No.44

Given the AIRPLANES data set

AlRPLANES TYPE MPG

– F-18 105

C-130 25

Harrier 75

A-6 110

The following SAS program is submitted: data gt100;

set airplanes(keep = type mpg load); load = mpg * 150;

run;

The program fails to execute due to syntax errors. What is the cause of the syntax error?

  1. MPG is not a numeric variable.

  2. LOAD is not a variable in the data set GT100.

  3. LOAD is not variable in the data set AIRPLANES.

  4. LOAD must be defined prior to the SET statement.

Correct Answer: C

Question No.45

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

fname age name salary Bruce 30 Bruce 25000

Dan 40 Bruce 35000

Dan 25000

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

by fname;

totsal salary; run;

Which one of the following statements completes the merge of the two data sets by the FNAME variable?

  1. merge work.employee work.salary (fname = name);

  2. merge work.employee work.salary (name = fname);

  3. merge work.employee

    work.salary (rename = (fname = name));

  4. merge work.employee

work.salary (rename = (name = fname));

Correct Answer: D

Question No.46

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

by descending fname;

proc sort data = work.salary; by descending fname;

data work.empdata; merge work.employee work.salary;

by fname; run;

Why does the program rail to execute?

  1. The SORT procedures contain invalid syntax.

  2. The merged data sets are not permanent SAS data sets.

  3. The RUN statement was omitted alter each or the SORT procedures.

  4. The data sets were not merged in the order by which they were sorted.

Correct Answer: D

Question No.47

The following SAS program is submitted: data temp.x;

set sasuser.y;

run;

What must be submitted prior to this SAS program for the program to execute successfully?

  1. A LIBNAME statement for the libref TEMP only must be submitted.

  2. A LIBNAME statement for the libref SASUSER only must be submitted.

  3. LIBNAME statements for the librefs TEMP and SASUSER must be submitted.

  4. No LIBNAME statement needs to be submitted.

    Correct Answer: A

    Question No.48

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

    tables gender * age / lt;insert option heregt;; run;

    The following report is created: The FREQ Procedure

    Table of gender by age Row Column

    Gender ageFrequencyPercent Percent Percent F11110.0020.0050.00

    12220.0040.0040.00

    13220.0040.0066.67

    Total550.00100.00 M11110.0020.0050.00 12330.0060.0060,00

    13110.0020.0033.33

    Total550.00100.00 Total11220.00100.00 12550.00100.00

    13330.00100.00

    Total10100.00

    Which option correctly completes the program and creates the report?

    1. LIST

    2. NOCOLS

    3. CROSSLIST

    4. NOCROSSTAB

Correct Answer: C

Question No.49

The following SAS program is submitted: data numrecords;

infile `file specification#39;; input@1 patient $15. relative$ 16-26@;

if relative = `children#39; then input @54 diagnosis $15. @; else if relative = `parents#39; then input @28 doctor $15.

clinic $ 44-53

@54 diagnosis $15. @; input age;

run;

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

A.

1

B.

2

C.

3

D.

4

Correct Answer: B

Question No.50

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

if OrigPassengers = . then#39; OrigPassengers = 100;

TransPassengers = 100; OrigPassengers = .;

TotalPassengers = sum (OrigPassengers, TransPassengers) 0; run;

What is the value of the TOTALPASSENGERS variable in the output data set?

A.

0

B.

100

C.

200

D.

(missing numeric value)

Correct Answer: B

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