https://communities.sas.com/t5/SAS-Procedures/Export-to-Excel/m-p/61153#M17351 Hi,<BR /> <BR /> Would like to ask how the export to Excel functionality in SAS Base works? I have a table that contains a numeric field with NLNUM25.2 format and was populated by a DI job. I tried exporting this table to Excel using the Export function in the File menu of SAS Base. When I opened the Excel file, the value was 0.94000000000002328, however, in the dataset it's corresponding value is 0.94. The strange part is, when the query was done in SAS Base using the same condition and format, the output it produced when exported to Excel was 0.939999999999497. <BR /> <BR /> Howcome the two values produced different output in Excel, considering that they have the same formatted value, which is 0.94 in their respective datasets?<BR /> <BR /> Thanks in advance! Tue, 03 May 2011 13:33:28 GMT louise 2011-05-03T13:33:28Z https://communities.sas.com/t5/SAS-Procedures/Export-to-Excel/m-p/61153#M17351 Hi,<BR /> <BR /> Would like to ask how the export to Excel functionality in SAS Base works? I have a table that contains a numeric field with NLNUM25.2 format and was populated by a DI job. I tried exporting this table to Excel using the Export function in the File menu of SAS Base. When I opened the Excel file, the value was 0.94000000000002328, however, in the dataset it's corresponding value is 0.94. The strange part is, when the query was done in SAS Base using the same condition and format, the output it produced when exported to Excel was 0.939999999999497. <BR /> <BR /> Howcome the two values produced different output in Excel, considering that they have the same formatted value, which is 0.94 in their respective datasets?<BR /> <BR /> Thanks in advance! Tue, 03 May 2011 13:33:28 GMT https://communities.sas.com/t5/SAS-Procedures/Export-to-Excel/m-p/61153#M17351 louise 2011-05-03T13:33:28Z https://communities.sas.com/t5/SAS-Procedures/Export-to-Excel/m-p/61154#M17352 The underlying reason is that data are stored in binary and the displayed version is a decimal approximation of the data. SAS can represent integers (within a certain size) exactly, but not decimal numbers. There is a lot of information on what is done in the SAS documentation. Search on <DECIMAL representation="">. One in particular<BR /> <A href="http://support.sas.com/techsup/technote/ts230.html" target="_blank">http://support.sas.com/techsup/technote/ts230.html</A><BR /> might help.<BR /> <BR /> Doc Muhlbaier<BR /> Duke</DECIMAL> Tue, 03 May 2011 14:18:22 GMT https://communities.sas.com/t5/SAS-Procedures/Export-to-Excel/m-p/61154#M17352 Doc_Duke 2011-05-03T14:18:22Z https://communities.sas.com/t5/SAS-Procedures/Export-to-Excel/m-p/61155#M17353 Thank you for this information, Duke! Wed, 04 May 2011 00:40:25 GMT https://communities.sas.com/t5/SAS-Procedures/Export-to-Excel/m-p/61155#M17353 louise 2011-05-04T00:40:25Z