topic When SAS Stored Process last accessed in Administration and Deployment

When SAS Stored Process last accessed

LisaSAS — Tue, 18 May 2021 20:09:47 GMT

How can I create a list of our current SAS Stored Process that will indicate when each were last accessed and all the tables that are being used for each of the stored processes?

I can get a listing of the stored processes that list name, description, location, creation and modified date, but I need to know when last accessed. We are wanting to do some cleanup, but not sure which ones to keep and which are no longer in use. Here's a sample of what I'm looking for...

Name	Description	Location	Created	Modified	Last Accessed	Tables Used
SP 01	Description 1	/location of Stored Procedure	MM/DD/YYYY	MM/DD/YYYY	MM/DD/YYYY	Table 01
						Table 02
						Table 03

SP 02	Description 2	/location of Stored Procedure	MM/DD/YYYY	MM/DD/YYYY	MM/DD/YYYY	Table 01
						Table 02
						Table 04

Re: When Stored Procedures last accessed

r_behata — Tue, 18 May 2021 20:04:45 GMT

Which version of SAS are you using ?

Have you explored the SAS Environment Manager.

https://support.sas.com/resources/papers/proceedings15/SAS1520-2015.pdf

Re: When Stored Procedures last accessed

SASKiwi — Tue, 18 May 2021 20:07:15 GMT

Are you referring to SAS Stored Processes? Stored Procedures are a relational database feature for advanced SQL processing.

Re: When Stored Procedures last accessed

LisaSAS — Tue, 18 May 2021 20:53:30 GMT

SAS Stored Process - I went ahead and changed the original post. Sorry, SQL on my mind.

Re: When Stored Procedures last accessed

Sajid01 — Fri, 21 May 2021 02:48:53 GMT

There are multiple approaches to handle this issue

1. It is possible to run a code before the stored process, Using this feature write a code that updates a sas dataset with STP name and date and time of execution.

2.Use the stored process log. Write a shell script to extract the date and time of execution of the stored process

Re: When SAS Stored Process last accessed

AllanBowe — Fri, 04 Jun 2021 08:09:34 GMT

You can log events as part of the stpinit program

More info: https://rawsas.com/event-logging-of-stored-process-server-sessions/