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

12 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

12 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

12 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

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

...

Kristel

11 months ago

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

upvoted 0 times

...

Sheridan

11 months ago

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

upvoted 0 times

...

Lashawn

11 months ago

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

upvoted 0 times

...

Mirta

11 months ago

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

upvoted 0 times

...

Fannie

12 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

11 months ago

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

upvoted 0 times

...

Izetta

11 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

12 months ago

I think Option B is the best choice.

upvoted 0 times

...

Ivette

1 years 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

1 years 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

1 years ago

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

upvoted 0 times

...

Lashandra

1 years 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

1 years 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

1 years 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

1 years 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

1 years ago

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

upvoted 0 times

...

Carma

1 years ago

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

upvoted 0 times

...

Blondell

1 years 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