sassas-macro

Exporting SAS dataset to CSV, introducing blank lines in next row, which makes as if record is missing


Exporting a dataset with 530 column and 68531 records but because of one column the whole dataset increases to 123481 records

SAS dataset where one of the column have multiple sentence with empty space and next line, while exporting this as proc export to CSV introduces blank lines in the next row also pushes the next sentence to the next line and so on, Tried ODS but it gets out of memory

enter code here

enter image description here

enter image description here


Solution

  • This may help you solve the issue.

    data shoes;
       set sashelp.shoes;
       array C _CHARACTER_;
       do over c;
          c = compress(c,'0A0D'x,'C');
          end;
       run;