@Sassybanana
Just delete the first line with where you set race to missing as that's already going to happen in your else case when Mob_s_Race is missing.
Because race also character IF you want to keep the line then it should be:
if MOB_s_Race = ' ' then race=' ';
And another thing you need to change:
MOB_s_Race can only ever have one value at a time. For this reason you need to use OR instead of AND - else the expression will never become true. You also would need to repeat the variable name for such an expression or use the IN operator instead.
if Mob_s_Race='abc' OR Mob_s_Race='abc' ='xyz' OR.... then...
if Mob_s_Race in ('abc', 'xyz', ....) then...
It's often also useful to UPCASE() the variable because such character comparisons are case sensitive.
if upcase(Mob_s_Race) in ('ABC', 'XYZ', ....) then...
... View more