Given the following SAS data set WORK.EMPDATA:
Which WERE statement would display observations wit Job_Title containing the word "Manager"?
A. where upcase(scan(Job_Title,-1,’ ‘))=’MANAGER’;
B. where Job_Title like ‘Manager%’;
C. where substr(Job_Title, (length(Job_Title)-6))=’Manager’;
D. where Job_Title=’% Manager ‘;
where Job_Title like ‘Manager%’;
Ans: B
when we want to get the obs with the end word in a particular variable, we can use where statement with ‘like’ Operator.