topic Re: regarding register user and active user in SAS Enterprise Guide

regarding register user and active user

Ishwarkumar — Fri, 27 Jan 2017 06:13:45 GMT

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.

Re: regarding register user and active user

PaulHomes — Fri, 27 Jan 2017 07:11:19 GMT

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.

Re: regarding register user and active user

Kurt_Bremser — Fri, 27 Jan 2017 07:43:59 GMT

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

configure out the active users from registered users

Ishwarkumar — Mon, 30 Jan 2017 05:14:19 GMT

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).

Re: configure out the active users from registered users

PaulHomes — Mon, 30 Jan 2017 05:38:22 GMT

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/327934 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.

Re: configure out the active users from registered users

Kurt_Bremser — Mon, 30 Jan 2017 07:28:45 GMT

@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.

Re: configure out the active users from registered users

Ishwarkumar — Mon, 30 Jan 2017 07:43:52 GMT

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.

Re: configure out the active users from registered users

Kurt_Bremser — Mon, 30 Jan 2017 08:06:27 GMT

@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);