Hi , Im piggy-backing on this post: https://communities.sas.com/t5/SAS-Procedures/PROC-TABULATE-Missing-as-Percent-of-Non-Missing/m-p/273345 I have the same problem but if I multiple variables in the same proc tabulate and they have missing observations for different variables. Ideally I would love to have proc tabulate to tweak the "missing" option. I added a variable pay to the dataset and would like to have the output below. Any suggestions how to do it in proc tabulate? Is there a way instead of using proc sql based on the post above? Or i would need to learn proc report? Dataset and desired output below proc format; value $ge 'F' = "Female" 'M' = "Male" other = "Unknown"; value pctfmt low -< 1.0 = [percentn7.1] 1.0 - high = "100.0%"; run; data demos; input @1 grp $1. @3 gender $1. @5 pay $1. ; datalines; A F M A F D A F M A F D A M A M D A D B F M B F D B F D B M B D B M ; run; Desired Output(in the same proc tabulate - not necessary to get the Unknown(missing) row): Gender A B Female 4 66.70% 3 75.00% Male 2 33.30% 1 25.00% Unknown 1 14.29% 2 33.33% TOTAL 7 100.00% 6 100.00% Pay D 4 66.67% 3 60.00% M 2 33.33% 2 40.00% Unknown 1 14.29% 1 16.67% TOTAL 7 100.00% 6 100.00% Thanks 🙂
... View more