topic Re: Different numeric formats in SAS Data Management

Different numeric formats

Thylacine — Wed, 12 Jul 2017 15:04:01 GMT

I'm importing a csv file with a number which is sometimes without decimals and sometimes with them like( 20 or 5,43) how can i store them in one variable with right values. If i use comma. the number without decimals gets wrong value and so on.

Re: Different numeric formats

Reeza — Wed, 12 Jul 2017 15:08:17 GMT

Use the BEST informat, note that this is the default SAS behaviour as well.

data check;
informat myNum best12.;
format myNum best12.;
input myNum;
cards;
2
4
4.32
2.3
1.0
3
;
run;

proc print;run;

Re: Different numeric formats

art297 — Wed, 12 Jul 2017 15:10:32 GMT

If your example is indicative of what your data really look like, sounds like you should be using the commax informat rather than the comma format. That will let you read numbers like 5,43 as 5.43

Art, CEO, AnalystFinder.com

Combining numeric formats

Thylacine — Wed, 12 Jul 2017 15:22:47 GMT

Re: Combining numeric formats

PaigeMiller — Wed, 12 Jul 2017 15:24:34 GMT

You have a CSV file and sometimes the decimal is also a comma?

Can you show us a portion of the CSV file that illustrates the problem so we can get some idea of what the data looks like?

Re: Combining numeric formats

Reeza — Wed, 12 Jul 2017 15:27:04 GMT

Please note that I've merged these two threads as the topic is identical.