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.
04-11-2017 10:50 AM
Thank you for your comments. I want to consider 8s as missing when they are in all variables. For example, if v1=v2=v3=8, then
Need further help from the community? Please ask a new question.