On Wed, Oct 7, 2009 at 2:33 PM, Michael McCulloch
<[email protected]> 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/
