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

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

Question No.171

The following SAS DATA step is submitted: data sasdata.atlanta

sasdata.boston work.portland work.phoenix;

set company.prdsales;

if region = #39;NE#39; then output boston; if region = #39;SE#39; then output atlanta;

if region = #39;SW#39; then output phoenix; if region = #39;NW#39; then output portland; run;

Which one of the following is true regarding the output data sets?

  1. No library references are required.

  2. The data sets listed on all the IF statements require a library reference.

  3. The data sets listed in the last two IF statements require a library reference.

  4. The data sets listed in the first two IF statements require a library reference.

Correct Answer: D

Question No.172

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

set work.monthlysales(keep = year product sales); retain monthsales {12} ;

array monthsales {12} ; do i = 1 to 12; monthsales{i} = sales; end;

cnt 1;

monthsales{cnt} = sales; run;

The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.

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

  1. The program fails execution due to data errors.

  2. The program fails execution due to syntax errors.

  3. The program runs with warnings and creates the WORK.TOTALSALES data set with 60 observations.

  4. The program runs without errors or warnings and creates the WORK.TOTALSALES data set with 60 observations

    Correct Answer: B

    Question No.173

    The contents of two SAS data sets named EMPLOYEE and SALARY are listed below: EMPLOYEE SALARY

    name age name salary Bruce 30 Bruce 40000

    Dan 35 Bruce 35000

    Dan 37000

    Dan .

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

    merge work.employee (in = inemp) work.salary (in = insal);

    by name;

    if inemp and insal; run;

    How many observations will the data set WORK.EMPSALARY contain?

    A.

    2

    B.

    4

    C.

    5

    D.

    6

    Correct Answer: B

    Question No.174

    The following SAS program is submitted:

    image

    The SAS data set WORK.SALARY is currently ordered by Gender within Department. Which inserted code will accumulate subtotals for each Gender within Department?

    1. Gender

    2. Department

    3. Gender Department

    4. Department Gender

Correct Answer: A

Question No.175

The contents of the raw data file CALENDAR are listed below:

-10-20-30

01012000

The following SAS program is submitted: data test;

infile #39;calendar#39;;

input @1 date mmddyy10.;

if date = #39;01012000#39;d then event = #39;January 1st#39;; run;

Which one of the following is the value of the EVENT variable? A. 01012000

  1. January 1st

  2. . (missing numeric value)

  3. The value can not be determined as the program fails to execute due to errors

Correct Answer: D

Question No.176

Which step displays a listing of all the data sets in the WORK library?

  1. proc contents lib=WORK run;

  2. proc contents lib=WORK.all; run;

  3. proc contents data=WORK._all_; run;

  4. proc contents data=WORK _ALL_; run;

Correct Answer: C

Question No.177

A raw data record is listed below:

-10-20-30 1999/10/25

The following SAS program is submitted:

data projectduration; infile #39;file-specification#39;; input date $ 1 – 10; run;

Which one of the following statements completes the program above and computes the duration of the project in days as of today#39;s date?

  1. duration = today( ) – put(date,ddmmyy10.);

  2. duration = today( ) – put(date,yymmdd10.);

  3. duration = today( ) – input(date,ddmmyy10.);

  4. duration = today( ) – input(date,yymmdd10.);

Correct Answer: D

Question No.178

Given the following raw data records in TEXTFILE.TXT:

image

The following output is desired:

image

Which SAS program correctly produces the desired output?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

    Correct Answer: C

    Question No.179

    A raw data file is listed below: RANCH,1250,2,1,Sheppard Avenue,quot;$64,000quot; SPLIT,1190,1,1,Rand Street,quot;$65,850quot; CONDO,1400,2,1.5,Market Street,quot;80,050quot; TWOSTORY,1810,4,3,Garris Street,quot;$107,250quot; RANCH,1500,3,3,Kemble Avenue,quot;$86,650quot;

    SPLIT,1615,4,3,West Drive,quot;94,450quot; SPLIT,1305,3,1.5,Graham Avenue,quot;$73,650quot;

    The following SAS program is submitted using the raw data file as input: data work.condo_ranch;

    infile #39;file-specification#39; dsd; input style $ @;

    if style = #39;CONDO#39; or style = #39;RANCH#39; then

    input sqfeet bedrooms baths street $ price : dollar10.; run;

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

    A.

    0

    B.

    3

    C.

    5

    D.

    7

    Correct Answer: D

    Question No.180

    Given the contents of the raw data file #39;EMPLOYEE.TXT#39;

    image

    Which SAS informat correctly completes the program?

    1. date9

    2. mmddyy10

    3. ddmmyy10

    4. mondayyr10

Correct Answer: B

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