I have multiple categories (Cat1) with many count data rows categorized by sex. I'd like SAS code to sum the count data by sex for each category and test whether there is a significant difference between Male and Female for the sum of counts for each category. The data look like this: Cat1 Sex Count A M 1 A F 0.8 A F 0.7 A M 1 B F 0.9 B F 1 B M 0.8 B M 1 C F 0.9 C M 0.7 C F 1 C M 1 For Cat1 A, is F sum of Counts significantly greater than M sum of Counts? The N for each Sex by Cat1 is over 6 and up to 1200. I've been using a MWU due to non-normal distributions, but it's restricted to one variable and I don't want to run it for each category separately if I don't have to.
... View more