BookmarkSubscribeRSS Feed
cgerdvil
Calcite | Level 5
I'm trying to streamline the process of creating and distributing reports. I want to have code that I wrote in base sas create or update a table in a library. I then want to have a Web Report Studio report that I created based on that table to run and distribute based on a "Completed" status of the sas code.
So, I did all of the prerequisites but I'm stumped.
I have code that builds a table, I deploy the code in the sas management console scheduler. I create a time dependancy for the code to run. I build a WRS report and schedule it to run and distribute at a standard time.
I then add the sas code to the WRS flow in the management console as a predecessor to the WRS job.
But it doesn't work. I can't seem to schedule the sas code to run before the WRS runs and I send out old, stale data. Any help would be appreciated.

Thanks!
1 REPLY 1
AngelaHall
SAS Employee
Could I get some more information from you?

When you state 'I did all the prerequisites', are you referring to a user paper or other documentation? Could you send that URL?

Have you been able to get the scheduler to work on it's own? Meaning, if we take out the WRS step and have the SMC Scheduler just update the table daily, does it work? (Want to rule out a configuration issue there.)

Another technique I have seen for this is to place the table update code in a SAS Stored Process. Add this stored process to the SAS Information Map (that is the source for the WRS report). Then schedule the WRS report in the WRS application itself. The WRS report would then initiate the stored process execution to run before returning the results.

~ Angela Hall
http://sas-bi.blogspot.com

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