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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.