About Holger

Holger · ‎02-10-2023

Thank you very much for your helpful information. I tried to run your code and received the exactly same results. Thus, I know my installation is OK. I trusted the automatic rounding of proc tabulate by defining the output format. Most of the times it works well and delivers the expected results. Now, I know that I should better use the round function before. Best regards Holger

Holger · ‎02-08-2023

Just to add some information regarding my problem:: the wrong rounding does not appear for all numbers but only for single data points - and independ of time the program run and the computer I use for calculation regularly for the same data point while for other data points rounding works perfectly. Best regards Holger

Holger · ‎02-08-2023

Dear all, I am facing a problem with Proc Tabulate. I use 9.4 (TS1M7) on the X64_10PRO platform. In the SAS datatable that goes into Proc Tabulate there is a value of 2.735. With a format being 8.2 the result in the table generated by the procedure is 2.73 instead of 2.74 which would be expected due to correct rounding. The procedure looks like this: proc tabulate data=Mean_and_SD_all; class CAT transy methody Dose; var value; table CAT=''*(transy=''*Dose=''),methody=''*value=''*f=&decimal_val; format transy tr. methody mt.; run; &decimal_val defines a value of 8.2 The rounding error occurs for "value" where format ist defined as 8.2. I already tried to add "options cmplib=work.functions;" without success. Does anybody have an idea how to solve the problem of false rounding? Best regards Holger

Online Status	Offline
Date Last Visited	‎02-28-2024 06:33 AM

Re: Rounding error in Proc Tabulate

Re: Rounding error in Proc Tabulate

Rounding error in Proc Tabulate

Re: Rounding error in Proc Tabulate

Re: Rounding error in Proc Tabulate

Re: Rounding error in Proc Tabulate

Re: Rounding error in Proc Tabulate

Re: Rounding error in Proc Tabulate

Rounding error in Proc Tabulate

SAS Analytics Explorers