Missing the last few column names when exporting to CSV file

Question

I am trying to export a dataset in my Library/Work. It shows normal in SAS. However when I export the data as CSV or txt file (either from right click -> export, or use SAS code), the last few column names were missing (showing empty in CSV), while the values were kept. The column names missing are all in the format of "Log_xxx" but some the same-format columns were exported correctly. There're around 4000+ columns in my dataset.

The code I've tried is like:

proc export data=logdata
    outfile="path.csv"
    dbms=csv
    replace;
run;

I've exported many datasets before, but it's the first time I have this kind of problem. I've tried to restart SAS and it's still not working.

I simply wanted to export the whole dataset completely with all column names and values.

Do you have any ideas?

Answer 1

I don't think it is PROC EXPORT that is the issue. You have to tell SAS that you want to write lines that are longer then 32,767 bytes (the default setting for the LRECL option).

This code works:

data test;
 array longname [3500] ;
run;

filename csv temp lrecl=1000000 ;
proc export data=test dbms=csv file=csv ; 
run;

So change your code to set the LRECL long enough for all of the variable names.

filename csv "path.csv" lrecl=1000000 ;
proc export data=logdata
    outfile=csv
    dbms=csv
    replace
;
run;