BookmarkSubscribeRSS Feed
ak_8
Calcite | Level 5

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!

3 REPLIES 3
Reeza
Super User

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
Calcite | Level 5
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
Reeza
Super User

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1101 views
  • 0 likes
  • 2 in conversation