topic Re: Updating MS Excel tabs and specific cells in SAS Programming

Updating MS Excel tabs and specific cells

ak_8 — Thu, 07 Sep 2017 21:02:00 GMT

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!

Re: Updating MS Excel tabs and specific cells

Reeza — Thu, 07 Sep 2017 21:06:52 GMT

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.

Re: Updating MS Excel tabs and specific cells

ak_8 — Thu, 07 Sep 2017 21:31:26 GMT

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/191357

where it was referenced, tried - no results

Re: Updating MS Excel tabs and specific cells

Reeza — Thu, 07 Sep 2017 22:27:28 GMT

@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/191357

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.