https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Access-MsAccess-tables/m-p/49786#M733 Explore using the SAS FORMAT statement or you can code your own user-defined format, using SAS PROC FORMAT.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Recommended Google advanced search argument this topic/post:<BR /> <BR /> proc format mult round site:sas.com Mon, 01 Feb 2010 13:24:26 GMT sbb 2010-02-01T13:24:26Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Access-MsAccess-tables/m-p/49785#M732 Hi everyone.<BR /> <BR /> May I please ask how to I address the problem of many decimal places<BR /> so that SAS shows exactly what it is shown in MsAccess without having to use the round command to all the problematic variables? ie 0.56 instead of 0.5599999999 etc.<BR /> <BR /> Below is what I did,<BR /> options validvarname=any;<BR /> libname MsAccess ".....\Data.mdb" scan_textsize=yes use_datetype=yes<BR /> scan_timetype=yes scanmemo=yes dbmax_text=32767 dbgen_name=dbms;<BR /> data AB; set MsAccess.AB run;<BR /> <BR /> Your advice is greatly appreciated. Have a great week. Mon, 01 Feb 2010 09:53:11 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Access-MsAccess-tables/m-p/49785#M732 Miracle 2010-02-01T09:53:11Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Access-MsAccess-tables/m-p/49786#M733 Explore using the SAS FORMAT statement or you can code your own user-defined format, using SAS PROC FORMAT.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Recommended Google advanced search argument this topic/post:<BR /> <BR /> proc format mult round site:sas.com Mon, 01 Feb 2010 13:24:26 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Access-MsAccess-tables/m-p/49786#M733 sbb 2010-02-01T13:24:26Z