Hi everyone, I am trying to export my SAS dataset to csv. However, due to line breaks existing in some values of the SAS Dataset, my csv is messed up. I using the option termstr=CRLF in the proc export command, as it is used in the proc import one. When I import a csv to a SAS dataset, the prementioned option works. However, when I export the SAS dataset to csv, this option does not work. Specifically, the below code is what I am trying to run: filename out "/path/test.csv" termstr=crlf;
proc export data=work.check
outfile=out dbms=csv replace;
delimiter="|";
run; Do you know why the above code does not fix the line breaks and does not specialize the end-of-line? Thank you in advance!
... View more