topic Re: Proc import csv in SAS Procedures

Proc import csv

CMilena — Mon, 14 Mar 2011 10:19:23 GMT

Hi,
I have csv file

ex: id money
1 31803,03

I want read in sas db money whit format BEST12.

ex: id money
1 31803.03

but the output is this:

ex: id money
1 3180303000

money format = COMMA1
money informat = COMMA3.

Why sas read the number in this way?
Are there any option to set in proc import step?
Can I change the money format? Message was edited by: CMilena

Re: Proc import csv

sss — Mon, 14 Mar 2011 14:45:33 GMT

hi,

try with Proc import statement and use sheetname='sheetname'$ .

Ex:
Proc import data=' ' outfile=work.xyz replace;
sheetname='sheetname'$
quit;

Re: Proc import csv

Doc_Duke — Mon, 14 Mar 2011 17:11:47 GMT

It looks like you need to be using the COMMAXw.d format. (note the "X" for reversing the role of the comma and decimal in money).

Re: Proc import csv

ballardw — Mon, 14 Mar 2011 22:45:25 GMT

I find that most real CSV data files don't get handled well by the defaults or even available options with PROC IMPORT. I go to the log after running PROC IMPORT and find the generated lines of code, copy and paste into the editor. Then clean up the informats, formats, input statemement and add labels.