--- Mike Kim <[email protected]> wrote:
> I would like to create 'var1' in the following table based on id and
> title.
<snip>
> id title var1 var2
> 1 A 1 1
> 1 A 1 2
> 1 B 2 1
> 1 B 2 2
> 1 B 2 3
> 2 C 1 1
> 2 C 1 2
> 2 C 1 3
> 2 D 2 1
> 2 D 2 2
> 3 E 1 1
*----------------- begin example -------------
drop _all
input id str1 title var1 var2
1 A 1 1
1 A 1 2
1 B 2 1
1 B 2 2
1 B 2 3
2 C 1 1
2 C 1 2
2 C 1 3
2 D 2 1
2 D 2 2
3 E 1 1
end
bys id title : gen byte notfirst = !(_n==1)
bys notfirst id (title): gen tid = _n if notfirst == 0
bys id title (notfirst): gen id2 = sum(tid)
*-------------------- end example ----------------------
(For more on how to use examples I sent to the Statalist, see
http://home.fsw.vu.nl/m.buis/stata/exampleFAQ.html )
Hope this helps,
Maarten
-----------------------------------------
Maarten L. Buis
Department of Social Research Methodology
Vrije Universiteit Amsterdam
Boelelaan 1081
1081 HV Amsterdam
The Netherlands
visiting address:
Buitenveldertselaan 3 (Metropolitan), room N515
+31 20 5986715
http://home.fsw.vu.nl/m.buis/
-----------------------------------------
*
* 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/
