Macros for SAS Application Developers
No Matches File Reference

Capture session start / finish times and request details. More...

Go to the source code of this file.

Detailed Description

For details, see Requires a base table in the following structure (name can be changed):

proc sql; create table &libds( request_dttm num not null format=datetime. ,status_cd char(4) not null ,_metaperson varchar(100) not null ,_program varchar(500) ,sysuserid varchar(50) ,sysjobid varchar(12) ,_sessionid varchar(50) );

Called via STP init / term events (configurable in SMC) as follows:

mp_stprequests(status_cd=INIT, libds=YOURLIB.DATASET )

[in]status_cd=Use INIT for INIT and TERM for TERM events
[in]libds=(somelib.stp_requests) Location of base table (library.dataset). To minimise risk of table locks, we HIGHLY recommend using a database (NOT a SAS dataset). THE LIBRARY SHOULD BE ASSIGNED ALREADY - eg in autoexec or earlier in the init program proper.
Allan Bowe @source

Definition in file