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

November 5, 2019

A00-201 Dumps 2019-11

, , , , , ,

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

Question No.51

Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?

  1. MSOFFICE2K

  2. EXCELXP

  3. CSVALL

  4. WINXP

Correct Answer: D

Question No.52

The following SAS program is submitted:

image

The program fails execution due to syntax errors. What is the cause of the syntax error?

  1. The variable MONTHSALES does not exist.

  2. An array cannot be referenced on a KEEP data set option.

  3. The KEEP= data set option should be (KEEP = MONTHSALES).

  4. The KEEP= data set option should be the statement KEEP MONTHSALES{12}.

Correct Answer: B

Question No.53

The following SAS program is submitted;

data combine;

country = `Italy, Russia, ireland#39;; found = find(country, `i#39;);

run;

What is the value of the variable FOUND in the output data set?

  1. 1

  2. 12

  3. Italy

  4. Russia

Correct Answer: B

Question No.54

Which statement describes a characteristic of the SAS automatic variable _ERROR_?

  1. The _ERROR_ variable maintains a count of the number of data errors in a DATA step.

  2. The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.

  3. The _ERROR_ variable can be used in expressions in the DATA step.

  4. The _ERROR_ variable contains the number of the observation that caused the data error.

Correct Answer: C

Question No.55

The following code was modified to generate the results further below: proc format;

value agegrp

low-12 =#39;Pre-Teen#39; 13-high = #39;Teen#39;; run;

proc means data=SASHELP.CLASS; var Height;

class Sex Age; format Age agegrp.; run;

The following results were generated to display only specific statistics and limit the decimals with the modification: Which statement below was modified or added to generate the results above:

image

  1. var Height / nobs min max mean maxdec=1;

  2. proc means data=SASHELP.CLASS maxdec=1 ;

  3. proc means data=SASHELP.CLASS min max mean maxdec=1;

  4. output nobs min max mean maxdec=1;

Correct Answer: C

Question No.56

The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of quot;Asking Pricequot;. Which SAS program temporarily replaces the label quot;Asking Pricequot; with the label quot;Sale Pricequot; in the output?

  1. proc print data = sasuser.houses; label price = quot;Sale Pricequot;; run;

  2. proc print data = sasuser.houses label; label price quot;Sale Pricequot;; run;

  3. proc print data = sasuser.houses label; label price = quot;Sale Pricequot;; run;

  4. proc print data = sasuser.houses; price = quot;Sale Pricequot;; run;

Correct Answer: C

Question No.57

Given the SAS data set WORK.TEMPS:

image

The following program is submitted:

image

Which output is correct?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

    Correct Answer: C

    Question No.58

    Given the data set WORK.EMPDATA:

    image

    Which one of the following where statements would display observations with job titles containing the word #39;Manager#39;?

    1. where substr(Job_Title,(length(Job_Title)-6))=#39;Manager#39;;

    2. where upcase(scan(Job_Title,-1,#39; #39;))=#39;MANAGER#39;;

    3. where Job_Title=#39;% Manager #39;;

    4. where Job_Title like #39;%Manager%#39;;

Correct Answer: D

Question No.59

Given the raw data file EMPLOYEE:

-I1 0-I20-I 30

Ruth 39 11

Jose 32 22

Sue 30 33

John 40 44

The following SAS program is submitted: data test;

infile `employee#39;;

input employee_name $ 1-4;

if employee_name = `Ruth#39; then input idnum 10-11; else input age 7-8;

run;

What value does the variable IDNUM contain when the name of the employee is quot;Ruthquot;?

A.

11

B.

22

C.

33

D.

(missing numeric value)

Correct Answer: B

Question No.60

The following SAS program is submitted:

data WORK.ONE; Text=#39;Australia, US, Denmark#39;; Pos=find(Text,#39;US#39;,#39;i#39;,5);

run;

What value will SAS assign to Pos?

A.

0

B.

1

C.

2

D.

12

Correct Answer: D

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

Related Posts