SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Access MsAccess tables

Reply
Regular Contributor
Posts: 204

Access MsAccess tables

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.
Super Contributor
Super Contributor
Posts: 3,174

Re: Access MsAccess tables

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
Post a Question
Discussion Stats
  • 1 reply
  • 112 views
  • 0 likes
  • 2 in conversation