topic Proc Summary in SAS Procedures

Proc Summary

robertrao — Mon, 14 Jan 2013 17:57:39 GMT

weight

I am doing proc means of the variable above...

Instead of giving 27.5 it gives me 28?????

Could you please help??

Regards

Re: Proc Summary

robertrao — Mon, 14 Jan 2013 18:01:58 GMT

Sorry I did aa Proc Summary with means option for that variable(Weight) and I get 28?????

Re: Proc Summary

AncaTilea — Mon, 14 Jan 2013 18:12:48 GMT

Are you sure you don't have some round-up format somewhere in your options (something like maxdec = 0);

This is what I get...

data a;

input weight;

cards;

;

run;

proc summary data = a print;

var weight;

run;

Analysis Variable : weight

N Mean Std Dev Minimum Maximum

ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

2 27.5000000 6.3639610 23.0000000 32.0000000

ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

Re: Proc Summary

robertrao — Mon, 14 Jan 2013 18:16:34 GMT

Hi,

Interesting. I do not have any formats added.

Regards

Re: Proc Summary

AncaTilea — Mon, 14 Jan 2013 18:22:31 GMT

can you show the code?

Anca.

Re: Proc Summary

robertrao — Mon, 14 Jan 2013 18:26:06 GMT

proc summary data=subset_merge nway;

class Descrip;

var weight;

output out=summary_T(drop=_type_ _freq_) mean(weight)=;

run;

I think it would have to deal with function to get the decimal points

Re: Proc Summary

AncaTilea — Mon, 14 Jan 2013 18:43:58 GMT

When I ran this code, commented out the class statement, because in my made up date I didn't have one,

I get the right output.

proc summary data=a nway;

*class Descrip;

var weight;

output out=summary_T(drop=_type_ _freq_) mean(weight)=;

run;

Are you value maybe rounded up in your data table?

Re: Proc Summary

Reeza — Mon, 14 Jan 2013 18:49:50 GMT

Does the following fix the issue?

Also, run a proc contents on the input (subset_merge) and output data (summary_t) and post it here please if you're still having issues.

proc summary data=subset_merge nway;

class Descrip;

var weight;

output out=summary_T(drop=_type_ _freq_) mean(weight)=;

format weight;

run;

Re: Proc Summary

robertrao — Mon, 14 Jan 2013 19:32:56 GMT

Hi,

Thanks for the follow up. I got it.

Actually to the original value a format was added and i could see only the interger values.

Sorry about thaT

Regards