BookmarkSubscribeRSS Feed
Miracle
Barite | Level 11
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.
1 REPLY 1
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 1 reply
  • 676 views
  • 0 likes
  • 2 in conversation