SAS Exam A00-280 Topic 1 Question 61 Discussion

Actual exam question for SAS's A00-280 exam

Question #: 61
Topic #: 1

[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 Lyndia at Jun 29, 2024, 06:52 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Merlyn

3 months ago

Option A all the way! It's the only one that specifically checks for characters outside of the valid set. And hey, who needs 'index' when you've got 'indexc'? It's like the SAS version of a Swiss Army knife.

upvoted 0 times

...

Rodolfo

3 months ago

D is an interesting choice, but 'indexw' sounds like it might be checking for word boundaries, which isn't really what we need here. I'd stick with the more straightforward options.

upvoted 0 times

...

Tayna

3 months ago

Option C is a bit of a wild card. 'find' is not a function I'm familiar with in SAS, so I'm not sure if that's the right approach.

upvoted 0 times

Stephane

2 months ago

Option C is a bit of a wild card. 'find' is not a function I'm familiar with in SAS, so I'm not sure if that's the right approach.

upvoted 0 times

...

Kristel

2 months ago

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

upvoted 0 times

...

Sheridan

2 months ago

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

upvoted 0 times

...

Lashawn

3 months ago

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

upvoted 0 times

...

Mirta

3 months ago

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

upvoted 0 times

...

Fannie

4 months ago

I'm going with Option B. 'index' is a classic way to check for invalid values, and it's easy to understand.

upvoted 0 times

Herminia

3 months ago

Yeah, 'index' is a good choice for this scenario.

upvoted 0 times

...

Izetta

3 months ago

Option B seems like the most straightforward option.

upvoted 0 times

...

Dion

3 months ago

I agree, 'index' is a common way to check for values.

upvoted 0 times

...

Deja

3 months ago

I think Option B is the best choice.

upvoted 0 times

...

Ivette

4 months ago

Option A seems legit, but I'm not sure why we need to use 'indexc' instead of 'index'. Wouldn't that work too?

upvoted 0 times

...

Margart

4 months ago

Haha, I bet the person who wrote this question was having a field day coming up with these SAS functions. Time to break out the SAS manual!

upvoted 0 times

...

Nana

4 months ago

I think option D is definitely incorrect, as indexw() function is used for word searches, not character searches.

upvoted 0 times

...

Lashandra

4 months ago

I'm going with D. The INDEXW function checks if the variable contains the specified word, which seems like the best fit for this problem.

upvoted 0 times

...

Fabiola

4 months ago

I'm not sure, but I think option A could also be correct because indexc() function is used to search for characters in a string.

upvoted 0 times

...

Barney

4 months ago

Option B looks good too, but the INDEX function only checks for the presence of a substring, not the entire string. A more appropriate choice would be A.

upvoted 0 times

Denae

4 months ago

Yes, option B only checks for the presence of a substring, so it may not be the best choice in this case.

upvoted 0 times

...

Denae

4 months ago

I agree, option A is the correct choice because it checks for the entire string 'ABC'.

upvoted 0 times

...

Carma

4 months ago

I agree with Tawna, because index() function is used to search for a substring in a string.

upvoted 0 times

...

Blondell

4 months ago

I think option A is the correct answer. The INDEXC function checks if the variable contains any characters that are not in the specified string, which is exactly what we need here.

upvoted 0 times