topic How do I round off in proc tabulate? in SAS Programming

How do I round off in proc tabulate?

Chrosen — Sun, 08 Jun 2014 08:20:55 GMT

I am using proc tabulate to generate a table containing mean and standard deviation for some variables. It returns a table where the values are given with two significant figures. Is there any way I can round off these values to the nearest whole number instead?

Code used:

proc tabulate data=sved.rank4 missing order=formatted;

where MMSEny ne .;

class diagnosid overall;

var diagnosage MMSEny ab42ny ttauny ptauny;

tables diagnosage MMSEny ab42ny ttauny ptauny,

diagnosid=''*(mean stddev)

overall=''*(mean stddev);

format diagnosid diagnosid_. overall overall_.;

run

;

/Christoffer

Re: How do I round off in proc tabulate?

Ksharp — Sun, 08 Jun 2014 10:55:49 GMT

proc tabulate data=sved.rank4 missing order=formatted;

where MMSEny ne .;

class diagnosid overall;

var diagnosage MMSEny ab42ny ttauny ptauny;

tables diagnosage MMSEny ab42ny ttauny ptauny,

diagnosid=''*(mean*f=best8.0 stddev)

overall=''*(mean stddev);

format diagnosid diagnosid_. overall overall_.;

run

Re: How do I round off in proc tabulate?

jakarman — Sun, 08 Jun 2014 13:22:10 GMT

The best format will show as most possible digits.

Do you want to round off at your wishes use a proper format for that according your wish

Re: How do I round off in proc tabulate?

ballardw — Mon, 09 Jun 2014 15:27:42 GMT

You don't mention the range of values so I'm guessing as to how large to make the format. If you need more digits increase the 6 to the number needed, up to 32 any way.

diagnosid=''*(mean*f=f6.0 stddev*f=f6.0)

overall=''*(mean*f=f6.0 stddev*f=f6.0);