Calculating Prevalence (?)

[simnasameer]

Hi all,

I was trying to put a table together showing adjusted and unadjusted odd's ratio and 95% CI. I also need a column with no. of subjects with disease in a particular category of the independent variable divided by the total number of children in that particular category of the independent variable (as an example see attached table from a study. I am looking at having a column similar to "Prevalence of obesity"). Can anyone please guide me as of how to do this on SPSS or do I get these numbers while I do my logistic regression models by clicking on some option? I do have these numbers separately for the numerator and denominator with me that i have obtained from frequency and cross tabs. But I have far too many variables in my study and dividing each category to get the prevalence manually will take me a lot of time. So just wondering if there was a way SPSS would do this for me?

Thank you in advance for your help. Very well appreciate it.

Regards,

Sim

[hlsmith]

How many variables do you have? Can't you just run descript statistics for the catigorical groups? Are you asking how to get them in your SPSS regression output?

[simnasameer]

Thanks for your reply. Yeah, thats right- in my regression output. I have some 30+ variables of which 25 are categorical having atleast 3 categories each. doing manually descriptives for each variable and then dividing it will cost me a lot of time . Is there a way I can get spss do this for me maybe in my regression output?

Thanks for your help.