You should open a new thread rather than extending this one. Do your values include carriage return and line feed characters? Did you set the LRECL for out text large enough for all of the data?  Check the NOTEs for the step that wrote the data and see if it says it wrote more lines to the text file than the number of observations it read from the dataset.  If so then SAS wrapped the lines because you exceeded the line length. ... View more

Commas are probably NOT your problem.  Your text probably has embedded end-of-line characters that are causing Excel to not understand the generated CSV file. Try using the suggested data step with the array eliminate the end of lines (or them to blanks or some other printable character). data whatever;   set whatever;   array charvars _character_;   do _t = 1 to dim(charvars);     charvars[_t] = compress(charvars[_t],'0D0A'x);   end; run; The other possibility is that your records are longer than the LRECL setting that you are using in SAS to write the CSV file so that SAS is inserting extra end of lines.  What method are you using to write the CSV file?  SAS can easily generate a CSV file with a data step, it is writing the row of variable labels that is complicated. data _null_;   set whatever;   file 'myfile.csv' dsd dlm=',' lrecl=1000000;   put (_all_) (:) ; run; ... View more