Thanks, I am running SAS 9.2 off a UNIX box, however I am creating input files in windows 7 (Excel) and viewing exported files in the same way. It appears that the problem is actually coming from when I import the data: DATA Work.dataSet; INFILE "myfile.csv"; INPUT Date :MMDDYY10. numVar stringVar :$40.; RUN; myfile csv contains 3 columns a date (mm/dd/yyyy), a number (##.##) and a string (max 40 chars) The import runs fine and viewing the dataset in SAS Explorer works fine. However, if I export the resulting dataset, I find a ^M appended on the end of stringVar. PROC EXPORT DATA = dataSet OUTFILE = "Output.csv" REPLACE; RUN; Each row is something like - 01/02/2006,14.17,ARCHWAY^M Though not all the rows! I have triued dos2unix -ing my input files but to no avail. Any suggestions? Thanks and this results in a new line between each row.
... View more