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. 

sas-innovate-2024.png

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.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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