Statalist


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

Re: st: Data Management


From   Rijo John <rmjohn@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Data Management
Date   Thu, 28 May 2009 11:32:02 -0500

Hi Austin,

thanks. Unfortunately this does not yield the result I am looking for.
It creates as many rows as number of neighbors for each state. Since
there is no observation in the final data set for those states that
has no neighbors.

I will keep trying on the lines you suggested anyways.
Thanks,

On Thu, May 28, 2009 at 10:47 AM, Austin Nichols
<austinnichols@gmail.com> wrote:
> Rijo John <rmjohn@gmail.com>:
> One way-- open the second dataset, call it d2, expand by number of
> years, then merge 8 times to get neighbors' tax rates, then once more
> to put on own tax rates, like so:
>
> use d2
> expand 44
> bys Ste: g Year=1964+_n
> ren Ste hold
> forv i=1/8 {
> ren n`i' Ste
> joinby Ste Year using d1, unm(both)
> ta _m
> drop if _m==2
> drop _m
> ren Ste s`i'
> ren tax n`i'
> }
> ren hold Ste
> joinby Ste Year using d1, unm(both)
>
> [untested code, but the idea should be clear]
>
> On Thu, May 28, 2009 at 11:32 AM, Rijo John <rmjohn@gmail.com> wrote:
>> Hello statalist,
>>
>> I have a data set as below.
>>
>> Ste fips        Year    tax
>> AL       1      1965     6.3
>> AK       2      1965     8.0
>> AZ       4      1965     4.3
>> AR       5      1965     7.7
>> CA       6      1965     3.0
>> CO       8      1965     4.2
>>
>> Its a panel data for all 51 states running from year 1965 through 2008.
>>
>> I want to generate few new variables from it. Basically I want to
>> create one variable for each neighboring states as n1 n2 n3 and son
>> on.I have another data that shows the neighborhood information as
>> follows.
>>
>> Ste  n1 n2      n3      n4      n5      n6      n7      n8
>> AL      FL       GA      MS      TN
>> AK      NONE
>> AZ       CA      CO      NV      NM      UT
>> AR       LA      MS      MO      OK      TN
>> CA       AZ      NV      OR
>> CO       AZ      KS      NE      NM      OK      UT      WY
>> CT       MA      NY      RI
>>
>> Here, for the state AL the values for n1 n2 & n3 should be the values
>> of "tax" in FL, GA, and TN respectively for the respective years.
>> Similarly for AK all the n's will be empty. and for AZ, n1 to n5 will
>> take values of the variable tax in CA, CO, NV. NM and UT respectively
>> for the respective years.
>> There is a maximum of only 8 neighbors for a state and minimum zero.
>> Can someone advise me how I can proceed with it?
>>
>
> *
> *   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/
>

*
*   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   |   What's new   |   Site index