topic Re: PROC EXPORT DBMS=EXCEL in SAS Programming

PROC EXPORT DBMS=EXCEL

mauley — Thu, 03 Jan 2019 13:41:15 GMT

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,

Re: PROC EXPORT DBMS=EXCEL

Tom — Thu, 03 Jan 2019 14:04:14 GMT

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?

Re: PROC EXPORT DBMS=EXCEL

mauley — Thu, 03 Jan 2019 14:08:24 GMT

ah okay - I've got SAS EG Version 6.1

Re: PROC EXPORT DBMS=EXCEL

Tom — Thu, 03 Jan 2019 14:45:02 GMT

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?

Re: PROC EXPORT DBMS=EXCEL

mauley — Thu, 03 Jan 2019 14:50:46 GMT

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

9.4