Desktop productivity for business analysts and programmers

regarding register user and active user

Reply
Occasional Contributor
Posts: 18

regarding register user and active user

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.

PROC Star
Posts: 402

Re: regarding register user and active user

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.

Super User
Posts: 7,371

Re: regarding register user and active user

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 18

configure out the active users from registered users

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

PROC Star
Posts: 402

Re: configure out the active users from registered users

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.

 

 

Super User
Posts: 7,371

Re: configure out the active users from registered users

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 18

Re: configure out the active users from registered users

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. 

Super User
Posts: 7,371

Re: configure out the active users from registered users


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);
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 7 replies
  • 218 views
  • 5 likes
  • 3 in conversation