Creating CSV file is dropping CRLF wihile replacing with LF

[ColleenCB]

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

[Kurt_Bremser · Accepted solution]

Use the

termstr=crlf

option for your output file.

[ColleenCB]

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

[Kurt_Bremser]

---

@ColleenCB wrote:

You are a star.

---

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