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.
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 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.