https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Trouble-Exporting-to-Access-2002/m-p/44913#M695 Dear all<BR /> <BR /> I am having trouble to correctly export my data from SAS 9.1.3 to Access 2002 SP 3 under Windows XP. A strange rounding error appears throughout my whole dataset: every time a negative round number should be exported (like a "-1.000000" in the SAS-table) it somehow gets rounded down in Access to "-0.999999" is there a reason for that? Can anyone explain why this happens, and does anyone have an idea how this can be fixed?<BR /> <BR /> The variable in sas has the format "8.", and I'm exporting with following statement:<BR /> <BR /> PROC EXPORT DATA= output_sas_table<BR /> OUTTABLE= "output_table"<BR /> DBMS=ACCESS REPLACE;<BR /> DATABASE="c:\path\to\some\access_file.mdb"; <BR /> <BR /> Thanks in advance.<BR /> <BR /> Regards Wed, 07 Jul 2010 08:29:25 GMT deleted_user 2010-07-07T08:29:25Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Trouble-Exporting-to-Access-2002/m-p/44913#M695 Dear all<BR /> <BR /> I am having trouble to correctly export my data from SAS 9.1.3 to Access 2002 SP 3 under Windows XP. A strange rounding error appears throughout my whole dataset: every time a negative round number should be exported (like a "-1.000000" in the SAS-table) it somehow gets rounded down in Access to "-0.999999" is there a reason for that? Can anyone explain why this happens, and does anyone have an idea how this can be fixed?<BR /> <BR /> The variable in sas has the format "8.", and I'm exporting with following statement:<BR /> <BR /> PROC EXPORT DATA= output_sas_table<BR /> OUTTABLE= "output_table"<BR /> DBMS=ACCESS REPLACE;<BR /> DATABASE="c:\path\to\some\access_file.mdb"; <BR /> <BR /> Thanks in advance.<BR /> <BR /> Regards Wed, 07 Jul 2010 08:29:25 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Trouble-Exporting-to-Access-2002/m-p/44913#M695 deleted_user 2010-07-07T08:29:25Z