BookmarkSubscribeRSS Feed
mauley
Fluorite | Level 6

Hi Guys & Girls,

 

I am trying to export a data set and then update a sheet in excel with this data.

 

I have exported the data (lets call it My_data) and assigned its location to a library

 

I am using the following code:

 

PROC EXPORT data = library.my_data

dbms= xlsx

outfile= '\\location of excel.xlsx'

sheet = 'data';

QUIT;

 

It runs fine, as I expect it to but always seems to corrupt the excel and so I cant open it?

 

Is this something people have come across before?

 

Many Thanks,

4 REPLIES 4
Tom
Super User Tom
Super User

Note that DBMS=XLSX is different than DBMS=EXCEL.  The later uses Windows provided tools and the former uses only code provided with SAS and so can run on Unix.  It is also newer so what version of SAS are you using?  Perhaps you have an early buggy version of the XLSX engine?

mauley
Fluorite | Level 6

ah okay - I've got SAS EG Version 6.1

Tom
Super User Tom
Super User
Enterprise Guide is just the Windows based software you are using to submit code to SAS. What version of SAS is your EG software connecting to?
mauley
Fluorite | Level 6

ah, I'm doing well here aren't I!

 

9.4

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 4 replies
  • 701 views
  • 1 like
  • 2 in conversation