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

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

Question No.141

Which of the following programs correctly invokes the DATA Step Debugger?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: C

Question No.142

The contents of the SAS data set PERM.JAN_SALES are listed below: VARIABLE NAME TYPE

idnum character variable

sales_date numeric date value

A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. The SALES_DATE values need to be in a MMDDYY10 form.

Which one of the following SAS DATA steps correctly creates this raw data file?

  1. libname perm #39;SAS-data-library#39;; data _null_;

    set perm.jan_sales;

    file #39;file-specification#39; dsd = #39;,#39;;

    put idnum sales_date : mmddyy10.; run;

  2. libname perm #39;SAS-data-library#39;; data _null_;

    set perm.jan_sales;

    file #39;file-specification#39; dlm = #39;,#39;;

    put idnum sales_date : mmddyy10.; run;

  3. libname perm #39;SAS-data-library#39;; data _null_;

    set perm.jan_sales; file #39;file-specification#39;;

    put idnum sales_date : mmddyy10. dlm = #39;,#39;; run;

  4. libname perm #39;SAS-data-library#39;; data _null_;

set perm.jan_sales; file #39;file-specification#39;;

put idnum sales_date : mmddyy10. dsd = #39;,#39;; run;

Correct Answer: B

Question No.143

The following SAS DATA step executes on Monday, April 25, 2000: data newstaff;

set staff;

start_date = today(); run;

Which one of the following is the value of the variable START_DATE in the output data set?

  1. a character string with the value #39;04/25/2000#39;

  2. a character string with the value #39;Monday, April 25, 2000#39;

  3. the numeric value 14725, representing the SAS date for April 25, 2000

  4. the numeric value 04252000, representing the SAS date for April 25, 2000

Correct Answer: C

Question No.144

The following SAS SORT procedure step generates an output data set: proc sort data = sasuser.houses out = report;

by style; run;

In which library is the output data set stored?

  1. WORK

  2. REPORT.

  3. HOUSES

  4. SASUSER

Correct Answer: A

Question No.145

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

-10-20-30

72 95

The following SAS program is submitted: data test;

infile #39;size#39;;

input @1 height 2. @4 weight 2; run;

Which one of the following is the value of the variable WEIGHT in the output data set?

A.

2

B.

72

C.

95

D.

. (missing numeric value)

Correct Answer: A

Question No.146

Which one of the following SAS system options prevents the page number from appearing on a report?

  1. NONUM

  2. NOPAGE

  3. NONUMBER

  4. NOPAGENUM

Correct Answer: C

Question No.147

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;;

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

How many observations will the output data set contain?

A.

0

B.

3

C.

5

D.

7

Correct Answer: B

Question No.148

After a SAS program is submitted, the following is written to the SAS log: 105 data WORK.JANUARY;

106 set WORK.ALLYEAR(keep=Product Month Quantity Cost); 107 if Month=#39;JAN#39; then output WORK.JANUARY;

108 Sales=Cost * Quantity; 109 drop=Month Quantity Cost;

22

ERROR 22-322: Syntax error, expecting one of the following:

!,

!!, , *, **, , -,

, lt;=, lt;gt;, =, gt;, gt;=,

AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=.

110 run;

What data set option could be attached to WORK.JANUARY to replace the DROP statement that generated the error in the log?

  1. (drop Month Quantity Cost)

  2. (drop Month, Quantity, Cost)

  3. (drop=Month, Quantity, Cost)

  4. (drop=Month Quantity Cost)

Correct Answer: D

Question No.149

Which step sorts the observations of a permanent SAS data set by two variables and stores the sorted observations in a temporary SAS data set?

  1. proc sort out=EMPLOYEES data=EMPSORT; by Lname and Fname;

    run;

  2. proc sort data=SASUSER.EMPLOYEES out=EMPSORT; by Lname Fname;

    run;

  3. proc sort out=SASUSER.EMPLOYEES data=WORK.EMPSORT; by Lname Fname;

    run;

  4. proc sort data=SASUSER.EMPLOYEES out=SASUSER.EMPSORT; by Lname and Fname;

run;

Correct Answer: B

Question No.150

The SAS data set named WORK.TEST is listed below: capacity airplanetype staff

150 Large 10

Which one of the following SAS programs created this data set?

  1. data work.test; capacity = 150;

    if 100 le capacity le 200 then airplanetype = #39;Large#39; and staff = 10; else airplanetype = #39;Small#39; and staff = 5; run;

  2. data work.test; capacity = 150;

    if 100 le capacity le 200 then do;

    airplanetype = #39;Large#39;; staff = 10;

    end; else do;

    airplanetype = #39;Small#39;; staff = 5;

    end; run;

  3. data work.test; capacity = 150;

    if 100 le capacity le 200 then do;

    airplanetype = #39;Large#39;; staff = 10;

    else do;

    airplanetype = #39;Small#39;; staff = 5;

    end; run;

  4. data work.test; capacity = 150;

    if 100 le capacity le 200 then; airplanetype = #39;Small#39;;

    staff = 5; else;

    airplanetype = #39;Large#39;; staff = 10;

    run;

    Correct Answer: B

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