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

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

Question No.131

The following SAS program is submitted and reads 100 records from a raw data file: data work.total;

infile #39;file-specification#39; end = eof; input name $ salary;

totsal salary; run;

Which one of the following IF statements writes the last observation to the output data set?

  1. if end = 0;

  2. if eof = 0;

  3. if end = 1;

  4. if eof = 1;

Correct Answer: D

Question No.132

You#39;re attempting to read a raw data file and you see the following messages displayed in the SAS Log:

image

What does it mean?

  1. A compiler error, triggered by an invalid character for the variable Salary.

  2. An execution error, triggered by an invalid character for the variable Salary.

  3. The 1st of potentially many errors, this one occurring on the 4th observation.

  4. An error on the INPUT statement specification for reading the variable Salary.

Correct Answer: B

Question No.133

The following SAS program is submitted:

proc contents data = sasuser.airplanes; run;

Which one of the following is produced as output?

  1. the data portion of every data set in the SASUSER library

  2. the data portion of the data set SASUSER.AIRPLANES only

  3. the descriptor portion of every data set in the SASUSER library

  4. the descriptor portion of the data set SASUSER.AIRPLANES only

Correct Answer: D

Question No.134

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

do until(Prod GT 6); Prod 1;

end; run;

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

  1. . (missing)

  2. 6

  3. 7

  4. Undetermined, infinite loop.

Correct Answer: C

Question No.135

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

set work.dept1(keep = jobcode) work.dept2(rename = (jcode = jobcode)); run;

Which one of the following is the result?

  1. The variable JCODE is written to the output data set.

  2. The variable JOBCODE is written to the output data set.

  3. Neither variable JCODE nor JOBCODE is written to the output data set.

  4. The program fails to execute due to errors.

    Correct Answer: B

    Question No.136

    The following SAS program is submitted:

    image

    What is the initial value of the variable Total in the following program?

    1. 0

    2. Missing

    3. The value of the first observations Wagerate

    4. Cannot be determined from the information given

Correct Answer: B

Question No.137

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

-10-20-30

Ruth 39 11

Jose 32 22

Sue 30 33

John 40 44

The following SAS program is submitted: data test;

infile #39;employee#39;;

input employee_name $ 1-4;

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

run;

Which one of the following values does the variable AGE contain when the name of the employee is quot;Suequot;?

A.

30

B.

33

C.

40

D. . (missing numeric value)

Correct Answer: C

Question No.138

The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.;

The following SAS program is submitted:

image

What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

  1. LocalFee has format of 9. and CountryFee has a format of 7.

  2. LocalFee has format of 9. and CountryFee has a format of percent7.2

  3. Both LocalFee and CountryFee have a format of percent7.2

  4. The data step fails execution; there is no format for LocalFee.

Correct Answer: C

Question No.139

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

  1. It can be used to assign an initial value to _N_ .

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

  3. It has no effect on variables read with the SET, MERGE and UPDATE statements.

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

Correct Answer: C

Question No.140

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

mon = 3;

day = 23;

year = 2000;

date = mdy(mon,day,year); run;

Which one of the following is the value of the DATE variable?

  1. a character string with the value #39;23mar2000#39;

  2. a character string with the value #39;03/23/2000#39;

  3. a numeric value of 14692, which represents the SAS date value for March 23, 2000

  4. a numeric value of 3232000, which represents the SAS date value for March 23, 2000

Correct Answer: C

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

Leave a Reply