Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


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

Re: st: Calculating percentages (proportions) of indicator variables


From   Jeph Herrin <stata@spandrel.net>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Calculating percentages (proportions) of indicator variables
Date   Mon, 09 Aug 2010 10:18:38 -0400

Try

  forv i=1/4 {
	bys country : egen percent_`i'=mean(response==`i')
  }

But if you have missing values this may not give what you want.

hth,
Jeph

On 8/9/2010 8:39 AM, rado645-bg@yahoo.de wrote:
Dear all,

I hope that you would help me with the following technical problem.


I have a dataset based on a question with four different possible answers. The
question takes the form of an indicator variable with 4 different numeric values
(1,2,3,4).

I have data for individuals from several countries.  I need to generate a new
variable that contains the fraction (i.e. percentage share) of each response  to
the question within each country. However, I cannot find any online source on
calculating percentages with mutliple responses in Stata (more than two).

Example:

country: response:

1               3
1               3
1               2
1               1
1               4
1               3
2               1
2               1
2               2
2               3
2               4
3               2
3               2
3               4
3               3
3               1



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

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


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index