04-10-2015 02:20 PM
My previous post tells me I clearly did not have an accurate picture of my data. Earlier, I had said I wanted to count the number of ssn in the data. My objective was to determine the number of absences for each teacher. My approach was short-sighted. Consider "Smith." It appears he was absent 4 days but this is not so. Smith works at two different schools (Park and West) so each school reported the absence for Jan 22 and 23. He was only absent 2 days. I need the count of each teacher's ssn BY school.