Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Nearest value

From   "Renzo Comolli" <>
To   <>
Subject   Re: st: Nearest value
Date   Fri, 28 Nov 2003 21:48:14 -0500

Read the help for -egen- it will help

How do you plan to handle ties (i.e. a case in which there is more than one
household which is at the same minimal distance from the average
If you plan to pick one of them at random then
. egen meanconsumption=mean(consumption)
. generate absconsumptiondev=abs(meanconsumption-consumption)
. sort absconsumptiondev
. keep in 1
-sort- already does the maximization for you among ties

If you plan to keep all the ties
. egen meanconsumption=mean(consumption)
. generate absconsumptiondev=abs(meanconsumption-consumption)
. egen mindevfromavgcons=min(absconsumptiondev)
. keep if  absconsumptiondev==mindevfromavgcons


*From   Ramani Gunatilaka <> 
Subject   st: Nearest value 
Date   Sat, 29 Nov 2003 01:13:43 +0000 

Hi everybody,
This is probably a very simple question, but I have not been able to figure
out a solution.
I have a data set with consumption and other variables such as number of
adults, district, sector for each household.
I need to write a programme that requires selecting the particular household
whose consumption is nearest to the mean consumption of all the households. 
Can someone please  tell me, what is the Stata command that will do this for

*   For searches and help try:

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