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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.