topic Re: Proc means range is sum min and max values in New SAS User

Proc means range is sum min and max values

Rogerio_Alves — Wed, 12 Feb 2020 14:33:24 GMT

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!

Re: Proc means range is sum min and max values

ed_sas_member — Wed, 12 Feb 2020 14:36:21 GMT

Hi @Rogerio_Alves

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

Best,

Re: Proc means range is sum min and max values

ballardw — Wed, 12 Feb 2020 15:43:17 GMT

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.

Re: Proc means range is sum min and max values

Rogerio_Alves — Wed, 12 Feb 2020 16:26:55 GMT

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

Thanks a lot to explain.

Appreciate.

Re: Proc means range is sum min and max values

Rogerio_Alves — Wed, 12 Feb 2020 16:27:40 GMT

I got you! Thanks a lot!

Re: Proc means range is sum min and max values

ed_sas_member — Wed, 12 Feb 2020 16:29:25 GMT

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