Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

How to extract Monthly logins from Login date and time from server log?

Reply
N/A
Posts: 1

How to extract Monthly logins from Login date and time from server log?

I have data set consists of login data of teachers and students of a school of a learning management tool. Each record has 4 fields - user id, date of login, time of login and whether the login was successful or not. The record is of a teacher if the user id has “TCHR” as the 3rd to 6th characters. I want to get the login data i.e. teacher/student logins in each month (total monthly logins). Can someone please help me how to get these details in SAS enterprise miner?

Super User
Posts: 6,938

Re: How to extract Monthly logins from Login date and time from server log?

Create an additional variable that contains the year and month (newvar = put(date,yymmn6.).

You can then do a proc summary with class userid newvar;

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 1 reply
  • 348 views
  • 0 likes
  • 2 in conversation