A00-211 Exam QuestionsBrowse all questions from this exam

A00-211 Exam - Question 63


Given the following SAS data set WORK.EMPDATA:

Which WHERE statement would display observations with Job_Title containing the word “Manager”?

Show Answer
Correct Answer: B

To find observations with Job_Title containing the word 'Manager', you should use the SQL 'LIKE' operator with wildcards. The correct syntax for such a query in SAS is 'where Job_Title like '%Manager%';'. This will match any Job_Title that includes 'Manager' anywhere in the string.

Discussion

1 comment
Sign in to comment
DEAWSOption: B
Feb 5, 2024

Correct Answer is B : where Job_Title like ‘%Manager%’;