Proc means range is sum min and max values

[Rogerio_Alves]

Hi everybody,

I'm using the PROC MEANS in order to get the MIN, MAX, RANGE and MEAN of a group of values. The MIN, MAX and MEAN returns well but for RANGE was returned the SUM of MIN and MAX values.

This is my code:

proc means data=TBL min max mean range maxdec=0 ;
class ano local categoria;
var valor;
run;

The result I've got:

The SAS Guide information:

Tks to help!

[ed_sas_member]

Hi @Rogerio_Alves 

The range is actually the difference between max and min so 64831 - (-20413) = 85244

Best,

[Rogerio_Alves]

Hi, I got you! You'r right, I was with a wrong concept about RANGE could be.

Thanks a lot to explain.

Appreciate.

[ed_sas_member]

You're welcome @Rogerio_Alves !
Could you please mark the topic as answered?
Thanks

[ballardw]

Given what you have shown us, what did you expect the range to be?

Also note that the sum of 64831 and -20413 is 44418.

[Rogerio_Alves]

I got you! Thanks a lot!