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.
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
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.