08-06-2014 10:38 AM
Well, there are two or three options. Unfortunately this is a question which comes up a lot - I have xyz in Excel and I want to do something in SAS then have Excel updated. So some options:
- Learn Open Office format - this is what is used to store Excel files behind the scenes - rename the XLSX to ZIP and you can see the folders and files. This is really in depth however.
- Use DDE to send your data out to an existing file - This is old tech and may/may not work in future and isn't straight forward.
- Save your data from SAS as CSV. Then in your Excel file have a vba macro which imports the CSV data and updates your sheet.
As far as I am aware there is no way to create a pivot chart from directly in SAS. The output is for reports only.
08-06-2014 10:45 AM
08-06-2014 11:30 AM
This doesn't create a native excel file, and I think its ugly but its a solution:
Create the excel file manually (once). Update the data via an export. When user opens the workbook they will have to refresh (usually via a pop up), or embed a macro or script in the workbook to automatically open on refresh.
DDE: Combination of export and then refresh using DDE