I want to export my sas data to excel.
proc export
data=boardex.ticker
dbms=xlsx
outfile="c:\boardex\ticker.xlsx"
replace;
run;
when I do this, I get an error message saying:
ERROR: XLSX is not yet supported by proc export
If I do replace XLSX with XLS, I get an error when I open the excel file.
Please let me know of your guidance.
Thank you.
This is a tricky one, because there are so many set ups for SAS depending on SAS version (9.1/9.2/9.3), SAS bit (32/64), OS version (Windows XP, 7, 8, Unix), Excel version/bitness. Your best bet is to use the point and click export (File>Export) and save the code in a program, an option in one of the point and click windows.
try
dbms=excel
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.