You can PROC EXPORT to CSV (DBMS = CSV) if you don't have SAS/ACCESS to PC Files licensed, then open the file in Excel and do a File Save As to save in Excel format.
Thanks a lot it works with CSV
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: