topic Re: How to extract Monthly logins from Login date and time from server log? in SAS Data Science https://communities.sas.com/t5/SAS-Data-Science/How-to-extract-Monthly-logins-from-Login-date-and-time-from/m-p/157973#M1674 <HTML><HEAD></HEAD><BODY><P>Create an additional variable that contains the year and month (newvar = put(date,yymmn6.).</P><P>You can then do a proc summary with class userid newvar;</P></BODY></HTML> Fri, 27 Jun 2014 06:29:10 GMT Kurt_Bremser 2014-06-27T06:29:10Z How to extract Monthly logins from Login date and time from server log? https://communities.sas.com/t5/SAS-Data-Science/How-to-extract-Monthly-logins-from-Login-date-and-time-from/m-p/157972#M1673 <HTML><HEAD></HEAD><BODY><P>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 3<SUP>rd</SUP> to 6<SUP>th</SUP> 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?</P></BODY></HTML> Fri, 27 Jun 2014 05:39:13 GMT https://communities.sas.com/t5/SAS-Data-Science/How-to-extract-Monthly-logins-from-Login-date-and-time-from/m-p/157972#M1673 jbstrichy 2014-06-27T05:39:13Z Re: How to extract Monthly logins from Login date and time from server log? https://communities.sas.com/t5/SAS-Data-Science/How-to-extract-Monthly-logins-from-Login-date-and-time-from/m-p/157973#M1674 <HTML><HEAD></HEAD><BODY><P>Create an additional variable that contains the year and month (newvar = put(date,yymmn6.).</P><P>You can then do a proc summary with class userid newvar;</P></BODY></HTML> Fri, 27 Jun 2014 06:29:10 GMT https://communities.sas.com/t5/SAS-Data-Science/How-to-extract-Monthly-logins-from-Login-date-and-time-from/m-p/157973#M1674 Kurt_Bremser 2014-06-27T06:29:10Z