topic Re: load csv file with numeric comma in SAS Programming

load csv file with numeric comma

Nasser_DRMCP — Tue, 17 Mar 2020 17:37:35 GMT

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

Re: load csv file with numeric comma

PeterClemmensen — Tue, 17 Mar 2020 17:38:42 GMT

How did you not succeed? What went wrong?

Re: load csv file with numeric comma

Tom — Tue, 17 Mar 2020 17:42:44 GMT

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

Re: load csv file with numeric comma

Reeza — Tue, 17 Mar 2020 17:44:44 GMT

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?