SASInstitute SAS Institute Systems Certification A00-201 Questions & Answers

• Question 11:

  The following SAS program is submitted:

  data work.test;

  Title = `A Tale of Two Cities, Charles J. Dickens'; Word = scan(title,3,' ,`);

  run;

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

  A. T

  B. of

  C. Dickens

  D. ``(missing character value)

  Correct Answer: B

• Question 12:

  The following SAS program is submitted:

  options pageno = 1;

  proc print data = sasuser.houses;

  run;

  proc means data = sasuser.shoes;

  run;

  The report created by the PRINT procedure step generates 5 pages of output.

  What is the page number on the first page of the report generated by the MEANS procedure step?

  A. 1

  B. 2

  C. 5

  D. 6

  Correct Answer: D

• Question 13:

  The following SAS program is submitted:

  data work.one;

  x = 3;

  y = 2;

  z = x ** y;

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

  A. 6

  B. 9

  C. (missing numeric value)

  D. The program tails to execute due to errors.

  Correct Answer: B

• Question 14:

  The following SAS program is submitted:

  libname temp `SAS-data-library';

  data work.new;

  set temp.jobs;

  format newdate mmddyy10.;

  qdate = qtr(newdate);

  ddate = weekday(newdate);

  run;

  proc print data = work.new;

  run;

  The variable NEWDATE contains the SAS date value for April 15, 2000.

  What output is produced if April 15, 2000 falls on a Saturday?

  A. Obs newdate qdate ddate 1 APR152000 2 6

  B. Obs newdate qdate ddate 1 04/15/2000 2 6

  C. Obs newdate qdate ddate 1 APP152000 2 7

  D. Obs newdate qdate ddate 1 04/15/2000 2 7

  Correct Answer: D

• Question 15:

  Which one of the following SAS statements renames two variables?

  A. set work.dept1 work.dept2(rename = Ucode =jobcode) (sal salary));

  B. set work.dept1 workdept2(rename = Ucode =jobcode sal = salary));

  C. set work.dept1 work.dept2(rename =jcode =jobcode sal = salary);

  D. set work.dept1 work.dept2(rename = Ucode jobcode) (sal salary));

  Correct Answer: B

• Question 16:

  The following SAS program is submitted:

  data work.totalsales (keep = monthsales{12});

  set work.monthlysales (keep = year product sales); array monthsales {12} ;

  do i=1 to 12;

  monthsales{i} = sales;

  end;

  run;

  The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.

  Which one of the following is the result of the above program?

  A. The program fails execution due to data errors.

  B. The program fails execution due to syntax errors.

  C. The program executes with warnings and creates the WORK.TOTALSALES data set.

  D. The program executes without errors or warnings and creates the WORKTOTALSALES data set.

  Correct Answer: B

• Question 17:

  The following SAS DATA step is submitted:

  data sasdata.atlanta

  sasdata.boston

  work.portland work.phoenix;

  set company.prdsales;

  if region = `NE' then output boston;

  if region = `SE' then output atlanta;

  if region = `SW' then output phoenix;

  if region = `NW' then output portland;

  run;

  Which one of the following is true regarding the output data sets?

  A. No library references are required.

  B. The data sets listed on all the IF statements require a library reference.

  C. The data sets listed in the last two IF statements require a library reference.

  D. The data sets listed in the first two IF statements require a library reference.

  Correct Answer: D

• Question 18:

  The following SAS program is submitted:

  data work.flights;

  destination = `cph';

  select(destination); when('LHR') city = `London';

  when('CPH') city = `Copenhagen';

  otherwise city = `Other';

  end;

  run;

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

  A. Other

  B. Copenh

  C. Copenhagen

  D. ``(missing character value)

  Correct Answer: A

• Question 19:

  The following SAS program is submitted:

  proc report data = work.houses nowd;

  column style price;

  where price < 100000;

  title;

  run;

  Click the Exhibit button to view the output from the REPORT procedure.

  

  Assume permanent variable labels have been assigned.

  Which one of the following completes the program and produces the output displayed in the exhibit?

  A. define style / display width = 9; define price / sum format = comma9. width = 10;

  B. define style / width = 9; define price / sum format = comma9. width = 10;

  C. define style / group width = 9; define price / sum format = comma9. width = 10;

  D. define style / order width = 9; define price / sum format = comma9. width = 10;

  Correct Answer: D

• Question 20:

  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?

  do I = 1 to 5;

  do weekly{i) = 1 to 5;

  do i = mon tue wed thu fri;

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

  A. do I = 1 to 5;

  B. do weekly{i) = 1 to 5;

  C. do i = mon tue wed thu fri;

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

  Correct Answer: A