The SAS Output Delivery System and reporting techniques

How to summarize Login data ?

Reply
N/A
Posts: 1

How to summarize Login data ?

Hi,

I have login data obtained from an application's log that gives me the following details.

user_name, process_id, login_time & logout_time and both login and logout time are in date time formats.

I want to count number of processes running per hour -

Eg.
Range                                                                  Users      Processes

01SEP2013 12:00:00 - 01SEP2013 01:00:00          5               35

There may be cases of overlap here because one process can run upto several hours likewise one user can be working on a process for several hours. I want to find out how many users together run how many processes. Any ideas ? Please help.

Ask a Question
Discussion stats
  • 0 replies
  • 283 views
  • 0 likes
  • 1 in conversation