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,
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?
ah okay - I've got SAS EG Version 6.1
ah, I'm doing well here aren't I!
9.4
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!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.