try the program with the length statement changed. It is intended for defining the storage length within SAS data sets and you have provided external length $11, for that numeric variable -- instead try length Kategori $ 15 Artname $ 30 Aumsatz 8 ;

If that doesn't work, try extending the dlm= parameter with a blank, to x'0920' That treats the dm suffix as a separate column to be read or ignored. However you can only use blank as a delimiter if the text strings like artname are quoted as the transfer (dsd automatically removes " )

Failing that, you need to read it as char and convert the value with a function combination like aums = input( scan( Aumsatz,1, 'D' ), ?? commax11. ) ;

My favourite solution in this situation, is to DDE from SAS to a new query in ms-access which uses no numeric format on the data

Whatever suits your situation Good luck

Datum: 16.11.99 12:35 An: SAS-L@listserv.uga.edu

Antwort an: cschende@ix.urz.uni-heidelberg.de

Betreff: Q: SAS<-MSACCESS reading in of German currrency format Nachrichtentext:

hi there, in this moment I am trying to check out the possibilities of DDE. it's quite nice, however, I cannot read in a certain German currency format, e.g.

"14.393,73 DM". I tried several in/formats, e.g. COMMAX, but did not get SAS to read in the third colum with/out the "DM". How could I solve this? Is this DDEspecific ? Best, Chris

options nodate ls=80 pageno=1; data TEST2; length Kategori $ 15 Artname $ 30 Aumsatz $ 11; infile 'msaccess|Nordwind;query Umsätze nach Artikeln für 1995!data' device=dde missover truncover dlm='09'x notab dsd; input Kategori :$char15. Artname :$char30. Aumsatz :commax10.2 ; run;

the table "Umsätze nach Artikeln für 1995" looks like this: Kategori Artname Aumsatz Fleischprodukte Alice Mutton 14.393,73 DM Fleischprodukte Mishi Kobe Niku 6.935,50 DM Fleischprodukte Pâté chinois 9.056,88 DM..............