Looking for any SAS samples of code to summarize mainframe performance data on less then 1 hr. intervals. We currently summarize our reporting data to 1 hr., but I now need to summarize in 15min intervals for work on a performance problem. The data contains date(Month/Day/Year) and time(Hr. Min. Sec.) values. Just trying to find an easy way to summarize it. The data come from our ASG Tmon CICS monitor software.
Hope somebody has already invented this wheel.
Thanx,
Jim Glover
Hi Jim
So long as you have a variable with the time in it the below could work for you, 900 being the number of seconds in 15 minutes.
data temp;
format time1 - time3 atime1 - atime3 time8.;
time1 = '00:14:59't;
time2 = '00:15:00't;
time3 = '00:15:01't;
atime1 = int(time1/900)*900;
atime2 = int(time2/900)*900;
atime3 = int(time3/900)*900;
run;
Tim
For adjusting intervals you can use SAS(R) 9.3 Functions and CALL Routines: Reference intnx
Sample for analysing SMF, that is what ASG TMON CICS is delivering, can be found with eg MCG (mxg.com) . That is part of IT service vision.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.