Hi Everyone,
Please find below my sas code which i am using to export my sas dataset into excel file using proc export.
THIS CODE WORKS (Because i first downloaded the data and then exported to local only):
rsubmit;
proc download data=dd.summary1 out=summary1;
run;
endrsubmit;
proc export data=summary1 dbms=xlsx outfile="C:\Users\USER12\Desktop\test1\sampletest1.xls" replace;
run;
THIS CODE DOES NOT WORK (Why it does not work?):
Without downloading the data to local, if i try to export the data to excel file to server using proc export, it fails. please help. thanks
proc export data=dd.summary1 dbms=xlsx outfile=="/server/user12/sampletest1.xls" replace;
run;
ERROR LOG:
NOTE: Remote submit to SERVER commencing.
914 proc export data=dd.summary2 dbms=xlsx
914! outfile="/server/user12/sampletest1.xls" replace;
ERROR: DBMS type XLSX not valid for export.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
915 /*sheet="new1";*/
916 run;
NOTE: Remote submit to KIRKWOOD complete.
Regards,
Sounds like you may have different licensing.
Run proc setinit or proc product_status to see if the licenses across machines are the same.
Also, try a different DBMS - Excel, ExcelCS, or Xls (for an Xls file)
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.