Hi.

Does anybody know how if there is a way to make PROC IMPORT read
European style numbers directly from a semi-colon delimited text file?

Example:
193503;0,00;60,00
193508;0,00;60,00
193810;100,78;0,00

It imports them as text fields.

This is more out of curiosity rather than necessity, as I'm perfectly
capable of doing a DATA step read for such nicely delimited files,
using a "commax" informat.

Thanks,

Guy

On Mar 17, 9:53=A0am, GuyA <guya.carpen...@gmail.com> wrote:
> Hi.
>
> Does anybody know how if there is a way to make PROC IMPORT read
> European style numbers directly from a semi-colon delimited text file?
>
> Example:
> 193503;0,00;60,00
> 193508;0,00;60,00
> 193810;100,78;0,00
>
> It imports them as text fields.
>
> This is more out of curiosity rather than necessity, as I'm perfectly
> capable of doing a DATA step read for such nicely delimited files,
> using a "commax" informat.
>
> Thanks,
>
> Guy

I would think that LOCALE would have some effect by this experiment
did not yield the desired result.

options LOCALE=3DGerman_Germany;
filename FT15F001 temp;
proc import file=3DFT15F001 out=3Dtest replace dbms=3Dcsv;
   delimiter=3D';';
   parmcards4;
a;b;c
193503;0,00;60,00
193508;0,00;60,00
193810;100,78;0,00
;;;;
   run;
proc print;
   run;