← Back to exam page

A00-211 – SAS Base Programming for SAS 9

Loading demo links...

Showing 13–15 of 15 questions

Question 13 (Volume A)

The following SAS program is submitted:

libname temp ‘SAS data library’; data temp.sales; merge temp.sales work.receipt; by names; run;

The input data files are sorted by the NAMES variable:

What is the result?

Select an option, then click Submit answer.

  • ○

    The program executes successfully and a temporary SAS data set is created.
  • ○

    The program executes successfully and a permanent SAS data set is created.
  • ○

    The program fails execution because the same SAS data set is referenced for both read and write operations.
  • ○

    The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.
Question 14 (Volume B)

This question will ask you to provide a segment of missing code.

Given the SAS data set WORK.ONE:

The following SAS program is submitted:

The data set WORK.TWO is created, where Day would be the day of the month:

Which expression successfully completed the program and creates the variable Day?

Select an option, then click Submit answer.

  • ○

    day(BeginDate)
  • ○

    weekday(BeginDate)
  • ○

    dayofmonth(BeginDate)
  • ○

    getday(BeginDate)
Question 15 (Volume B)

The following SAS program is submitted:

data work.test; Author = 'Christie, Agatha'; First = substr(scan(author,2,' ,'),1,1); run;

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

Select an option, then click Submit answer.

  • ○

    A
  • ○

    C
  • ○

    Agatha
  • ○

    ' ' (missing character value)