## Calculating Differences from Mean and Median

I am working on an assignment that asks to calculate:

1: The difference from the Mean (for each variable) as a raw difference and a percent difference

2: The difference from the Median (for each variable) as a raw difference and a percent difference

I know I should start with calculating the mean/median for each variable, but is there a formula to calculate the difference and percent difference?

Thanks!

3 REPLIES 3

## Re: Calculating Differences from Mean and Median

Hi,

Probably the easiest method is:

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000146729.htm

You can then merge the mean back onto your data, and subtract the value from the calculated mean to get offset.

## Re: Calculating Differences from Mean and Median

Thanks for the reply. Could I also create a new dataset with the mean, and create new variables for the raw difference and percent difference using if/then statements to specify them?

## Re: Calculating Differences from Mean and Median

Why do you need if/then statements?

Here's code to get you started. You can calculate the percent difference and other statistics from here.

``````proc means data=sashelp.class;
var weight;
output out=summary_stats mean=weight_avg median=weight_median;
run;

data want;
set sashelp.class;

if _n_ = 1 then set summary_stats (keep = weight:);

diff_mean = weight - weight_avg;
diff_median = weight - weight_median;

run;

proc print data=want;
run;``````
Discussion stats
• 3 replies
• 3032 views
• 4 likes
• 3 in conversation