SASInstitute SAS Institute Systems Certification A00-211 Questions & Answers

• Question 251:

  The following SAS program is submitted:

  

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

  A. The variable MONTHSALES does not exist.

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

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

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

  Correct Answer: B

• Question 252:

  Given the SAS data set EMPLOYEES:

  EMPLOYEES

  NAME SALARY

  Innis 60000

  Jolli 50000

  Ellis 55000

  Liu 45000

  The following SAS program is submitted:

  proc print data = employees; where name like `_i%';

  run;

  What is contained in the output?

  A. Liu only

  B. Innis and Ellis only

  C. Innis, Ellis, and Liu only

  D. Innis, Jolli, Ellis, and Liu

  Correct Answer: A

• Question 253:

  Given the SAS data set ONE:

  ONE Obs Dte

  1 09JAN2005

  2 12JAN2005

  The following SAS program is submitted:

  data two;

  set one;

  day = ;

  format dte date9.;

  run;

  The data set TWO is created:

  TWO

  Obs Dte Day

  1 09JAN2005 1

  12 JAN2005 4

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

  A. day(dte)

  B. weekday(dte)

  C. dayofweek(dte)

  D. datdif(dte,'01jan2005'd,'act/act')

  Correct Answer: B

• Question 254:

  Read the table:

  

  Given the SAS data set SASUSER.HOUSES:

  Obs style bedrooms baths price sqteet street 1 CONDO 2 1.5 80050 1200 MAIN 2 CONDO 3 2.5 79350 1300 ELM 3 CONDO 4 2.5 127150 1400 OAK 4 CONDO 2 2.0 110700 1100 FIFTH 5 TWOSTORY 4 3.0 107250 2100 SECOND 6 TWOSTORY 2 1.0 55650 1600 WEST 7 TWOSTORY 2 1.0 69250 1450 NORTH 6 TWOSTORY 4 2.5 102950 2000 SOUTH

  The following SAS program is submitted:

  proc report data = sasuser.houses nowd headline;

  column style price;

  where price It 100000;

  define price / mean width = 9 format = dollar12.;

  title;

  run;

  The following output is desired:

  style price

  CONDO $79,700 TWOSTORY $62550

  Which DEFINE statement completes the program and produces the desired output?

  A. define style / width = 9,

  B. define style / orderwidth = 9;

  C. define style / group width = 9;

  D. define style / display width = 9;

  Correct Answer: C

• Question 255:

  Given the SAS data set WORKAWARDS:

  WORK.AWARDS FNAME POINTS MONTH

  Amy 2 4 Amy 1 7 Gerard 3 3 Wang 3 3 Wang 1 12 Wang 1 8

  The following SAS program is submitted:

  proc sort data = work.awards; by descending fname points; run;

  How are the observations sorted?

  A. ENAME POINTS MONTH Wang 3 3 Wang 1 12 Wang 1 8 Gerard 3 3 Amy 2 4 Amy 1 7

  B. ENAME POINTS MONTH Amy 2 4 Amy 1 7 Gerard 3 3 Wang 3 3 Wang 1 8 Wang 1 12

  C. ENAME POINTS MONTH Wang 3 3 Wang 1 8 Wang 1 12

  Gerard 3 3

  Amy 2 4

  Amy 1 7

  D. ENAME POINTS MONTH Wang 1 12 Wang 1 8 Wang 3 3 Gerard 3 3 Amy 1 7 Amy 2 4

  Correct Answer: A

• Question 256:

  The following SAS program is submitted:

  footnote1 `Sales Report for Last Month';

  footnote2 `Selected Products Only';

  footnote3 `All Regions';

  footnote4 `All Figures in Thousands of Dollars';

  proc print data = sasuser.shoes;

  footnote2 `All Products';

  run;

  Which footnote(s) is/are displayed in the report?

  A. All Products

  B. Sales Report for Last Month All Products

  C. All Products All Regions All Figures in Thousands of Dollars

  D. Sales Report for Last Month All Products All Regions All Figures in Thousands of Dollars

  Correct Answer: B

• Question 257:

  Given the raw data record DEPT:

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

  Printing 750

  The following SAS program is submitted:

  data bonus;

  infile `dept';

  inputdept$ 1-11 number 13- 15;

  run;

  Which SAS statement completes the program and results in a value of `Printing750' for the DEPARTMENT

  variable?

  A. department = dept II number;

  B. department = left(dept) II number;

  C. department = trim(dept) number;

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

  Correct Answer: D

• Question 258:

  The following SAS program is submitted:

  data one;

  addressl = `214 London Way';

  run;

  data one;

  set one;

  address = tranwrd(address1, `Way', `Drive'); run;

  What are the length and value of the variable ADDRESS?

  A. Length is 14; value is `214 London Dri'.

  B. Length is 14; value is `214 London Way'.

  C. Length is 16; value is `214 London Drive'.

  D. Length is 200; value is `214 London Drive'.

  Correct Answer: D

• Question 259:

  The following SAS program is submitted:

  data work.sets;

  do until (prod gt 6);

  prod + 1;

  end;

  run;

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

  A. 6

  B. 7

  C. 8 D. (missing numeric)

  Correct Answer: B

• Question 260:

  The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:

  WORK.EMPLOYEE WORK.SALARY fname age name salary Bruce 30 Bruce 25000 Dan 40 Bruce 35000 Dan 25000 The following SAS program is submitted: data work.empdata;

  by fname; totsal + salary; run;

  Which one of the following statements completes the merge of the two data sets by the FNAME variable?

  A. merge work.employee work.salary (fname = name);

  B. merge work.employee work.salary (name = fname);

  C. merge work.employee work.salary (rename = (fname = name));

  D. merge work.employee work.salary (rename = (name = fname));

  Correct Answer: D