# Re: st: RE: Creating a Count Variable

 From "Friedrich Huebler" <[email protected]> To [email protected] Subject Re: st: RE: Creating a Count Variable Date Thu, 3 Apr 2008 17:12:29 -0400

```Assuming that Isaac is correct and the variables are indeed coded as 0
and 1, the -gen- command in his message only yields the sum of
selected responses if there are no missing values across the response
variables. With -egen rowtotal- missing values are treated as 0.

. egen newvar = rowtotal(vara varb varc vard vare)

Friedrich

On Thu, Apr 3, 2008 at 3:55 PM, Vargas Naranjo Isaac Alonso
<[email protected]> wrote:
> Puede hacerlo de la siguiente manera:
>
>  Gen newvar=vara+varb+varc+vard+vare
>
>  Le generar� una nueva variable con la suma de las otras que me imagino deben estar codificadas como 0 y/o 1, el resultado ser� la suma de veces que fue seleccionado alg�n elemento.
>
>  Saludos,
>
>  Isaac A. Vargas Naranjo.
>  Gesti�n Financiera - Divisi�n Clientes
>
>
>  -----Mensaje original-----
>  De: [email protected] [mailto:[email protected]] En nombre de Chao Yawo
>  Enviado el: jueves, 03 de abril de 2008 01:37 p.m.
>  Para: [email protected]
>  Asunto: st: Creating a Count Variable
>
>  Hi
>
>  I have a range of 5 variables that ask respondents
>  who is responsible for different household household
>  tasks (vara, varb, varc, vard, vare). Respondents
>  have a choice of selecting one fo the followinvg
>  responses/values for each question:
>
>  1. Respondent Alone,
>  2. Respondent and Roomate
>  3. Respondent and Someone else
>  4.Roomate Alone
>  5. Someone else alone.
>
>  I want to create a variable that counts how many
>  times a respondent selects each of these
>  values/responses/choices across all the five
>  variables (vara - vare).
>
>  The resulting output would list per respondent, how
>  many times they selected each choice (across the 5
>  variables).
>
>  thanks very much -- CY

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