Proc Export - does not work on server - it works only on local - Why?

dkanand86 — Tue, 22 Mar 2016 22:29:19 GMT

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,

Re: Proc Export - does not work on server - it works only on local - Why?

Reeza — Tue, 22 Mar 2016 22:55:53 GMT

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)