Hello everyone,
We have "client_server" environment and our goal to automate updating multiple excel tabs and specific cells using EG.
When i had standalone license, it was easy to do using X window but since X windows disabled on the production server, I cannot do.
So i tried to use ODS which gives you flexibility (start_at, tab name) but the problem is that it generates new one and overwrites existing file so I cannot update per se.
Does anyone have any idea how it could be resolved?
Thank you!
Try the macro here:
http://www.sascommunity.org/wiki/A_Poor/Rich_SAS_Users_Proc_Export
It's custom written by SAS users on here.
@ak_8 wrote:
Thank you - it does not work, i found this paper
https://communities.sas.com/t5/General-SAS-Programming/Updated-exportxl-macro-now-available/td-p/191...
where it was referenced, tried - no results
What did you try and what does no results mean?
It is designed to work on a server as well.
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 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.