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

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

Question No.111

Given the SAS data set WORK.ORDERS:

image

The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format. A programmer would like to create a new variable, ship_note, that shows a character value with the order_id, shipped date, and customer name. For example, given the first observation ship_note would have the value quot;Order 9341 shipped on 02FEB2009 to Josh Martinquot;.

Which of the following statement will correctly create the value and assign it to ship_note?

  1. ship_note=catx(#39; #39;,#39;Order#39;,order_id,#39;shipped on#39;,input(shipped,date9.),#39;to#39;,customer);

  2. ship_note=catx(#39; #39;,#39;Order#39;,order_id,#39;shipped on#39;,char(shipped,date9.),#39;to#39;,customer);

  3. ship_note=catx(#39; #39;,#39;Order#39;,order_id,#39;shipped on#39;,transwrd(shipped,date9.),#39;to#39;,customer);

  4. ship_note=catx(#39; #39;,#39;Order#39;,order_id,#39;shipped on#39;,put(shipped,date9.),#39;to#39;,customer);

Correct Answer: D

Question No.112

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

do while (n lt 6); n 1;

end; run;

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

A.

4

B.

5

C.

6

D.

7

Correct Answer: C

Question No.113

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

array agents{4} $ 12 sales1 – sales4; run;

Which one of the following represents the variables that are contained in the output data set?

  1. SALES1, SALES2, SALES3, SALES4

  2. AGENTS1, AGENTS2, AGENTS3, AGENTS4

  3. None, the DATA step fails because the ARRAY statement can reference only numeric data.

  4. None, the DATA step fails because the ARRAY statement can reference only pre- existing variables.

Correct Answer: A

Question No.114

Which one of the following is true of the SUM statement in a SAS DATA step program?

  1. It is only valid in conjunction with a SUM function.

  2. It is not valid with the SET, MERGE and UPDATE statements.

  3. It adds the value of an expression to an accumulator variable and ignores missing values.

  4. It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.

Correct Answer: C

Question No.115

The following SAS program is submitted: data stats;

set revenue;

array weekly{5} mon tue wed thu fri; total = weekly{i} * .25;

output; end; run;

Which one of the following DO statements completes the program and processes the elements of the WEEKLY array?

  1. do i = 1 to 5;

  2. do weekly{i} = 1 to 5;

  3. do i = mon tue wed thu fri;

  4. A DO loop cannot be used because the variables referenced do not end in a digit.

Correct Answer: A

Question No.116

The following SAS program is submitted:

proc means data = sasuser.houses std mean max; var sqfeet;

run;

Which one of the following is needed to display the standard deviation with only two decimal places?

  1. Add the option MAXDEC = 2 to the MEANS procedure statement.

  2. Add the statement MAXDEC = 7.2; in the MEANS procedure step.

  3. Add the statement FORMAT STD 7.2; in the MEANS procedure step.

  4. Add the option FORMAT = 7.2 option to the MEANS procedure statement.

Correct Answer: A

Question No.117

The following SAS program is submitted: data WORK.DATE_INFO;

Day=quot;01quot; ;

Yr=1960 ;

X=mdy(Day,01,Yr) ; run;

What is the value of the variable X?

  1. the numeric value 0

  2. the character value quot;01011960quot;

  3. a missing value due to syntax errors

  4. the step will not compile because of the character argument in the mdy function.

Correct Answer: A

Question No.118

When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:

libname sasdata #39;SAS-data-library#39;; options obs = 500;

proc print data = sasdata.prdsales (firstobs = 100); run;

options obs = max;

proc means data = sasdata.prdsales (firstobs = 500); run;

How many observations are processed by each procedure?

  1. 400 for PROC PRINT 4500 for PROC MEANS

  2. 401 for PROC PRINT 4501 for PROC MEANS

  3. 401 for PROC PRINT 4500 for PROC MEANS

  4. 500 for PROC PRINT 5000 for PROC MEANS

Correct Answer: B

Question No.119

A SAS PRINT procedure output of the WORK.LEVELS data set is listed below: Obs name level

  1. Frank 1

  2. Joan 2

  3. Sui 2

  4. Jose 3

  5. Burt 4

  6. Kelly .

  7. Juan 1

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

set work.levels; if level = . then

expertise = #39;Unknown#39;; else if level = 1 then expertise = #39;Low#39;;

else if level = 2 or 3 then expertise = #39;Medium#39;; else

expertise = #39;High#39;; run;

Which of the following values does the variable EXPERTISE contain?

  1. Low, Medium, and High only

  2. Low, Medium, and Unknown only

  3. Low, Medium, High, and Unknown only

  4. Low, Medium, High, Unknown, and #39; #39; (missing character value)

Correct Answer: B

Question No.120

The following SAS program is submitted:

image

If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?

  1. #39; #39; (missing character value)

  2. Unknown

  3. Senior Pilot

  4. SENIOR PILOT

Correct Answer: B

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