BookmarkSubscribeRSS Feed
venkiparki_gmail_com
Calcite | Level 5

I have successfully connected the excel sheet with the SAS stored process. It runs whenever the file opens and refreshes the data within 30-40 seconds. I am wondering if there is a way to run this stored process without opening the excel file every time. Say I wanted to schedule this to update the sheet every day at 8AM. Can this be done using Windows schedule task?

Also, I am wondering if anyone has experience with Auto_Open macro in VBA. The stored process data feeds this excel macro to create several graphs. These graphs are then printed as PDF and uploaded into a webpage using DMS (CMS) every day. I wanted to automate these completely using:

SAS Stored process --> Excel SAS Add in -->  Auto_Open update macro --> VBA to print PDF --> Web reporting studio to create a static link to place it in the web

I wanted to run the stored process before running the Auto_Open macro, so it uses updated data every day. When I tried to do this, I always ended up with Auto_Open running before stored process while opening the file. I tried wait and all, but nothing seems to be working. I know all the graphs can be done in SAS and it would make the job easier without involving excel in the picture.

If you have any thoughts or ideas, I would love to hear from you.

Thanks!

park

1 REPLY 1
RMP
SAS Employee RMP
SAS Employee

A stored process is simply a SAS program with some accompanying metadata. The SAS program can be executed in a batch process. This process can be then scheduled to run on a daily basis.

HTH.


Richard

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1303 views
  • 0 likes
  • 2 in conversation