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!
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.
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?
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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.