[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

From |
"Ypma, Jelmer Yeb" <jelmer@rand.org> |

To |
<statalist@hsphsun2.harvard.edu> |

Subject |
st: RE: RE: counting per index |

Date |
Mon, 15 Nov 2004 13:49:54 -0800 |

Hi Nick, > If I understand this correctly what you want is > > gen count = 0 > levels limit, local(levels) > qui foreach l of local levels { > count if x < `l' > replace count = r(N) if limit == `l' > } Actually, this is not what I wanted since -limit- is not an integer variable. However, you made me look at the problem in a different way, and now I solved it!! Thanks!! Jelmer > I think you're right to be puzzled; this seems > a rather unusual problem. The only short-cut > I can think of is looping over levels of -limit-, > rather than over observations. > > No solution with -sum()- seems likely to get > anywhere near an answer, as no -sort- order > will segregate observations into relevant > and irelevant. > > Nick > n.j.cox@durham.ac.uk > > Jelmer Yeb Ypma > > > I guess there is a easy solution for this, but after looking > > at it for a couple of hours I and searching the internet for > > the solution I still haven't found it. Now my mind is > > completely lost somewhere, so I hope any of you can help me out. > > > > I have a variable -limit- with limits. e.g. > > 2 > > 1 > > 0 > > 2 > > 2 > > 3 > > And there is variable for instance called -x- with other values e.g. > > 0 > > 1 > > 2 > > 5 > > -3 > > 3 > > What I want is a new variable which has on index i the counts > > of -x-'s smaller than the -limit- on that index. So for index > > 1 I want to count the number of values which are smaller than > > limit[1] = 2. In this case values 0,1 and -3 of -x- are > > smaller, so I want to have 3 on index 1 in my new variable. > > For index 2, only values 0 and -3 are smaller than > > limit[2]=1, so I want a 2 there. > > I tried summing over a variable with ones which didn't seem > to work... > > (for instance: gen nsmall = sum(ones) if x < limit[_n]) > > > * > * For searches and help try: > * http://www.stata.com/support/faqs/res/findit.html > * http://www.stata.com/support/statalist/faq > * http://www.ats.ucla.edu/stat/stata/ > -------------------- This email message is for the sole use of the intended recipient(s) and may contain privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. * * For searches and help try: * http://www.stata.com/support/faqs/res/findit.html * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/

- Prev by Date:
**st: RE: counting per index** - Next by Date:
**st: saving results after -ineqerr-** - Previous by thread:
**st: RE: counting per index** - Next by thread:
**st: saving results after -ineqerr-** - Index(es):

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