DATA Step, Macro, Functions and more

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

Reply
Contributor
Posts: 52

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

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,

 

 

Super User
Posts: 19,787

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

Posted in reply to dkanand86

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) 

Ask a Question
Discussion stats
  • 1 reply
  • 481 views
  • 0 likes
  • 2 in conversation