Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam A00-211 topic 2 question 145 discussion

Actual exam question from SAS Institute's A00-211
Question #: 145
Topic #: 2
[All A00-211 Questions]

Given the following SAS data set WORK.EMPDATA:



Which WHERE statement would display observations with 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 ‘;
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
DEAWS
5 months ago
Correct Answer is B : where Job_Title like ‘%Manager%’;
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
ex Want to SAVE BIG on Certification Exam Prep?
close
ex Unlock All Exams with ExamTopics Pro 75% Off
  • arrow Choose From 1000+ Exams
  • arrow Access to 10 Exams per Month
  • arrow PDF Format Available
  • arrow Inline Discussions
  • arrow No Captcha/Robot Checks
Limited Time Offer
Ends in