<>
**************
sysuse auto, clear
sort foreign price
gen order=_n
su order if foreign, mean
forv i= `r(min)'/`r(max)'{
gen byte group`i'=abs(price-price[`i'])<=200
}
l make price if !fo & group57
**************
HTH
Martin
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Michael McCulloch
Sent: Mittwoch, 7. Oktober 2009 21:33
To: Statalist Statalist
Subject: st: identifyng records in a group that have a field with nearby
values from another group
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
Michael McCulloch, LAc MPH PhD
Pine Street Foundation
124 Pine Street
San Anselmo, CA 94960-2674
tel: 415-407-1357
fax: 206-338-2391
[email protected]
*
* 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/
