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

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

Question No.31

Given the SAS data set QTR 1_REVENUE:

destinationrevenue YYZ53634 FRA62129 FRA75962 RDU76254 YYZ82174

The following SAS program is submitted: proc sort data = qtr1_revenue;

by destination descending revenue; run;

What is the first observation in the output data set?

  1. destination revenue FRA 62129

  2. destination revenue FRA 75962

  3. destination revenue YYZ 53634

  4. destination revenue YYZ 82174

Correct Answer: B

Question No.32

Given the following raw data records in DATAFILE.TXT:

image

Which output is correct based on the submitted program?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: C

Question No.33

The SAS data set PETS is sorted by the variables TYPE and BREED. The following SAS program is submitted:

proc print data = pets; var type breed;

sum number; run;

What is the result?

  1. The SUM statement produces only a grand total of NUMBER.

  2. The SUM statement produces only subtotals of NUMBER for each value of TYPE.

  3. The SUM statement produces both a grand total of NUMBER and subtotals of NUMBER for each value of TYPE.

  4. Nothing is produced by the SUM statement; the program fails to execute.

Correct Answer: A

Question No.34

Given the following data step:

image

After data step execution, what will data set WORK.GEO contain?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: A

Question No.35

Given the raw data file YEARAMT:

-|-10-|-20-|30 1901 2

1905 1

1910 6

1925 .

1941 1

The following SAS program is submitted: data coins;

infile `yearamt#39;; input year quantity;

lt;insert statement(s) heregt; run;

Which statement(s) completed the program and produced a non-missing value for the variable TOTQUANTITY in the final observation of the output data set?

  1. totquantity quantity;

  2. totquantity = sum(totquantity quantity);

  3. retain totquantity; totquantity = totquantity quantity;

  4. retain totquantity0; totquantity = totquantity quantity;

Correct Answer: A

Question No.36

The following program is submitted:

proc sort data=SASUSER.PROJECTS out=PSORT; by Code descending Date Cost;

run;

Which of the following is true concerning the submitted program?

  1. The descending option applies to the variable Code.

  2. The variable Code is sorted by ascending order.

  3. The PSORT data set is stored in the SASUSER library.

  4. The descending option applies to the Date and Cost variables.

Correct Answer: B

Question No.37

Given the SAS data set AGES: AGES

AGE

The variable AGE contains character values. The following SAS program is submitted: data subset;

set ages;

where agegt; 12; run;

How many observations are written out to the data set SUBSET?

A.

0

B.

1

C.

2

D.

3

Correct Answer: A

Question No.38

Given the raw data file AMOUNT:

-I 10-I20-I 30

$1,234

The following SAS program is submitted: data test;

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

if_error_then description = `Problems#39;; else description = `No Problems#39;;

run;

What is the result?

  1. The value of the DESCRIPTION variable is No Probl.

  2. The value of the DESCRIPTION variable is Problems.

  3. The value of the DESCRIPTION variable is No Problems.

  4. The value of the DESCRIPTION variable can not be determined.

Correct Answer: B

Question No.39

Given the following code:

proc print data=SASHELP.CLASS(firstobs=5 obs=15); where Sex=#39;M#39;;

run;

How many observations will be displayed?

  1. 11

  2. 15

  3. 10 or fewer

  4. 11 or fewer

    Correct Answer: D

    Question No.40

    Given the SAS data set WORK.EMP_NAME:

    image

    Given the SAS data set WORK.EMP_DEPT:

    image

    The following program is submitted:

    image

    How many observations are in data set WORK.ALL after submitting the program?

    A.

    1

    B.

    2

    C.

    3

    D.

    5

    Correct Answer: B

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

Leave a Reply