I am having trouble creating the following variable. I am sure it is quite
easy just escaping me for the past two days.
I have 80k horse races with a finishing position ranging from 1-2 to 1-18.
I have normalized the finishing position using the following:
sort raceid
by raceid: get nfinpos=_N
replace nfinpos=finpos/nfinpos
I would like to have the normalized finishing position rescaled to -.5 to
.5.
I can not find a command that lets me do this and allows by.
any help would be appreciated.
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/