05-19-2014 02:56 PM
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.
05-21-2014 11:25 AM
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.