This is the first few rows of my data 0002 C 00001 IV R1 2 025VS 1111111 1 1 1 0 . C 0002 C 00001 IV R3 2 053VS 1111111 1 1 1 0 . C 0002 C 00001 LG R1 2 5408V 1111111 1 1 1 0 . C 0002 B 00001 UB DS 2 126PD 1111111 1 1 1 0 . C 0002 C 00001 UB DS 2 126PD 1111111 1 1 1 0 . C 0002 B 00001 UB DS 2 465PD 1111111 1 1 1 0 . C 0002 C 00001 UB DS 2 465PD 1111111 1 1 12 0 . C 0002 C 00001 UB DS 2 670PD 1111111 1 1 1 0 . C 0002 B 00001 UB DS 2 678PD 1111111 1 1 1 0 . C 0002 C 00001 UB DS 2 678PD 1111111 1 1 3 0 . C 0002 B 00001 UB DS 2 G5012 1111111 1 1 6 0 . C This is my code for the export proc export data = class.merged_n /*Export merged_n as a csv*/ outfile = 'C:\...\merged_n.csv' dbms = csv replace; run; This is the output, from notepad. Opening in excel it says "File not loaded completely" 0002,C,00001,IV,R1,2,025VS,1111111 1,1,,,,0,,C 0002,C,00001,IV,R3,2,053VS,1111111 1,1,,,,0,,C 0002,C,00001,LG,R1,2,5408V,1111111 1,1,,,,0,,C 0002,B,00001,UB,DS,2,126PD,1111111 1,1,,,,0,,C 0002,C,00001,UB,DS,2,126PD,1111111 1,1,,,,0,,C 0002,B,00001,UB,DS,2,465PD,1111111 1,1,,,,0,,C 0002,C,00001,UB,DS,2,465PD,1111111 1,12,,,,0,,C 0002,C,00001,UB,DS,2,670PD,1111111 1,1,,,,0,,C 0002,B,00001,UB,DS,2,678PD,1111111 1,1,,,,0,,C 0002,C,00001,UB,DS,2,678PD,1111111 1,3,,,,0,,C 0002,B,00001,UB,DS,2,G5012,1111111 1,6,,,,0,,C 0002,C,00001,UB,DS,2,G5012,1111111 1,45,,,,0,,C You can see the unexpected carriage returns. How to remedy this? Thanks in advance
... View more