topic informat commaX in SAS Programming

informat commaX

sfmeier — Fri, 01 Jun 2012 12:32:42 GMT

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__ — Fri, 01 Jun 2012 12:53:53 GMT

Get rid of the 2.

sfmeier — Fri, 01 Jun 2012 13:00:08 GMT

I tried that, but it still does not work 😞

data_null__ — Fri, 01 Jun 2012 13:06:01 GMT

You changed the INFORMAT?

input Impairment : CommaX21.0;

sfmeier — Fri, 01 Jun 2012 13:06:30 GMT

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