"Just in case, it says here you want to select cases:
- That have consecutiveattendance 1 or 0, and are not in schooltype HS, and are in school district santa ana."
Yes, that is exactly the data set that I'm looking for. Is the syntax correctly written for that, or am I perhaps missing parentheses around certain operands?
"for instance, possibly "Santa Ana USD" is sometimes written as " Santa Anna USD".
without seeing your data and knowing what you want to select, it is impossible to say where the mistake is exactly. "
I've checked to see that the spelling is consistent in the file for the string variables. As for the numeric variables, they are all consistent with values of either 1,0, or "". To check the ns in excel, i filtered by each of the fields included in the analyses (not including any blanks, because, like you mentioned, it is listwise and will exclude blanks) and ended up with an n value higher than the ns being produced in SPSS. I unfortunately can not share the original raw data file with you, due to confidentiality agreements with the districts we serve. Any other ideas that I can try? Thank you for your time.