SAS Exam A00-280 Topic 12 Question 63 Discussion

Actual exam question for SAS's A00-280 exam

Question #: 63
Topic #: 12

[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 Benedict at Jul 13, 2024, 09:32 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Anna

5 months ago

Option D with INDEXW? Really? Who even uses that obscure function anymore? Give me a break!

upvoted 0 times

...

Alishia

5 months ago

Haha, Option C with the FIND function? That's so last century, man. We're living in the future of SAS programming!

upvoted 0 times

Stephaine

4 months ago

Yeah, Option A is definitely the modern approach to handling invalid values in SAS.

upvoted 0 times

...

Tamie

4 months ago

I think Option A is the way to go, using the INDEXC function.

upvoted 0 times

...

Margurite

4 months ago

I agree, Option A seems like the most efficient choice for this scenario.

upvoted 0 times

...

An

5 months ago

I think Option B is the way to go. The INDEX function is a standard way to check for the presence of a substring.

upvoted 0 times

...

Lindsey

5 months ago

Option A looks good to me. It checks if the value of TRT is not in the list of valid values 'ABC'.

upvoted 0 times

Desirae

5 months ago

I see your point, but I still think Option B is the correct answer.

upvoted 0 times

...

Kenda

5 months ago

I agree with User1, Option A seems to be the right choice.

upvoted 0 times

...

Rosendo

5 months ago

I think Option B is the correct one.

upvoted 0 times

...

Ethan

5 months ago

Option A looks good to me.

upvoted 0 times

...

Kami

6 months ago

I'm leaning towards D because indexw function searches for whole words.

upvoted 0 times

...

Beatriz

6 months ago

But index function also searches for a substring, so it could be A as well.

upvoted 0 times

...

Reita

6 months ago

I believe it's C because find function is used to search for a substring.

upvoted 0 times

...

Beatriz

6 months ago

I think the correct answer is B.

upvoted 0 times

...