I need to compile the unadjusted odds ratios, L/U bounds, and chi-square results for a large number of binary variables (all either 1 or 0) against the same outcome. I know I can generate these either through univariate logistical regression (one by one) or crosstabs (selecting chi-square and risk) but the default output requires a lot of cut-and-paste to put these into the same table like the format below. Is there a way to run the same tests against a number of variables and specify the output this exact?
Var | chi-sq | sig | UnOR | Lower| Upper
Boston | 39.43 | 0.000 | 0.655 | 0.573 | 0.783
Chicago | 1.359 | 0.230 | 0.859 | 0.720 | 1.087
Smoker | 21.093 | 0.001 | 1.586 | 0.635 | 0.834
Non-smoker | 10.126 | 0.000 | 0.335 | 1.163 | 1.906
Thank you for your help!
(I am new to SPSS so this may be very obvious)