Examice

Exam A00-211 All QuestionsBrowse all questions from this exam

Go to Exam

Question 63

Given the following SAS data set WORK.EMPDATA:

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

where upcase(scan(Job_Title,-1,’ ‘))=’MANAGER’;

where Job_Title like ‘%Manager%’;

where substr(Job_Title, (length(Job_Title)-6))=’Manager’;

where Job_Title=’% Manager ‘;

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

DEAWSOption: B

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