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]
Re: st: Count multiple observations / weight in Scatter
From
Friedrich Huebler <[email protected]>
To
[email protected]
Subject
Re: st: Count multiple observations / weight in Scatter
Date
Fri, 17 Sep 2010 11:37:02 -0400
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]
Friedrich
On Fri, Sep 17, 2010 at 5:24 AM, Maarten buis <[email protected]> wrote:
> --- On Fri, 17/9/10, Rilke Rainer Michael wrote:
>> 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.
>
> *--------------- 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 )
>
> Hope this helps,
> Maarten
*
* 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/