Statalist


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

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


From   Michael McCulloch <mcculloch@pinestreetfoundation.org>
To   Statalist Statalist <statalist@hsphsun2.harvard.edu>
Subject   st: identifyng records in a group that have a field with nearby values from another group
Date   Wed, 7 Oct 2009 12:33:23 -0700

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index