title: SAS Export dataset as csv or excel preserving line break
body: <p>I am trying to export my dataset from SAS to excel either is csv or xls format however, when I do this the columns with line breaks messes up my excel. Is there a way to export SAS dataset to excel preserving line breaks? I also need to display labels instead of column names and the dataset is fairly large approx. 150,000 rows.</p>
  
  <p>Here is what I did,</p>
  
  <pre><code>proc export data=Final_w_label
  outfile='work/ExtractExcel.csv'
  dbms=csv label replace;
  run; quit;
  </code></pre>
  
  <p>Thank you in advance.</p>