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.
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.
You need to show us some information about the data structure (eg output from proc contents), and which criteria define an active user.
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).
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.
@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.
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.
@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);
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.