Discuss SAS A00-231 Exam Topic 1 Question 11

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

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

20 comments · newest first

Gail 10 months ago

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

Kristine 10 months ago

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

Mari 10 months ago

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

Arlen 11 months ago

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

Josephine 11 months ago

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

Glendora 11 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.

Latrice 11 months ago

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

Myong 12 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.

Lili 12 months ago

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

Nettie 12 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.

Brittni 1 year 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.

Lyda 1 year 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.

Lenora 1 year 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.

Tamra 1 year 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.

Samira 1 year ago

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

Tonette 1 year ago

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

Stacey 1 year ago

I think this question is quite challenging.

Trinidad 1 year 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!

Peggy 1 year 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.

Soledad 1 year ago

↳ replying to Peggy

I agree, Step 1 seems easy to implement.

SAS A00-231 Exam - Topic 1 Question 11 Discussion