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.
Any ideas?
SAS Enterprise Guide 4.1 (4.1.0.1019)
AIX UNIX
TIA
Jay
Are you using 32-bit or 64-bit version of AIX?
64
I would look into proc template and ods tagsets to create an html document for excel to read.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.