Stata can compute odds-ratios. It sounds that you want to perform a logistic regression. You need a binary outcome coded 0 or 1. Use the command logit with option or; or use the command logistic.
Careful with what I mean. As I said on my answer you may use the command logit with or option to obtain the odds-ratios:
logit y x1 x2 x3, or
that is equivalent to
logistic y x1 x2 x3
or to
glm y x1 x2 x3, family(binomial) link(logit) eform
I make note that both command are estimating the same regression coefficients in log-odds. To get the odds-ratios we need to e-exponentiate. Stata can e-exponentiate for you by "logistic" or "logit, or" or "glm, eform".
Also note, old versions of Stata would avoid to produce the exponentiated constant coeficient on the logistic command. That is why logit come to hand.
Thank you for instant replies. i have the applied the same command that you recommended. i got results after adjusting age, gender, tobacco consumption but whenever i put alcohol variable in the command , results show some kind of error. is it normal error? what one can conclude with this kind of result?