SAS A00-231 Exam - Topic 1 Question 11 Discussion

Actual exam question for SAS's A00-231 exam

Question #: 11
Topic #: 1

SIMULATION

Scenario:

This project will use data setcert.input36. At any time, you may save your program asprogram36 in cert\programs. Write a SAS program that will clean the data incert.input36as follows:

Step 1:

create a temporary data set, cleandata36.

In this data set, convert all case.

Then keep only observations with group equal to 'A' or 'B'.

Step 2:

Determine the MEDIAN value for the Kilograms variable for each group(A,B) in the cleandata36

data set. Round MEDIAN to the nearest whole number.

Step 3:

Create results.output36 from cleandata36

Ensure that all values for variable Kilogramsare between 40 and 200, inclusively.

If the value is missing or out of range, replace the value with the MEDIAN Kilograms value for the respectivegroup(A,B) calculated in step 2

A86.5

Show Suggested Answer

Suggested Answer: A

by Elfrieda at Aug 04, 2025, 09:35 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Gail

2 months ago

I thought we were supposed to keep all observations, not just A and B.

upvoted 0 times

...

Kristine

2 months ago

Wait, are we really replacing missing values with the median? Seems risky!

upvoted 0 times

...

Mari

3 months ago

Just a heads up, the median is a great way to handle outliers!

upvoted 0 times

...

Arlen

3 months ago

Totally agree, but rounding might skew the results a bit.

upvoted 0 times

...

Josephine

3 months ago

Remember to check for any missing values before calculating the median!

upvoted 0 times

...

Glendora

3 months ago

I think I need to use a WHERE statement to filter the groups A and B in the temporary data set. That part seems straightforward.

upvoted 0 times

...

Latrice

4 months ago

I feel a bit uncertain about how to handle missing values. Do I just replace them with the median directly?

upvoted 0 times

...

Myong

4 months ago

This question seems similar to the one we did on calculating medians. I think I need to use PROC MEANS for that part.

upvoted 0 times

...

Lili

4 months ago

I remember we practiced cleaning data sets, but I'm not sure how to convert all case in SAS.

upvoted 0 times

...

Nettie

4 months ago

Alright, let's do this! I'll tackle the data cleaning step-by-step and make sure I hit all the requirements. Shouldn't be too tough if I read through the question carefully.

upvoted 0 times

...

Brittni

4 months ago

This seems doable, but I want to make sure I get the rounding right for the median values. Better double-check the instructions on that.

upvoted 0 times

...

Lyda

5 months ago

No problem, I've done similar data cleaning projects before. I'll focus on keeping only the 'A' and 'B' groups, then replacing any out-of-range or missing Kilograms values with the group medians.

upvoted 0 times

...

Lenora

5 months ago

Hmm, not sure I fully understand the instructions for step 2. I'll need to review how to calculate the median for each group in SAS.

upvoted 0 times

...

Tamra

5 months ago

Okay, this looks like a pretty straightforward data cleaning task. I'll start by creating the temporary cleandata36 dataset and converting all the case as required.

upvoted 0 times

...

Samira

5 months ago

I feel confident about this question. I have practiced similar tasks before.

upvoted 0 times

...

Tonette

5 months ago

I agree, it requires a good understanding of data cleaning and manipulation.

upvoted 0 times

...

Stacey

7 months ago

I think this question is quite challenging.

upvoted 0 times

...

Trinidad

7 months ago

Hmm, I wonder if there's a way to do this all in one step instead of creating a temporary data set. But overall, the steps make sense. I'll give it a try!

upvoted 0 times

...

Peggy

7 months ago

Looks good! Step 1 is straightforward, and Step 2 will help handle any missing or out-of-range values in Step 3. The median calculation is a nice touch.

upvoted 0 times

Soledad

5 months ago

I agree, Step 1 seems easy to implement.

upvoted 0 times

...