Hello everyone, I have obtained crude odds ratios and confidence intervals for several variables using prog logistic and ods output. The code for how I obtained these values is below. ods output GlobalTests(persist=proc)=glt(where=(test=:'L')) ParameterEstimates(persist=proc)=est OddsRatios(persist=proc)=odr; proc logistic data=newexcel order=formatted; class response &Covar; format &newformats; model Response(ref='Nonresponder')= &Covar ; run; ods output close; data odr2; set odr; informat oddsratioest 8.2 lowerCL 8.2 uppercl 8.2; format oddsratioest 8.2 lowerCL 8.2 uppercl 8.2; drop _:; run; Next, I would to have the odds ratios (OddsRatioEst) and confidence intervals (LowerCL UpperCL) combined into one cell, with a 8.2 format for each value and have them include parentheses and a comma into a single cell to make easier for placement into a different table. Essentially, take the below: And format it to look like Sex Female vs Male 0.91 (0.61, 1.35) Ideally, 0.91 (0.61, 1.35) would all be house in a single column. Thanks in advanced for any help!
... View more