SAS Exam A00-280 Topic 10 Question 54 Discussion

Actual exam question for SAS's A00-280 exam

Question #: 54
Topic #: 10

[All A00-280 Questions]

Given the following SAS program:

Which statement correctly identifies invalid values in the variable TRT, if only the values 'A', B', 'C are valid?

Aif indexc(TRT, 'ABC') eq 0 then output;

Bif index(TRT, 'ABC') eq 0 then output;

Cif find(TRT, 'ABC') eq 0 then output;

Dif indexw(TRT, 'ABC') eq 0 then output;

Show Suggested Answer

Suggested Answer: A

by Helga at Apr 08, 2024, 01:29 PM

Limited Time Offer

25%

Off

Get Premium A00-280 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Glory

5 months ago

I agree with David, I feel confident in selecting B) as the correct response for this question.

upvoted 0 times

...

Antonette

5 months ago

I believe the final answer is B), index is the correct function to use for this keyword search.

upvoted 0 times

...

Jamal

6 months ago

That makes sense, so we can eliminate D) as a possibility.

upvoted 0 times

...

Shizue

6 months ago

I'm not sure, but I think answer D) is incorrect because indexw is used for word searching, not substring.

upvoted 0 times

...

Glory

6 months ago

I agree with because the index function searches for a substring within a larger string.

upvoted 0 times

...

Jamal

7 months ago

I think the correct answer is B)

upvoted 0 times

...

Deonna

8 months ago

Yeah, FIND could work too. But I think INDEXC is a bit more straightforward and easier to read in the code.

upvoted 0 times

...

Lai

8 months ago

Hmm, I'm not so sure. What about FIND? Doesn't that do a similar job to INDEXC?

upvoted 0 times

...

Valentine

8 months ago

You make a good point. I think I agree with Mirta that INDEXC is the way to go here. It's specifically designed for this kind of validation task.

upvoted 0 times

...

Leota

8 months ago

Hold up, wait a minute. Isn't INDEXC different from INDEX? I thought INDEX just checks if the string contains the substring, not whether the entire string is valid.

upvoted 0 times

Cammy

7 months ago

Option B is the correct one. It uses INDEX to check if 'ABC' is present in TRT.

upvoted 0 times

...

Jeff

7 months ago

So, which option would correctly identify invalid values in the variable TRT?

upvoted 0 times

...

Jonelle

7 months ago

Yes, you're correct. INDEXC is used to check if the entire string matches a set of characters. In this case, 'ABC'.

upvoted 0 times

...

Yeah, that's how I understood it too. I think the best way to do that would be to use the INDEXC function, which checks if the string contains any characters that are not in the specified character set.

upvoted 0 times

...

Timothy

8 months ago

Hmm, this question seems pretty straightforward. I'm guessing the valid values for TRT are 'A', 'B', and 'C', and we need to find the invalid ones, right?

upvoted 0 times

...