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]

The following SAS program is submitted:

proc sort data=SASUSER.VISIT out=PSORT;

by code descending date cost;

run;

Which statement is true regarding the submitted program?

AThe descending option applies to the variable CODE.

BThe variable CODE is sorted by ascending order.

CThe PSORT data set is stored in the SASUSER library.

DThe descending option applies to the DATE and COST variables.

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

11 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

11 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

11 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

10 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

10 months ago

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

upvoted 0 times

...

Sheridan

10 months ago

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

upvoted 0 times

...

Lashawn

10 months ago

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

upvoted 0 times

...

Mirta

10 months ago

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

upvoted 0 times

...

Fannie

11 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

10 months ago

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

upvoted 0 times

...

Izetta

10 months ago

Option B seems like the most straightforward option.

upvoted 0 times

...

Dion

11 months ago

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

upvoted 0 times

...

Deja

11 months ago

I think Option B is the best choice.

upvoted 0 times

...

Ivette

12 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

12 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

12 months ago

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

upvoted 0 times

...

Lashandra

12 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

12 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

12 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

11 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

11 months ago

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

upvoted 0 times

...

Carma

12 months ago

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

upvoted 0 times

...

Blondell

12 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