READ Free Dumps For SAS Institute- A00-211
| Question ID 20382 | Given the data set WORK.EMPDATA:
Which one of the following where statements would display observations with job titles containing the word 'Manager'? |
| Option A | where substr(Job_Title,(length(Job_Title)-6))='Manager'; |
| Option B | where upcase(scan(Job_Title,-1,' '))='MANAGER'; |
| Option C | where Job_Title='% Manager '; |
| Option D | where Job_Title like '%Manager%'; |
| Correct Answer | D |
| Question ID 20383 | Given the following code:
How many observations will be displayed? |
| Option A | 11 |
| Option B | 15 |
| Option C | 10 or fewer |
| Option D | 11 or fewer |
| Correct Answer | D |
