load csv file with numeric comma

[Nasser_DRMCP]

Hello,

this is what i have in en external csv file. sometimes 2 decimal, 1 or 0

reference;amount  
101;190000,12
102;190000,1
103;190000

I don't succeed to load in a table.

thnaks in advance for your help

regards

Nasser

[PeterClemmensen]

How did you not succeed? What went wrong?

[Tom]

Should work find, if you use the right INFORMAT.

Example:

data want;
  infile cards dsd dlm=';' truncover ;
  input id $ value :commax. ;
cards4;
101;190000,12
102;190000,1
103;190000
;;;;

proc print;
run;

Obs    id       value

 1     101    190000.12
 2     102    190000.10
 3     103    190000.00

[Reeza · Accepted solution]

It looks like your delimiter is actually a semicolon so as long you specify the correct delimiter it should work. Can you post the code you used and we can show you what needs to be changed?