Re: st: Adding a variable to a panel dataset

[Jason Hecht <jayhstata@gmail.com>]

Chris -

A point of clarification:

In the example that you provided, it appears that the "wpid" file has
as many obs. as the "employee" file.

My problem is that I have 7 different country dummy variables that
identify where the individual firm is located.  However, I want to
create a single variable that will have the unemployment rate (from
1998 to 2008) mapped into each firm's panel.

So let's say my "wpid" is called "unrate" (a text file) which will
have 11 lines and 14 columns arrayed as:

1998  China 8.9  Fra  6.4 . . . US  5.4
1999  China 8.3  Fra  5.8 . . . US  4.5
.              .              .      .            .     .
.              .              .      .            .     .
.              .              .      .            .     .
2008 China 7.2   Fra  8.2. . .  US   7.5

where the above variables would be named as "year" "China" "RUNCChn"
"Fra" RUNCFra" .... "US" "RUNCUS"

Now I would need to merge the above dataset with my analagous
"employee" dataset which has 155,386 firm-year panel observations
(firm id #'s go from 1 to 14,126 and year (1998-2008) is a variable.

I'm not sure if your FAQ example would work because I need to merge
unempoyment rates for seven different countries into the firm-level
panels.

I'm sorry if I am misinterpreting the FAQ example.  I'm relatively new
to STATA and am learning how to use the programming commands.

Kindly advise and thanks so very much for your help.

Jason

On Mon, Oct 1, 2012 at 7:04 AM, Christopher Baum <kit.baum@bc.edu> wrote:
> On Oct 1, 2012, at 2:33 AM, Jason wrote:
>
>> I have constructed a panel dataset containing data on +14,000 firms
>> from 1998 to 2008.  I created a dummy variable that identifies the
>> country where each firm is located (i.e., China, France, Germany,
>> Japan, India, UK, or US).
>>
>> I now want to add the unemployment rate for each country that would
>> map into each firm's panel. That is, I would like a single column that
>> would match the country's unemployment rate to the panel of the
>> individual firm.
>>
>> Is there a relatively easy way to do this?
>
> This is a FAQ:
>
> http://www.stata.com/support/faqs/data-management/group-characteristics-for-subsets/
>
> Kit
>
>
> Kit Baum   |   Boston College Economics & DIW Berlin   |   http://ideas.repec.org/e/pba1.html
>                              An Introduction to Stata Programming  |   http://www.stata-press.com/books/isp.html
>   An Introduction to Modern Econometrics Using Stata  |   http://www.stata-press.com/books/imeus.html
>
>
> *
> *   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/
*
*   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/