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 data at WORK DEMO:

Which SAS program prints only the first 5 males in this order from the data set?

Aproc sort data=WORK.DEMO out=out;
by sex;
run;
proc print data= out (obs=5);
run;

Bproc print data=WORK.DEMO(obs=5);
where Sex='M';
run;

Cproc print data=WORK.DEMO(where=(sex='M'));
where obs<=5;
run;

Dproc sort data=WORK.DEMO out=out;
by sex descending;
run;
proc print data= out (obs=5);
run;

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

7 months ago

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

upvoted 0 times

...

Alishia

8 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

6 months ago

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

upvoted 0 times

...

Tamie

6 months ago

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

upvoted 0 times

...

Margurite

6 months ago

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

upvoted 0 times

...

An

8 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

8 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

7 months ago

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

upvoted 0 times

...

Kenda

7 months ago

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

upvoted 0 times

...

Rosendo

7 months ago

I think Option B is the correct one.

upvoted 0 times

...

Ethan

7 months ago

Option A looks good to me.

upvoted 0 times

...

Kami

8 months ago

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

upvoted 0 times

...

Beatriz

8 months ago

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

upvoted 0 times

...

Reita

8 months ago

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

upvoted 0 times

...

Beatriz

9 months ago

I think the correct answer is B.

upvoted 0 times

...