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]
AW: st: AW: Calculating percentages (proportions) of indicator variables
From
"Martin Weiss" <[email protected]>
To
<[email protected]>
Subject
AW: st: AW: Calculating percentages (proportions) of indicator variables
Date
Mon, 9 Aug 2010 17:10:31 +0200
<>
"use *contract* for percentage calculation."
Quite right:
*************
clear*
inp byte(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
end
list, noo sepby(country)
contract country response
bys country: egen overall=total(_freq)
gen percent=100* _freq/overall
expand _freq
drop _freq overall
sort country response
l, noo sepby(country)
*************
HTH
Martin
-----Ursprüngliche Nachricht-----
Von: [email protected] [mailto:[email protected]] Im Auftrag von Aravinda Meera Guntupalli
Gesendet: Montag, 9. August 2010 15:14
An: [email protected]
Betreff: Re: st: AW: Calculating percentages (proportions) of indicator variables
use *contract* for percentage calculation.
*************
h contract
*************
Aravinda
Martin Weiss wrote:
> <>
>
>
>
> *************
> h collapse
> *************
>
>
>
> HTH
> Martin
>
> -----Ursprüngliche Nachricht-----
> Von: [email protected] [mailto:[email protected]] Im Auftrag von [email protected]
> Gesendet: Montag, 9. August 2010 14:40
> An: [email protected]
> Betreff: st: Calculating percentages (proportions) of indicator variables
>
> 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/
>
>
>
*
* 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/