BookmarkSubscribeRSS Feed
dkanand86
Calcite | Level 5

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,

 

 

1 REPLY 1
Reeza
Super User

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) 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 3292 views
  • 0 likes
  • 2 in conversation