Somehow there should be information in your dataset about which columns should be added. Ways of solving this problem depends on how that information is stored, and as you didn't tell us, there is not much we can do to help you. So how do you know which columns to add?
-----------------------------------------
Maarten L. Buis
Department of Social Research Methodology
Vrije Universiteit Amsterdam
Boelelaan 1081
1081 HV Amsterdam
The Netherlands
visiting address:
Buitenveldertselaan 3 (Metropolitan), room Z434
+31 20 5986715
http://home.fsw.vu.nl/m.buis/
-----------------------------------------
-----Original Message-----
From: [email protected] [mailto:[email protected]]On Behalf Of Mungai, Edward
Sent: donderdag 26 april 2007 4:28
To: [email protected]
Subject: st: Looping across variables in variable columns
I have seen discussions on looping across an unknown number of columns which can be solved by -reshape-
My question is how to sum across columns where the number of columns varies from one observation to the next. i.e. I may need to sum columns 2 to 5 for the first observation but from columns 4 to 11 for the second observation. In all cases the summation is done across a set of adjacent columns.
I have tried to use -rowcount-, and the looping functions but as far as I can tell all sum across a fixed number of columns from one observation to the next. But there is something good also; the information on the column to begin and the column to end the summation for each observation is contained in two adjacent column which are the same for all the observations.
Feedback is highly appreciated upfront.
Edward.
This message has been scanned for viruses by TRENDMICRO,
an IESE technology affiliate company and global leader in antivirus and content security software.
*
* 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/
*
* 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/
