Date:         Sun, 31 Jan 2010 23:39:11 -0800
Reply-To:     Ching <kcwong5@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ching <kcwong5@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Access MsAccess data
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

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?

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;

Many thx in advance!! Have a great week.