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.