I think this is a duplicate of this thread: https://communities.sas.com/t5/SAS-Procedures/Problem-with-PROC-EXPORT/td-p/88349 and since I am new to this forum, I don't know how to link my answer directly. So I'll just copy and paste my answer into here. I know this is an old thread, but I just encountered this problem myself, and solved the following way. Actually two ways. 1) Forget about Excel, just export into CSV. (This is what I always did with Python, always easier.) PROC EXPORT DATA=last OUTFILE='/home/data.csv' DBMS=CSV REPLACE; PUTNAMES = YES; RUN; 2) If you insist on Excel, here you go: PROC EXPORT DATA=last OUTFILE='/home/data.xls' DBMS=EXCEL5 REPLACE; RUN; Long story short, EXCEL5 is the key. Hope this helps.
... View more