informat commaX

[sfmeier]

Hello,

I am using a data step to import data from a csv file via the following code

---------------------------------------------------------------------------------------------------------

data lls_dat.p_impairment&einlesemonat;

      infile 'Impairments.csv' dsd dlm=';' firstobs=3;

      input Impairment :     CommaX21.2;

      format Impairment CommaX21.2;

run;

---------------------------------------------------------------------------------------------------------

The csv-File contains multiple values in the format 12.123.123, that shoud be importet as 12.123.123,00.

However they are imported as 121.231,23!?

What did I do wrong?

thx, Stefan

[data_null__ · Accepted solution]

Get rid of the 2.

[sfmeier]

I tried that, but it still does not work 😞

[data_null__]

You changed the INFORMAT?

input Impairment :     CommaX21.0;

[sfmeier]

hmm, I think it does work after all, thanks 😉