04-10-2017 06:45 PM
Whats the rule? All 8s or all the same value? What if you have two the same value and one is missing.
You can use MIN/MAX logic - if the min=max then the values are the same and you can use CALL MISSING to set variables to missing.
N - returns number of non missing
NMISS - returns the number of missing
MIN - returns minimum value
MAX - returns max value
CALL MISSING() - sets variables designated to as missing - doesn't matter if they're character or numeric.
PS. Post data not in images but at least as text, ideally as a data step. We can't write code based on an image so that would mean typing out your dataset.
Need further help from the community? Please ask a new question.