[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: panel data management - dividing into quartiles
I have a panel data set, with data on a number of
companies over a number of years. Each observation is
a particular company and year, and has various data
for that observation.
I would like to divide my data into 4 quartiles or 5
quintiles, on the basis of one of my variables,
assets. So I would like to create a variable, call it
quartile, that has the value 1 if that observation is
in the top quartile of assets for that year, has the
value 2 if that observation is in the second quartile
of assets for that year, etc. (So of course a company
might have different values of "quartile" in different
years, depending on which quartile of assets it fits
into in a particular year. The quartiles will probably
contain somewhat different companies in each year.)
The reason that I want to do this is that I can run
regressions separately for each quartile.
I was thinking that I would need to use the by var:
command, as in "by assets: ", but I'm not sure how to
do it, although it seems like it should be simple.
Thanks in advance for any help!
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
* For searches and help try: