Hello, i am currently trying to score an 80 on the prac exam but SAS has been a bit difficult for me to catch on. Currently, i am reviewing my practice exam answers. I will display my code and the assumed correct code. However, the answers are vague and don't show how I can get the answer. This code also heavily puzzled me initally at first. here is the prompt to create the code initally in the prac exam; Step 1: create a temporary data set, cleandata36. In this data set, convert all group values to upper 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 Kilograms are between 40 and 200, inclusively. If the value is missing or out of range, replace the value with the MEDIAN Kilograms value for the respective group (A,B) calculated in step 2. The question i'm struggling with is "What is the MEAN Kilograms value for group=‘A’ in the results.output36 data set?" and of course the same, but for group B. My code: data cleandata36;
set cert.input36;
Group=Upcase(group);
if Group in ('A', 'B') then output;
run;
proc means data=cleandata36 median maxdec=0;
class Group;
var Kilograms;
run;
data results.output36;
set cleam data36;
if 40 < kilograms < 200 < then do;
if Group = 'A' then kilograms=79;
else Kilograms=89;
end;
run; Suggested correct code: data work.cleandata36;
set cert.input36;
group=upcase(group);
if group in ('A', 'B');
run;
proc means data=work.cleandata36 median;
class group;
var kilograms;
run;
data results.output36;
set cleandata36;
if Kilograms<30 or Kilograms>200 then do;
if group='A' then kilograms=79;
else kilograms=89;
end;
run;
proc contents data=results.output36;
run; The mean that I found that was also indicated in the correct answer was 79 for group A, and 89 for group B. however, the answers given was 76.3 for group A, and 86.5 for group b. I can't find the median in the results nor output data. I'm not sure where to look. I'm assuming it's because of maxdec?...hopefully? if not, why? Please go easy on me with terminology/wording. Iam also actively looking for a tutor if anyone knows one or would like to help because again i am STRUGGLING with learning a lot of these. videos are more difficult than it is with someone that can answer my questions asap because there is so many. thank you haha. lastly if you are also studying for your exam, we got this! please send me a message and hopefully we can help each other. thank you for your time!
... View more