topic Re: different results of mean after sorting in SAS Programming

different results of mean after sorting

Jedrzej — Mon, 20 Nov 2017 21:22:02 GMT

Hi,

i have set with one numeric variable which gives me different results of mean when sorted.

data b;

format a best20.;

input a;

datalines;

0.187

0.171

0.183

0.08

;

;run;

proc sort data=b; by a;run;

proc summary data=b nway missing noprint mean ;

var a;

output out = out_b mean=mean ;

RUN;

result when sorted =0.15525

result when not sorted = 0.15524999999999

WHY ?!?!

Re: different results of mean after sorting

PaigeMiller — Mon, 20 Nov 2017 21:25:17 GMT

This exact problem has been discussed in great length. Please search today's posts, and you will find the answer.

But why are you posting this anyway, a duplicate of an earlier thread? Is it homework?

Re: different results of mean after sorting

Reeza — Mon, 20 Nov 2017 21:31:03 GMT

https://communities.sas.com/t5/Base-SAS-Programming/proc-summary-calculating-mean/m-p/414821

@Jedrzej wrote:

WHY ?!?!

RTM - there's an entire chapter on this topic and it's not really a SAS issue, it's a 'binary computer issue'.

http://documentation.sas.com/?docsetId=lrcon&docsetTarget=p0ji1unv6thm0dn1gp4t01a1u0g6.htm&docsetVersion=9.4&locale=en

Re: different results of mean after sorting

Jedrzej — Mon, 20 Nov 2017 21:32:16 GMT

my friend asked me today about it and i didn't find soultion for this. I was curious so i posted this question, didn't know he done the same.

sorry,

Re: different results of mean after sorting

Tom — Mon, 20 Nov 2017 22:19:39 GMT

Looking at all possible ways to order those four numbers we see that there are two different means that can result.

data _null_;
  array x (4) (0.187 0.171 0.183 0.08) ;
  do j=1 to fact(dim(x));
    call allperm(j, of x[*]);
    mean=mean(of x(*)) ;
    put j= z2. (x:) (=) mean= best20.18;
  end;
run;

j=01 x1=0.187 x2=0.171 x3=0.183 x4=0.08 mean=0.15524999999999
j=02 x1=0.187 x2=0.171 x3=0.08 x4=0.183 mean=0.15525
j=03 x1=0.187 x2=0.08 x3=0.171 x4=0.183 mean=0.15525
j=04 x1=0.08 x2=0.187 x3=0.171 x4=0.183 mean=0.15525
j=05 x1=0.08 x2=0.187 x3=0.183 x4=0.171 mean=0.15525
j=06 x1=0.187 x2=0.08 x3=0.183 x4=0.171 mean=0.15525
j=07 x1=0.187 x2=0.183 x3=0.08 x4=0.171 mean=0.15525
j=08 x1=0.187 x2=0.183 x3=0.171 x4=0.08 mean=0.15525
j=09 x1=0.183 x2=0.187 x3=0.171 x4=0.08 mean=0.15525
j=10 x1=0.183 x2=0.187 x3=0.08 x4=0.171 mean=0.15525
j=11 x1=0.183 x2=0.08 x3=0.187 x4=0.171 mean=0.15525
j=12 x1=0.08 x2=0.183 x3=0.187 x4=0.171 mean=0.15525
j=13 x1=0.08 x2=0.183 x3=0.171 x4=0.187 mean=0.15525
j=14 x1=0.183 x2=0.08 x3=0.171 x4=0.187 mean=0.15525
j=15 x1=0.183 x2=0.171 x3=0.08 x4=0.187 mean=0.15525
j=16 x1=0.183 x2=0.171 x3=0.187 x4=0.08 mean=0.15524999999999
j=17 x1=0.171 x2=0.183 x3=0.187 x4=0.08 mean=0.15524999999999
j=18 x1=0.171 x2=0.183 x3=0.08 x4=0.187 mean=0.15525
j=19 x1=0.171 x2=0.08 x3=0.183 x4=0.187 mean=0.15525
j=20 x1=0.08 x2=0.171 x3=0.183 x4=0.187 mean=0.15525
j=21 x1=0.08 x2=0.171 x3=0.187 x4=0.183 mean=0.15525
j=22 x1=0.171 x2=0.08 x3=0.187 x4=0.183 mean=0.15525
j=23 x1=0.171 x2=0.187 x3=0.08 x4=0.183 mean=0.15525
j=24 x1=0.171 x2=0.187 x3=0.183 x4=0.08 mean=0.15524999999999