> -----Original Message-----
> From: Richard Sherman [mailto:[email protected]]
> Sent: Wednesday, April 09, 2003 11:41 AM
> To: [email protected]
> Subject: st: RE: RE: -reshape-, or -by-?
>
>
> Nick,
>
> Wow. A one-line command that executes in about one second.
> Very nice.
> Thanks!
>
> How about:
>
> foreach v of varlist var1 var2 ... {
> egen `v'_sum = sum(`v'), by(year)
> }
>
Be careful, by the way, about missing data or countries -- the sum of a
variable might not be comparable across years if there is missing data
for some countries. If that's a concern, perhaps the mean (rather than
sum) would be a better measure.
Nick Winter
*
* 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/
