Statalist


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

Re: st: identifyng records in a group that have a field with nearby values from another group


From   Scott Merryman <scott.merryman@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: identifyng records in a group that have a field with nearby values from another group
Date   Wed, 7 Oct 2009 15:01:23 -0500

On Wed, Oct 7, 2009 at 2:33 PM, Michael McCulloch
<mcculloch@pinestreetfoundation.org> wrote:
> Hello,
> I have a dataset with two groups, for example "foreign" and "domestic" in
> the auto dataset.
> For example:
>        sysuse auto, clear
>        sort foreign price
>        list foreign make price
>
> My question is, how to identify "domestic" cars that are within $200 in
> price from each "foreign" car, and create another variable called "group"
> that mark these sets?
>
> In this case, that would be:
>        Foreign   Fiat Strada           4,296
>        Domestic        AMC Concord                     4,099
>        Domestic        Pont. Sunbird                   4,172
>        Domestic        Olds Omega                      4,181
>        Domestic        Ford Mustang                    4,187
>        Domestic        Olds Starfire                   4,195
>        Domestic        Ford Fiesta                     4,389
>        Domestic        Pont. Phoenix                   4,424
>        Domestic        Plym. Champ                     4,425
>        Domestic        Buick Opel                      4,453
>        Domestic        Plym. Horizon                   4,482
>

Something like this?

sysuse auto, clear
levelsof price if fore ==1 ,local(levels)
foreach l of local levels {
     gen group_`l' = 1 if price  >  `l' -200 &  price  < `l' + 200 & fore == 0
}
sort price
l fore make price if group_4296 ==1

Scott

*
*   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