st: From: tunmise jones <tunmisejones@gmail.com>

[owner-statalist@hsphsun2.harvard.edu]

Hello All,

I am looking to measure the effect of foreign participation (FP) on
the employment growth of domestic firms using a balanced panel dataset
over a period of 9 years (1991-1999) .

FP is measured as the ratio of foreign employment to total employment
in a given industry. I generate the variable FP using the following
commands:

-bys ind year: egen F_EMP = total(employment) if Foreign ==1

gen FP= F_EMP/IND_EMP


The FP variable is only generated for foreign firms. How then can this
be manipulated so I can regress foreign participation against
employment growth of domestic firms only (Foreign=0)?


I'll appreciate all the help I can get.

Regards,

Tunmise Jones
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/