nerdexam
SAS_Institute

A00-211 · Question #251

Given the following SAS data set WORK.EMPDATA: Which WERE statement would display observations wit Job_Title containing the word "Manager"?

The correct answer is D. where Job_Title='% Manager `. See the full explanation below for the reasoning.

Question

Given the following SAS data set WORK.EMPDATA:

Which WERE statement would display observations wit Job_Title containing the word "Manager"?

Exhibit

A00-211 question #251 exhibit

Options

  • Awhere upcase(scan(Job_Title,-1,' `))='MANAGER';
  • Bwhere Job_Title like `Manager%';
  • Cwhere substr(Job_Title, (length(Job_Title)-6))='Manager';
  • Dwhere Job_Title='% Manager `;

How the community answered

(23 responses)
  • A
    13% (3)
  • B
    9% (2)
  • C
    4% (1)
  • D
    74% (17)

Community Discussion

No community discussion yet for this question.

Full A00-211 Practice