Re: st: generate new variable with frequencies

[Ernest Berkhout <ernestb@seo.fee.uva.nl>]

At 13:42 4-11-2003, Matteo Foschi wrote:
> We have a little trouble with a, we think, easy task.
> We want to generate a variable, which contains the relative frequency of
> another variable values.
> We have a variable, say "type", and want to built a new variable,
> say "typ_freq", which shows the relatively frequency of each value of "type".
If I understand correctly, you should just keep it more straightforward 
using some of the -egen- functions (see -help egen-).
For example:

egen totalfreq = count(type)
bysort group: egen typfreq = count(type)
gen typfreq_rel = typfreq/totalfreq

This is if you have no weights. If you do have weights, the line of thought 
is the same but you will have to play around with the other -egen- functions.



Ernest Berkhout
SEO Amsterdam Economics
University of Amsterdam

Room 3.08
Roetersstraat 29
1018 WB Amsterdam
The Netherlands

tel.:+ 31 20 525 1657
fax:+ 31 20 525 1686
http://www.seo.nl
===========================
A statistician: someone who insists
on being certain about uncertainty
===========================

*
*   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/