BookmarkSubscribeRSS Feed
KathrynGreenbrook
Calcite | Level 5

Hi all,

I have a table in Excel that is the result of running an EG job. To update this I'm using a stored process and the AMO. The tricky part - tabs in the same excel file need to be imported as input to the stored process. The Excel file is able to be saved but obviously needs to be open throughout the process.

Any ideas greatly appreciated!

Thanks,

Kathryn

1 REPLY 1
Jacky_NZ
Calcite | Level 5

Have you tried sharing the Excel workbook (On the Review tab, in the Changes group, click Share Workbook)

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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
  • 1 reply
  • 1297 views
  • 0 likes
  • 2 in conversation