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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.