Thanks for the alternative idea. My actual data is much messier than my example, both sex and injury type had random missing values and they are in text format too. I wonder how to handle it if I also have missing value in Sex and Intury_Type, for example the data have look like this: data have; input ID Sex Injury_Type; datalines; 1 1 . 1 2 . 1 2 2 1 . 3 ; run; It's a learning experience to me, I appreciate your ideas. Thanks, Su
... View more