Date:         Tue, 5 Mar 2002 18:21:10 -0600
Reply-To:     "Smith, Curtis, Mr, DCAA" <Curtis.Smith@DCAA.MIL>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Smith, Curtis, Mr, DCAA" <Curtis.Smith@DCAA.MIL>
Subject:      Reading MS-Access Data Using DDE
Content-Type: multipart/alternative;

Okay, thanks to the generous help from the good folks at SAS-L, I am able to
read data from an MS-Access table into SAS using DDE. I have encountered one
problem. If the dollar amount column contains exactly no cents ".00", then
SAS slips the decimal point to positions to the left. Thus, 400.00 becomes
4.00. I have used the informat 15.2 and the following options on the infile
statement:

dlm = '09'x dsd truncover firstobs = 2 notab



Any suggestions?



*-------------------------------------------*
| Curtis A. Smith                           |
| Defense Contract Audit Agency             |
| Boeing Huntington Beach Resident Office   |
| 5301 Bolsa Avenue, M/C H014-A405          |
| Huntington Beach, CA 92647-2099           |
| Voice:   714-896-3311 x67492              |
| FAX:     714-896-6915                     |
| E-Mail:  curtis.smith@dcaa.mil            |
*-------------------------------------------*



[text/html]