Prev: how to retain scores
Next: Compute After - Proc report
From: GuyA on 17 Mar 2010 10:53
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
From: data _null_; on 17 Mar 2010 12:01
On Mar 17, 9:53 am, GuyA <guya.carpen...(a)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=German_Germany;
filename FT15F001 temp;
proc import file=FT15F001 out=test replace dbms=csv;
delimiter=';';
parmcards4;
a;b;c
193503;0,00;60,00
193508;0,00;60,00
193810;100,78;0,00
;;;;
run;
proc print;
run;
 | 
Pages: 1
Prev: how to retain scores
Next: Compute After - Proc report