When SAS Stored Process last accessed

[LisaSAS]

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

[r_behata]

Which version of SAS are you using ?

Have you explored the SAS Environment Manager.

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

[SASKiwi]

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

[LisaSAS]

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

[Sajid01]

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

[AllanBowe]

You can log events as part of the stpinit program

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