06-27-2014 01:39 AM
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?
06-27-2014 02:29 AM
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;