regarding register user and active user

[Ishwarkumar]

i'm having a data. And that data, there are details about  registered users. And i want to know, how many active users are there among the registered users.

[PaulHomes]

If you are after information about SAS platform user activity, to see active users and last login date, then I would suggest you look at the Metadata Client Activity Report in the SAS Environment Manager Report Center.

See Using the Report Center in the SAS Environment Manager 2.5: User's Guide.

[Kurt_Bremser]

You need to show us some information about the data structure (eg output from proc contents), and which criteria define an active user.

[Ishwarkumar]

I'm having a data which consist of 7000+ registered users. In that data, i want to see only active users(the users who logged in last month).

[PaulHomes]

Is this the same question you asked on Friday? https://communities.sas.com/t5/SAS-Enterprise-Guide/regarding-register-user-and-active-user/td-p/327...   I ask because that thread has a couple of responses on it that may be helpful, so it may be worth closing this thread and continuing the conversation on the existing one.

[Kurt_Bremser]

@PaulHomes i merged the threads, as the question is clearly the same.

How to do it depends on what the user data looks like (how are the dates stored), so the output of proc contents would be helpful.

Or is that data not yet stored as a SAS dataset? Then we'd need some example lines.

To determine a date of one month before today, use

start_date = intnx('month',today(),-1);

or you could simply subtract a given number of days (eg 30) from the today() result.

[Ishwarkumar]

this is the data ( gdt_login_date=29OCT2015:10:17:37.000000) and (gdt_logout_date= 29OCT2015:10:51:22.000000). Here, i have 7000+ observations which consist of registered users. among the registered users, i want only active users (who usually log in). so, here is the scenario. i want to seperate active users from registered users by using log_in date. 

[Kurt_Bremser]

---

@Ishwarkumar wrote:

this is the data ( gdt_login_date=29OCT2015:10:17:37.000000) and (gdt_logout_date= 29OCT2015:10:51:22.000000). Here, i have 7000+ observations which consist of registered users. among the registered users, i want only active users (who usually log in). so, here is the scenario. i want to seperate active users from registered users by using log_in date. 

---

Ok, so you have datetime values.

Then the condition for selecting a user would look like this:

if gdt_login_date > intnx('dtmonth',datetime(),-1);