topic Re: Calculating Differences from Mean and Median in SAS Procedures

Calculating Differences from Mean and Median

Cloudrunner — Wed, 08 Jun 2016 15:12:11 GMT

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!

Re: Calculating Differences from Mean and Median

RW9 — Wed, 08 Jun 2016 15:29:03 GMT

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

Cloudrunner — Wed, 08 Jun 2016 16:54:21 GMT

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

Reeza — Wed, 08 Jun 2016 18:10:54 GMT

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;