Yes, I want to keep all observations. If Client A is missing race but has gender, I still want to count their gender. But when I print the table, I don't want a "missing" category to show under race. I agree this might not make sense, but it's what I was asked to create ¯\_(ツ)_/¯ If proc tabulate won't work, I'll try proc sql to restructure the data.
... View more