Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: performace matching


From   Fernando Caio Galdi <fernando.galdi@fucape.br>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   st: performace matching
Date   Wed, 13 Apr 2011 05:14:37 +0000

Dear Statalister,

I need to match each firm-year observation with another from the same industry code (SIC) and year with the closest return on assets (ROA) in the current year. My database has the following format:

id        year        SIC        ROA        Suspect
1        2000        1           0.102         0
2        2000        1           0.122         1
3        2000        2           0.231         0
4        2000        2           0.091         0
5        2000        3           0.123         1
...
1        2001        1           0.145         1
2        2001        1           0.123         1
3        2001        2           0.099         0
4        2001        2           0.078         0
5        2001        3           0.269         0
...

How can I find which firm is the matching for each firm by year and by each industry?

Thanks, 
Fernando.
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index