Discuss SAS A00-231 Exam Topic 1 Question 18

SIMULATION

Scenario:

Open the existing program, program48.sasfrom folder cert\errors. At any time, you may save your corrected program asprogram48incert\programs. This program is intended to:

O Create 3 groups for C var: A-G is Group=1; H-N is Group=2; O-Z is Group=3.

O All variations of the variable should be in the same group, i.e. "A" and "a" should be in Group=1.

O Calculate the average of X and Y by Group. There are multiple errors in the program. These may be syntax errors, logic errors, or problems with the program structure. Logic errors might not produce messages in the log, but will cause the program to produce results different than intended. Correct the errors, run the program, and then use the results to answer the next 2 questions. What is the average (mean) of X for Group=2? Enter your answer to the nearest whole number. Enter your numeric answer in the space below:

A47

Suggested Answer: A

Get Premium A00-231 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

15 comments · newest first

Billy 3 months ago

Exactly! Just need to fix those syntax issues first.

Ruby 3 months ago

If "H" to "N" is Group=2, we should get a solid average.

Vicki 3 months ago

I agree, but I need to double-check the grouping logic first.

Billy 3 months ago

I think Group=2 average should be around 47. It makes sense with the data.

Ruby 3 months ago

I feel like the logic errors will be the hardest to spot.

Vicki 4 months ago

This question is tricky. I hope I can find all the errors.

Marshall 4 months ago

Are you sure about that average? I thought it would be higher!

Lore 4 months ago

I think the average for Group=2 should be around 47.

Leila 4 months ago

Totally agree, that logic makes sense for grouping!

Mirta 6 months ago

Wait, does "A" and "a" really get grouped together? Seems odd.

Joseph 6 months ago

The groups are based on alphabetical ranges, right?

Temeka 6 months ago

I think the average for Group=2 should be calculated after ensuring the grouping is correct, but I’m a bit unsure about how to check for errors in the log.

Louvenia 7 months ago

I feel like I might have mixed up the logic for calculating averages. I hope I remember to use the correct PROC MEANS options.

Talia 7 months ago

This reminds me of a similar question where we had to categorize data. I think we used a CASE statement for that, but I can't recall the exact syntax.

Tequila 7 months ago

I remember we practiced grouping variables based on ranges, but I’m not sure how to handle the case sensitivity for "A" and "a."

SAS A00-231 Exam - Topic 1 Question 18 Discussion