I want to export a SAS dataset from UNIX server to LAN as an Excel file but I want the Excel workbook to be created if it doesn't already exist.
The first export works and the ".xls" file is created when it doesn't exist.
However, I am concerned that the dataset might exceed the ~ 65000 rows in a ".xls" file so I would prefer to be able to export the data as ".xlsx".
The second export does not work when I try to export as ".xlsx" file unless I manually create a blank workbook called "Want.xlsx" before running the export.
I am working in SAS Enterprise Guide 6.1. Any help would be greatly appreciated. Thanks in advance.
PROC EXPORT DATA= work.HAVE
OUTFILE= "\\LAN\WANT.xls"
DBMS= EXCELCS REPLACE;
SERVER=SERVERNAME; PORT=0001;
SERVERUSER="USRDOM\&USER"; SERVERPASS="&PW";
SHEET= "OUTPUT";
RUN;
PROC EXPORT DATA= work.HAVE
OUTFILE= "\\LAN\WANT.xlsx"
DBMS= EXCELCS REPLACE;
SERVER=SERVERNAME; PORT=0001;
SERVERUSER="USRDOM\&USER"; SERVERPASS="&PW";
SHEET= "OUTPUT";
RUN;
Try DBMS=EXCEL or DBMX=XLSX instead of DBMS=EXCELCS. EXCELCS expects to write to XLS not XLSX.
Since your EG is a couple of versions behind your server may be as well. I don't remember exactly when XLSX became available so not sure which should work.
Try DBMS=EXCEL or DBMX=XLSX instead of DBMS=EXCELCS. EXCELCS expects to write to XLS not XLSX.
Since your EG is a couple of versions behind your server may be as well. I don't remember exactly when XLSX became available so not sure which should work.
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.