DATA Step, Macro, Functions and more

problem facing while importing csv file by using infile

Reply
Contributor
Posts: 20

problem facing while importing csv file by using infile

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.

 

 

gold.PNG

Super User
Posts: 11,343

Re: problem facing while importing csv file by using infile

Posted in reply to ROHINISDAS

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.

Super User
Posts: 7,758

Re: problem facing while importing csv file by using infile

Posted in reply to ROHINISDAS

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

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Trusted Advisor
Posts: 1,553

Re: problem facing while importing csv file by using infile

Posted in reply to KurtBremser

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 ?

Ask a Question
Discussion stats
  • 3 replies
  • 214 views
  • 2 likes
  • 4 in conversation