SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

How to run SAS Stored process excel add in without opening excel?

Reply
New Contributor
Posts: 4

How to run SAS Stored process excel add in without opening excel?

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

SAS Employee RMP
SAS Employee
Posts: 52

Re: How to run SAS Stored process excel add in without opening excel?

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

Ask a Question
Discussion stats
  • 1 reply
  • 349 views
  • 0 likes
  • 2 in conversation