topic Re: Creating CSV file is dropping CRLF wihile replacing with LF in SAS Programming

Creating CSV file is dropping CRLF wihile replacing with LF

ColleenCB — Fri, 02 Aug 2019 05:37:06 GMT

Hi everyone,

Thank you for taking the time to read this problem.

We have moved over from using a Windows based computer with SAS Base 9.4 to Unix Enterprise Guide 7.15.

The problem is that the creating of the csv/txt file now loads a LF in place of the CRLF (from windows) at the end of each line.

How do I get the CRLF to remain on the Unix system?

This is the Proc Export that I have used.

PROC EXPORT DATA = work.OLMData
OUTFILE= "/data/fnb/hr_intelligence/mft/Points_Of_Presence_MFT/OLMData_only_July19.txt"
DBMS=csv REPLACE;
delimiter=';';
RUN;

Attached is also the screen print of the problem a client is having when reading the file.

I need the old to stay please

New & old csv files

Thanks for your help in advance

Re: Creating CSV file is dropping CRLF wihile replacing with LF

Kurt_Bremser — Fri, 02 Aug 2019 05:45:06 GMT

Use the

termstr=crlf

option for your output file.

Re: Creating CSV file is dropping CRLF wihile replacing with LF

ColleenCB — Fri, 02 Aug 2019 07:52:13 GMT

Thank you very much Kurt.

I have made the change and the feedback from our client is "working perfectly".

You are a star.

Enjoy your Friday

Re: Creating CSV file is dropping CRLF wihile replacing with LF

Kurt_Bremser — Fri, 02 Aug 2019 08:24:00 GMT

@ColleenCB wrote:

You are a star.

No. Just old (enough to have gained lots of experience) 😁