Re: st: Combining 7 variables with the same output into a single frequency table

[Astha Ramaiya <aramaiya@ihi.or.tz>]

I want the sum of all variables (fever1 - fever7) categorized by 1 and 2. 

Would the code be the following: 

egen m_fever = rowtotal(m_fever1, m_fever2, m_fever3, m_fever5, m_fever6, m_fever7) to get the combined freq totals for  "1" and combined freq totals for "2"? 

Thank you. 

Astha. 
On Feb 13, 2013, at 4:47 PM, Richard Goldstein <richgold@ix.netcom.com> wrote:

> it is not clear what you are looking for
> 
> if you want the sum of the variables use -egen- with the rowtotal option
> 
> if you want to know whether any of the variables have a "1", use -egen-
> with the rowmax option
> 
> if you want something else, please clarify
> 
> Rich
> 
> On 2/13/13 4:39 PM, Astha Ramaiya wrote:
>> Dear Nicholas, 
>> 
>> I have 7 different variables (fever 1, fever 2, fever 3….fever7) with the same output (0=No, 1 = Yes). I want to combine all these variables so that i can calculate prevalence of the morbidity. For example: 
>> 
>> Fever 1-7 give the output: 
>> 
>> m_fever1 |      Freq.     Percent        Cum.
>> ------------+-----------------------------------
>>          1 |         50       14.3       14.7
>>          2 |        300       85.7      100.00
>> ------------+-----------------------------------
>>      Total |        350      100.00
>> 
>> 
>> m_fever2 |      Freq.     Percent   Cum.
>> ------------+-----------------------------------
>>          1 |         0       	0      	 0
>>          2 |        350      100.00      100.00
>> ------------+-----------------------------------
>>      Total |        350      100.00
>> 
>> m_fever3 |      Freq.     Percent        Cum.
>> ------------+-----------------------------------
>>          1 |         100       28.6       28.6
>>          2 |        250       71.4      100.00
>> ------------+-----------------------------------
>>      Total |        350      100.00
>> 
>> How can i combine the 3 tables above to give me the following table? 
>> 
>> m_fever |      Freq.     Percent        Cum.
>> ------------+-----------------------------------
>>          1 |         150       14.3       14.7
>>          2 |        900       85.7      100.00
>> ------------+-----------------------------------
>>      Total |        1050      100.00
>> 
>> I have been trying to find something the entire day but haven't been successful. Any help would be very much appreciated.
>> 
>> Regards, 
>> 
>> Astha. 
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/