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?