Statalist


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

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


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: identifyng records in a group that have a field with nearby values from another group
Date   Wed, 7 Oct 2009 22:08:50 +0200

<>

**************
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: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] 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
mm@pinestreetfoundation.org





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