09-09-2011 01:25 PM
We have a bunch of EG SAS jobs that write out *.csv files, no problem there.
We are now looking to write the output into an existing blank (template) *.xls sheets.
The xls sheet has a lot of formula's within it, we can not seem to write the data into a cell and retain the formula.
SAS Enterprise Guide 4.1 (184.108.40.2069)
09-09-2011 08:26 PM
I would look into proc template and ods tagsets to create an html document for excel to read.