Access MsAccess tables

[Miracle]

Hi everyone.

May I please ask how to I address the problem of many decimal places
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.

Below is what I did,
options validvarname=any;
libname MsAccess ".....\Data.mdb" scan_textsize=yes use_datetype=yes
scan_timetype=yes scanmemo=yes dbmax_text=32767 dbgen_name=dbms;
data AB; set MsAccess.AB run;

Your advice is greatly appreciated. Have a great week.

[sbb]

Explore using the SAS FORMAT statement or you can code your own user-defined format, using SAS PROC FORMAT.

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search argument this topic/post:

proc format mult round site:sas.com