One possibility would be to take every data set that contains GENDER_DESC and create GENDER. That's relatively simple:
length gender $ 1;
gender = gender_desc;
Then you could use the same process you use now to see if the GENDER values are equal.
There is a weakness to this approach. By copying just the first character into GENDER, you may create the impression that all is OK when it is not. For example:
length gender $ 1;
gender_desc = 'Molly';
gender = gender_desc;
GENDER will be "M" but there is no way to tell that GENDER_DESC is bad without examining in more detail. Those sorts of comparisons are possible but are more complex to set up so the right solution may depend upon your being comfortable with more complex code.
... View more