Dear statalisters,
I have to collapse a series of datasets and I would appreciate your
help. The issue is that these datasets have different variables, but
always the same variable by which I want to collapse. So I have to run
the following command:
collapse (mean) id (sum) [all other variables here], by(name)
And I would like to embed this in a foreach loop of the type
local datasets `"dataset1 dataset2 dataset3"'
foreach X of local datasets {
use `X', clear
collapse (mean) id (sum) [all other variables here], by(name)
save, replace
}
The issue for me is how to create a local that contains the names of
all variables in each dataset, except for "name" and "id". Any
suggestions are appreciated!
Augusto
*
* 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/
