<>
On -ds- also see http://www.stata-journal.com/article.html?article=dm0040
Are you sure you want to -replace- the original dataset with the -collapse-d
one? Seems to me that is what you are doing in the line - save, replace -
HTH
Martin
-----Ursprüngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von Scott Merryman
Gesendet: Montag, 17. August 2009 15:47
An: [email protected]
Betreff: Re: st: local containing (all) variables' names in a dataset
You can use macro list. See -help macrolists-
For example:
. sysuse auto ,clear
(1978 Automobile Data)
. ds
make mpg headroom weight turn
gear_ratio
price rep78 trunk length displacement
foreign
. local a = r(varlist)
. local b make rep78
. local c:list a - b
. disp "`c'"
price mpg headroom trunk weight length turn displacement gear_ratio foreign
Scott
On Mon, Aug 17, 2009 at 8:38 AM, Augusto Cadenas
<[email protected]> wrote:
>
> 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/
*
* 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/
