SAS Institute SAS Institute Certifications A00-201 Questions & Answers

• Question 61:

  A SAS PRINT procedure output of the WORKLEVLLS 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 `Unknown';

  else if level = 1 then

  expertise = `Low';

  else if level = 2 or 3 then

  expertise = `Medium';

  else

  expertise = `High';

  run;

  Which of the following values does the variable EXPERTISE contain?

  A. Low, Medium, and High only

  B. Low, Medium, and Unknown only

  C. Low, Medium, High, and Unknown only

  D. Low, Medium, High, Unknown, and ``(missing character value)

  Correct Answer: B

• Question 62:

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

  ----I----10---I----20---I----30

  Ruth 39 11

  Jose 32 22

  Sue 30 33

  John 40 44

  The following SAS program is submitted:

  data test;

  infile `employee';

  input employee_name $ 1-4;

  it employee_name = `Ruth' then input idnum 10-11;

  else input age 7-8;

  run;

  Which one of the following values does the variable IDNUM contain when the name of the employee is "Ruth"?

  A. 11

  B. 22

  C. 32

  D. (missing numeric value)

  Correct Answer: B

• Question 63:

  Click the Exhibit button to view the output of a FREQ procedure.

  

  The variable STYLE has a permanent label of `Style of homes" and the variable BEDROOMS has a permanent label of "Number of bedrooms".

  Which one of the following SAS programs produced the output shown in the exhibit?

  A. proc freq data = sasuser.houses; tables style and bedrooms; run;

  B. proc freq data = sasuser.houses; tables style * bedrooms; run;

  C. proc freq data = sasuser.houses; tables style bedrooms; run;

  D. proc freq data = sasuser.houses; tables style; tables bedrooms; run;

  Correct Answer: B

• Question 64:

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

  ----I----10---I----20---I----30

  Daisyyellow

  The following SAS program is submitted:

  data flowers; infile `typecolor; input type$ 1-5+1 color$; run;

  Which one of the following represents the values of the variables TYPE and COLOR?

  A. type color daisy yellow

  B. type color daisy yellow

  C. type color daisy yellow (missing character value)

  D. No values are stored as the program fails to execute fails to execute due to syntax errors.

  Correct Answer: D

• Question 65:

  The following SAS program is submitted:

  libname rawdata1 `location of SAS data library'; filename rawdata2 `location of raw data file';

  data work.testdata; infile ; input sales 1 sales2; run;

  Which one of the following is needed to complete the program correctly?

  A. rawdata1

  B. rawdata2

  C. `rawdata1'

  D. `rawdata2'

  Correct Answer: D

• Question 66:

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

  data work.passengers;

  if OrigPassengers = then

  OrigPassengers = 100;

  TransPassengers = 100;

  OrigPassengers = .;

  NonPaying = 10;

  TotalPassengers = OrigPassengers + TransPassengers; run;

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

  A. 100

  B. 110

  C. 200

  D. (missing numeric value)

  Correct Answer: B

• Question 67:

  The SAS data set named COMPANY.PRICES is listed below:

  The following SAS program is submitted:

  libname company `SAS-data-library';

  data hware inter soft;

  set company.prices (keep = producttype price);

  if price le 5.00;

  if producttype = `HARDWARE' then output HWARE;

  else if producttype = `NETWORK' then output INTER; else if producttype = `SOFTWARE' then output SOFT; run;

  How many observations does the HWARE data set contain?

  

  A. 0

  B. 2

  C. 4

  D. 6

  Correct Answer: B

• Question 68:

  The following SAS program is submitted:

  data test;

  set sasuser.employees;

  if 2 le years_service le 10 then

  amount = 1000;

  else if years service gt 10 then

  amount = 2000;

  else

  amount = 0;

  amount_per_year = years_service / amount;

  run;

  Which one of the following values does the variable AMOUNT_PER_YEAR contain if an employee has been with the company for one year?

  A. 0

  B. 1000

  C. 2000

  D. (missing numeric value)

  Correct Answer: C

• Question 69:

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

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

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

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

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

  Correct Answer: B

• Question 70:

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

  ----|----10----|----20----|----30

  Daisyyellow

  The following SAS program is submitted:

  data flowers; infile typecolor'; input type $ 1-5 +1 color$; run;

  Which one of the following represents the values of the variables TYPE and COLOR?

  A. type color daisy yellow

  B. type color daisy ellow

  C. type color daisyyellow (missing character value)

  D. No values are stored as the program fails to execute fails to execute due to syntax errors.

  Correct Answer: D