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

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

Question No.1

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

set work.department; length jobcode $ 12; jobcode=#39;FAl#39;;

run;

The WORK.DEPARTMENT data set contains a character variable named JOBCODE with a length of 5. What is the result?

  1. The length of the variable JOBCODE is 3.

  2. The length of the variable JOBCODE is 5.

  3. The length of the variable JOSBODE is 12.

  4. The program fails to execute due to errors.

Correct Answer: B

Question No.2

The following SAS program is submitted:

image

How will the Exam variable value be displayed in the FREQ procedure output?

  1. Fail

  2. Pass

C. 50.5

D. . (missing numeric value)

Correct Answer: C

Question No.3

Given the SAS data set WORKAWARDS: WORK.AWARDS FNAMEPOINTSMONTH

Amy24 Amy17 Gerard33 Wang33 Wang112 Wang18

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

by descending fname points; run;

How are the observations sorted?

  1. ENAME POINTS MONTH Wang33

    Wang112 Wang18 Gerard33 Amy24 Amy17

  2. ENAME POINTS MONTH Amy24

    Amy17 Gerard33 Wang33 Wang18 Wang112

  3. ENAME POINTS MONTH Wang33 Wang18

    Wang112 Gerard33 Amy24 Amy17

  4. ENAME POINTS MONTH Wang112

Wang18 Wang33 Gerard33 Amy17 Amy24

Correct Answer: D

Question No.4

The following SAS program is submitted:

data combine; prefix=#39;505#39;; middle=#39;6465 `; end=#39;09090#39;;

lt;insert statement heregt;; run;

Which statement successfully completes the program so that TOTAL has a value of 505- 09090?

  1. total = cat(#39;-#39;, prefix, middle, end);

  2. total = catx(#39;-#39;, prefix, middle, end);

  3. total = prefix !!#39;-#39;!! middle “!!#39;-#39;!! end;

  4. total = prefix!!#39;-#39;!! left(middle)!!#39;-#39;!! end;

Correct Answer: B

Question No.5

Given the raw data record DEPT:

-|10-|20-|30

Printing 750

The following SAS program is submitted: data bonus;

infile `dept#39;;

inputdept$ 1-11 number 13- 15;

lt;insert statement heregt; run;

Which SAS statement completes the program and results in a value of `Printing750#39; for the DEPARTMENT variable?

  1. department = dept II number;

  2. department = left(dept) II number;

  3. department = trim(dept) number;

  4. department=trim(dept)||put(number,3.);

Correct Answer: D

Question No.6

The following SAS program is submitted:

data WORK.DATE_INFO; X=quot;01Jan1960quot; D;

run;

What variable X contains what value?

  1. the numeric value 0

  2. the character value quot;01Jan1960quot;

  3. the date value 01011960

  4. the code contains a syntax error and does not execute.

Correct Answer: A

Question No.7

The following SAS program is submitted: proc format

value score 1 – 50 = `Fail#39; 51 – 100 = `Pass#39;;

run;

proc report data = work.courses nowd; column exam;

define exam / display format = score.; run;

The variable EXAM has a value of 50.5.

How will the EXAM variable value be displayed in the REPORT procedure output?

  1. Fail

  2. Pass

C. 50.5

D. . (missing numeric value)

Correct Answer: C

Question No.8

The following SAS program is submitted: data one;

date = `04juI2005#39;d;

format date weekdate.; run;

proc print data = one; run; What output is generated?

  1. Obs date

    1 Monday, July 4, 2005

  2. Obs date

    1 July4, 2005

  3. Obs date

    1 04Jul2005

  4. Obs date

1 Monday, 07/04/2005

Correct Answer: A

Question No.9

The Excel workbook QTR1.XLS contains the following three worksheets: JAN

FEB MAR

Which statement correctly assigns a library reference to the Excel workbook?

  1. libname qtrdata #39;qtr1.xls#39;;

  2. libname #39;qtr1.xls#39; sheets=3;

  3. libname jan feb mar #39;qtr1.xls#39;;

  4. libname mydata #39;qtr1.xls#39; WORK.heets=(jan,feb,mar);

Correct Answer: A

Question No.10

Given the SAS data set ONE: ONE

ObsDte

109JAN2005

212JAN2005

The following SAS program is submitted: data two;

set one;

day = lt;insert expression heregt;; format dte date9.;

run;

The data set TWO is created: TWO

ObsDteDay 109JAN20051

12JAN20054

Which expression successfully completed the program and created the variable DAY?

  1. day(dte)

  2. weekday(dte)

  3. dayofweek(dte)

  4. datdif(dte,#39;01jan2005#39;d,#39;act/act#39;)

    Correct Answer: B

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

You must be logged in to post a comment.

Proudly powered by WordPress   Premium Style Theme by www.gopiplus.com