I have a question about the weighted frequencies between proc surveyfreq and proc surveymeans. I'm sure this seems super simple to you all out there, but I'm stuck. I'm doing an analysis of a categorical variable from a complex survey. Someone has requested the weighted numerator and denominator. The problem is that I don't know which of the methods below is correct, or if I'm fundamentally misunderstanding something about the procedures and the Sum of Weights. 1. Proc SurveyMeans The output for proc surveymeans does not provide weighted frequencies. One recommendation was to use Sum of Weights as the weighted denominator, and the Mean multiplied by the Sum of Weights as the weighted numerator. In the example below (for indicator=1): Weighted numerator = .226788 * 1,060,305 = 240,464 Weighted denominator = 1,060,305 Prevalence = 22.68% However, Proc SurveyFreq is the recommended procedure for categorical variables. 2. Proc SurveyFreq The output for proc surveyfreq provides a Weighted Frequency, which does not match the numerator above (227,043 vs 240,464). In Proc SurveyFreq (indicator=1), it would seem like the weight numerator should be 227,043 and the weighted denominator is1,001,125 (do I include the missings?). But the Sum of Weights is the same as with Proc SurveyMeans. How can the weighted denominator be the Sum of Weights in one and not the other? I've read that both procs handle missing data differently. However, I haven't seen a clear explanation of how those differences impact the interpretation or use of the procedures. Can anyone recommend a good reference that explains the differences (something at the beginner level)? Is that what I'm missing here? Can anyone help me understand what the weighted numerator and denominator should be, and why? Thank you!
... View more