I have a large excel report which I try to automate by producing it with SAS and ODS Excel. The report contains several tables with specific formatting which I create successfully.
In addition, there are combo charts which are linked to some of the data and have specific excel formatting for the lines/bars/axis. I am looking for a solution to reproduce these charts from SAS and then write them to excel file. They need to have the same formatting as the original excel file and be referencing to the data which is already written to the excel cells.
I am thinking of two possible solutions:
Any possible solutions, comments and references would be highly appreciated!
Just choose one or the other. If you have to use Excel, then create a template in Excel, create VBA macros to load the data into your template from CSV files. Then all your SAS has to do is drop out the data to CSV. Alternatively use SAS for all of it, produce a report with the various items, excluding Excel functionality. There really is no benefit to try to drive software x from software y.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.