PROC EXPORT DBMS=EXCEL

[mauley]

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,

[Tom]

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]

ah okay - I've got SAS EG Version 6.1

[Tom]

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]

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

9.4