SAS_Institute
A00-211 · Question #173
Given the data set WORK.EMPDATA: Which one of the following where statements would display observations with job titles containing the word 'Manager'?
The correct answer is D. where Job_Title like '%Manager%'. See the full explanation below for the reasoning.
Question
Given the data set WORK.EMPDATA:
Which one of the following where statements would display observations with job titles containing the word 'Manager'?
Exhibit
Options
- Awhere substr(Job_Title,(length(Job_Title)-6))='Manager';
- Bwhere upcase(scan(Job_Title,-1,' '))='MANAGER';
- Cwhere Job_Title='% Manager ';
- Dwhere Job_Title like '%Manager%';
How the community answered
(23 responses)- A13% (3)
- B4% (1)
- C4% (1)
- D78% (18)
Community Discussion
No community discussion yet for this question.