Have you tried the following command?
. collapse var1, by(id)
rgds,
Jeetendra
________________________________________
From: [email protected] [[email protected]] On Behalf Of Christian Bustamante [[email protected]]
Sent: Sunday, August 02, 2009 7:48 AM
To: Statalist
Subject: st: How to generate "total" observation?
Hi all,
I have a (possible) dummy question. I have a panel data set like the following:
id year var1
01 2000 10
01 2001 20
02 2000 15
02 2001 25
I want to create a new observations, with id=03, that sum the var1
over the other ids. Obviously, I'm no going to use this observations
to make some estimation, but total statistics. How can I generate this
aditional observations.
Thanks
--
CdeB
*
* 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/
