topic Re: Extracting data from SAS Stored Process Log in Developers

Extracting data from SAS Stored Process Log

Anand — Tue, 05 Nov 2013 15:43:11 GMT

Hi Friends,

I want extract following data from SAS Stored Process Log

1)Date/Time-- User-- Report Ran

Can some body provide any short SAS code which can help me extracting above data from SAS Stored Process Log.

Thanks in Advance

Anand

Re: Extracting data from SAS Stored Process Log

Quentin — Fri, 08 Nov 2013 03:21:36 GMT

Hi,

Parsing from the log is probably possible, but a hassle.

I would try %put _USER_ ; and review the list of macro variables printed in the log.

With stored process web app, you get two or three different versions of user name. I think stored process name is there too. Can't remember if run date/time is there or not. If it isn't, see Peter Crawford's %now macro.

HTH,

--Q.

Re: Extracting data from SAS Stored Process Log

twocanbazza — Wed, 13 Nov 2013 02:56:18 GMT

Also this sort of information is reported from SAS' APM tool - Might be over kill for what you want..