topic Re: problem facing while importing csv file by using infile in SAS Programming

problem facing while importing csv file by using infile

ROHINISDAS — Fri, 18 Nov 2016 17:53:10 GMT

please help me out in solving below mentioned error. How can rectify this error. Even i tried ny mentioning RECFM=v and LRECL=256 in the statment.Still didn't work out. Please help out.

Re: problem facing while importing csv file by using infile

ballardw — Fri, 18 Nov 2016 18:14:55 GMT

The only things I can suggest from what you show is to first verify that the file is actually in the folder and then open the file with a text editor such as Notepad and examine the contents.

If there isn't any actual content in the file then that's the problem to fix.

Re: problem facing while importing csv file by using infile

Kurt_Bremser — Fri, 18 Nov 2016 18:16:53 GMT

How does the file look when viewed with a text editor?

Does it have proper (for Windows) line-ending sequences?

Re: problem facing while importing csv file by using infile

Shmuel — Fri, 18 Nov 2016 21:05:52 GMT

Your code contains next line:

infile '...' dlm='09'x dsd firstobs=2;

Are you sure that the delimiter in the file is the tab character ('09'x) ?

Then you have:

input customer $10 month $ type amount;

Do you realy need the dsd option ? Is any variable may be missing having two tabs in sequence ?