I have 3 variables that I want to construct an aggregate variable with:
racfew
rachaf
racmost

I have (.i) for some (missing values)

The new variable I want to construct is Racpeers= racfew + rachaf + racmost

How can I have Racpeers = .i (missing) only if all three variables (racfew, rachaf and racmost) are .i? If say one or two of the three is missing I want to assign .i= 0.

In other words, say I have a value of 2 for rachaf and .i for both racfew and racmost, I want Racpeers = 2.

But if I have racfew, rachaf and racmost = .i , I want to have Racpeers = .i or drop the observation for that variable.

How can this be done?