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

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

Question No.71

The Excel workbook REGIONS.XLS contains the following four worksheets: EAST

WEST NORTH SOUTH

The following program is submitted: libname MYXLS #39;regions.xls#39;;

Which PROC PRINT step correctly displays the NORTH worksheet?

  1. proc print data=MYXLS.NORTH; run;

  2. proc print data=MYXLS.NORTH$; run;

  3. proc print data=MYXLS.#39;NORTH#39;e; run;

  4. proc print data=MYXLS.#39;NORTH$#39;n; run;

    Correct Answer: D

    Question No.72

    Given the SAS data set PRICES: PRICES

    prodid price K12S5.10producttype NETWORKsales

    15returns

    B132S 2.34HARDWARE30010 R18KY21.29SOFTWARE255 3KL8BY 6.37HARDWARE12515 DY65DW 5.60HARDWARE455

    DGTY23 4.55HARDWARE672

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

    set prices (keep = producttype price); if price le 5.00;

    if producttype = `HARDWARE#39; then output HWARE; else if producttype = `NETWORK#39; then output INTER; else if producttype = `SOFTWARE#39; then output SOFT; run;

    How many observations does the HWARE data set contain?

    A.

    0

    B.

    2

    C.

    3

    D.

    4

    Correct Answer: B

    Question No.73

    The following SAS program is submitted: Data_null_;

    set old;

    put sales 1 sales2; run;

    Where is the output written?

    1. to the SAS log

    2. to the SAS data set _NULL_

    3. to the SAS output window or to an output file

    4. to the raw data file that was most recently opened

Correct Answer: A

Question No.74

The following SAS program is submitted: data ONE TWO SASUSER.TWO

set SASUSER.ONE;

run;

Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?

  1. 2 temporary and 1 permanent SAS data sets are created

  2. 3 temporary and 2 permanent SAS data sets are created

  3. 2 temporary and 2 permanent SAS data sets are created

  4. there is an error and no new data sets are created

Correct Answer: D

Question No.75

The following SAS program is submitted: data one;

addressl = `214 London Way#39;; run;

data one; set one;

address = tranwrd(address1, `Way#39;, `Drive#39;); run;

What are the length and value of the variable ADDRESS?

  1. Length is 14; value is `214 London Dri#39;.

  2. Length is 14; value is `214 London Way#39;.

  3. Length is 16; value is `214 London Drive#39;.

  4. Length is 200; value is `214 London Drive#39;.

Correct Answer: D

Question No.76

Given the SAS data set ONE:

Given the SAS data set WORK.ONE:

image

The following SAS program is submitted:

image

Which report is produced?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: B

Question No.77

Given the following raw data record: 07Jan2005

Which INFORMAT reads this raw data and stores it as a SAS date value?

  1. dmy9.

  2. date9.

  3. ddMMMyy9.

  4. ddmmmyyyy9.

Correct Answer: B

Question No.78

Which program displays a listing of all data sets in the SASUSER library?

  1. proc contents lib = sasuser.all; run;

  2. proc contents data = sasuser.all; run;

  3. proc contents lib = sasuser._alI_; run;

  4. proc contents data = sasuser._all_; run;

Correct Answer: D

Question No.79

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

data work.new; set temp.jobs;

format newdate mmddw10.; mdate = month(newdate); ddate = weekday(newdate); run;

proc print data = work.new; run;

The variable NEWDATE contains the SAS date value for April 15. 2005. What output is produced if April 15, 2005 falls on a Friday?

  1. Obsnewdate mdate ddate 104/15/2005 APR 6

  2. Obs newdate mdate ddate 104/15/2005 4 6

  3. Obs newdate mdate ddate 104/15/2005 APR 7

  4. Obs newdate mdate ddate 104/15/2005 4 7

Correct Answer: B

Question No.80

The following output is created by the FREQUENCY procedure:

image

Which TABLES statement was used to completed the following program that produced the output? proc freq data=sales;

lt;_insert_code_gt;

run;

  1. tables region product;

  2. tables region,product

  3. tables region/product;

  4. tables region*product;

Correct Answer: D

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.