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)
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.