Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

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

From |
Nick Cox <n.j.cox@durham.ac.uk> |

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

Subject |
RE: st: Count multiple observations / weight in Scatter |

Date |
Mon, 20 Sep 2010 10:23:07 +0100 |

For just counting, -contract- is easier and incidentally faster than -collapse-. An alternative to Friedrich's code is drop _all input id x y 1 10 19 2 12 19 3 10 19 end contract x y list scatter y x [aw=_freq] Nick n.j.cox@durham.ac.uk Friedrich Huebler ================= Maarten's code generates the data Rainer had asked for but I would suggest to -collapse- the data instead. A scatter plot of the original data is inefficient because observations 1 and 3 will be plotted twice, on top of each other. The information in the variable "id" is lost at that point so it is not necessary to keep it for the graph. drop _all input id x y 1 10 19 2 12 19 3 10 19 end gen count = 1 collapse (sum) count, by(x y) list scatter y x [aw=count] Maarten buis ============ > *--------------- begin example ------------- > drop _all > input id x y > 1 10 19 > 2 12 19 > 3 10 19 > end > bys x y : gen count = _N > sort id > list > *--------------- end example ---------------- > (For more on examples I sent to the Statalist see: > http://www.maartenbuis.nl/example_faq ) Rilke Rainer Michael ==================== >> I have data where for example one subject indicates two >> different variables, lets say X and Y. >> I now want to create a variable lets say freq which counts >> the number of multiple duplicate observation. * * 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/

**References**:**st: Count multiple observations / weight in Scatter***From:*"Rilke Rainer Michael" <rilke@wiso.uni-koeln.de>

**Re: st: Count multiple observations / weight in Scatter***From:*Maarten buis <maartenbuis@yahoo.co.uk>

**Re: st: Count multiple observations / weight in Scatter***From:*Friedrich Huebler <fhuebler@gmail.com>

- Prev by Date:
**st: RE: Closing gaps in STATA panel** - Next by Date:
**RE: st: disable 32 character limit** - Previous by thread:
**Re: st: Count multiple observations / weight in Scatter** - Next by thread:
**RE: st: Count multiple observations / weight in Scatter** - Index(es):