Determine how many sessions user 'JONES' had yesterday:
%LET BY = SYSID USER;
PROC SORT DATA=&VMCX..VMCCMU01 OUT=CMU;
BY &BY; RUN;
DATA _NULL_;
SET CMU END=LAST;
BY &BY;
RETAIN SESSCNT 0;
IF USER = 'JONES' THEN SESSCNT+CMUNRSES;
IF LAST THEN PUT "USER JONES LOGGED ON " SESSCNT " TIMES.";
RUN;
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |