← Back to exam page

A00-211 – SAS Base Programming for SAS 9

Loading demo links...

Showing 4–6 of 15 questions

Question 4 (Volume B)

The Excel workbook REGIONS.XLSX contains the following four worksheets:

EAST

WEST

NORTH SOUTH

The following program is submitted:

libname MYXLS XLSX ‘c:\ data\ regions.xlsx’;

Which PROC PRINT step correctly displays the NORTH worksheet?

Select an option, then click Submit answer.

  • ○

    proc print data=MYXLS.‘NORTH’e; run;
  • ○

    proc print data=MYXLS.NORTH.XLSX; run;
  • ○

    proc print data=MYXLS.NORTH; run;
  • ○

    proc print data=MYXLS.‘NORTH$’n; run;
Question 5 (Volume A)

The following SAS program is submitted:

data work.total;

set work.salary(keep = department wagerate); by department; if first.department then payroll = 0;

payroll + wagerate; if last.department; run;

The SAS data set named WORKSALARY contains 10 observations for each department, and is currently ordered by DEPARTMENT. Which statement is true?

Select an option, then click Submit answer.

  • ○

    The BY statement in the DATA step causes a syntax error.
  • ○

    The statement payroll + wagerate; in the DATA step causes a syntax error.
  • ○

    The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.
  • ○

    The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORKSALARY data set.
Question 6 (Volume B)

The following SAS program is submitted:

data work.test; First = 'Ipswich, England';

City = substr(First,1,7); City_Country = City!!', '!!'England'; run;

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

Select an option, then click Submit answer.

  • ○

    Ipswich!!
  • ○

    Ipswich, England
  • ○

    Ipswich, 'England'
  • ○

    Ipswic h, England