Help using Base SAS procedures

Calculating Differences from Mean and Median

Reply
New Contributor
Posts: 2

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!

Super User
Super User
Posts: 7,403

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.

New Contributor
Posts: 2

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? 

 

 

 

Super User
Posts: 17,840

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;
Ask a Question
Discussion stats
  • 3 replies
  • 376 views
  • 4 likes
  • 3 in conversation