Date:         Tue, 16 Nov 1999 14:23:32 +0100
Reply-To:     peter.crawford@DB.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter.crawford@DB.COM>
Subject:      Q: SAS<-MSACCESS reading in of German currrency format
Comments: To: cschende@ix.urz.uni-heidelberg.de
Content-type: multipart/mixed;
              Boundary="0__=cBXyvkxQgdHDFtSiiH1kiP8rOLNn1IKXWvyrDFj27EwnpC0iOluCCsTv"



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..............