 Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

# st: generating a variable?

 From Ignacio Martinez To statalist@hsphsun2.harvard.edu Subject st: generating a variable? Date Thu, 28 Jul 2011 15:10:50 -0400

```Hi,

I'm having troubles generating 2 new variables with my data.

I have the following variables: ID; E01-E12 where E01 =3 indicates
that i is enrolled in a 4 year college in January, and E05=2 means
that he is enrolled in a 2 year college in may.

I want to generate a 2 new variables Total_2_year that is the total
number of month that i is enrolled in a 2 year college and
total_4_year that is the total number of month that i is enrolled in a
4 year college.

What is the best way of doing this?

<code>
*Generates vectors of total months enrolled in college
gen total_2_year = 0
gen total_4_year = 0
gen total_none = 0

forvalues month=1/9 {
if 511200`month'==3 then total_4_year==total_4_year+1
if 511200`month'==2 then total_2_year==total_2_year+1
if 511200`month'==1 then total_none==total_none+1
if 511200`month'==-4 then total_none==-4
if 511200`month'==-4 then total_2_year==-4
if 511200`month'==-4 then total_4_year==-4
}

</code>

but i get only zeros... :_(

Thanks a lot

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