topic Re: Problem reading Reading text file in SAS Programming

Problem reading Reading text file

AmitKB — Mon, 11 May 2009 23:07:20 GMT

Hi Everyone,
I am trying to read comma delimited text file. The SAS dataset reads a "square sign" in the last column. How do I get rid of it.

infile '/path/data.txt' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;

Thanks,

Amit

Re: Problem reading Reading text file

Doc_Duke — Mon, 11 May 2009 23:51:40 GMT

It's likely the end-of-line character for a record from the PC .csv file that was copied to Unix. Check out this thread:

http://support.sas.com/forums/message.jspa?messageID=20381#20381

If that is not it, tell us more about your platform and the data sources.

Re: Problem reading Reading text file

data_null__ — Tue, 12 May 2009 11:14:28 GMT

You could add the INFILE option TERMSTR with no need to fiddle with the input file(s).

[pre]
infile ..... termstr=crlf;
[/pre]

Re: Problem reading Reading text file

Peter_C — Tue, 12 May 2009 13:05:34 GMT

add '0A'x as delimiter on infile.[pre]infile '/path/data.txt' delimiter= '2c0d'x MISSOVER DSD lrecl= 32767 firstobs= 2 ;[/pre]Then if any '0D'x disappear, the ''0A'x on its own will still act as a line terminator.

PeterC