topic Re: Record end delimiter for a unix file in SAS in SAS Programming

Record end delimiter for a unix file in SAS

ashishdubey — Fri, 02 Sep 2016 21:02:17 GMT

Hi All,

Need your help for the following quries regaring delimiter end of record.

my source is unix file , having record delimiter (end of record) as "\r\n\n\n" i.e CRLFLFLF" .

eg record 1

field A1 value

delim "\r\n\n\n".

Is there any limitations in SAS to have only CR or LF or CRLF only as record delimiter (End of record). Please suggest , how to have end of record as "\r\n\n\n"

Thanks,

Re: Record end delimiter for a unix file in SAS

Ksharp — Sat, 03 Sep 2016 02:18:20 GMT

Check options termstr=


data have;
infile 'c:\temp\have.csv'  termstr=crlf ;
..........

Re: Record end delimiter for a unix file in SAS

ashishdubey — Sat, 03 Sep 2016 04:08:26 GMT

Thanks Xia ,

my end delimiter is crlflflf i.e \r\n\n\n .. could you please suggest if your solution will work in this case

Re: Record end delimiter for a unix file in SAS

Ksharp — Sat, 03 Sep 2016 04:33:41 GMT

I think you can use termstr=crlf to import such file.
If not , maybe you need to get rid of those extra \n .