[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: AW: st: local containing (all) variables' names in a dataset

From   "Eric A. Booth" <>
Subject   Re: AW: st: local containing (all) variables' names in a dataset
Date   Tue, 18 Aug 2009 09:39:01 -0500

Thanks for the clarification, Nick. I made the erroneous assumption that an increase in the number after -ds- (e.g., ds2, ds3, ds5...) meant newer versions of the program.

Since -ds- is now an undocumented/unofficial command, I am curious whether there are other commands that have its functionality. In the "previously documented" link in the -ds- help file it says:

" Previously documented commands are commands of Stata from a previous release that are no longer documented because they have been superseded by more recent, better commands. "

I see that you can grab a c(varlist) from commands like -desc- and you could probably use extended macro functions to piece together what - ds- does, but is there another command that has -ds- 's functionality built in & supersedes -ds- ??



Eric A. Booth
Public Policy Research Institute
Texas A&M University
Office: +979.845.6754

On Aug 17, 2009, at 3:15 PM, Nick Cox wrote:

Thanks to Eric and to other friends of -ds- for various plugs.

There is some risk here of various small confusions. Let me clarify.

1. The official version of -ds- is the latest version there is. It
incorporates all my contributions that have lasting value, in my view
that is.

2. Otherwise this is the story:

ds5 on SSC is for Stata 5.

ds2 on SSC and in STB-56 is for Stata 6.

ds2 in STB-60 is for Stata 7.

ds3 on SSC is for Stata 7.

So, unless you are using an ancient Stata, the previous versions are of
no current interest. They aren't even of historic interest! The key
point is that both the STB and SSC are archives, and thus inevitably
contain some superseded and obsolete stuff.


Eric A. Booth

It's been updated to newer versions  by Nick Cox--see  -ds3- and -ds5-

ssc install ds3
ssc install ds5

On Aug 17, 2009, at 1:06 PM, David Jacobs wrote:

But -ds- still can be found after -help-

Martin Weiss

" a real hidden gem"

Now demoted to "previously documented" status in Stata 11, though.

Augusto Cadenas

thank you very much for these quick answers. -ds- seems to
do a very fine job, a real hidden gem, as Martin wrote. (and yes, I'm
aware that I'm replacing the original dataset.)

On Mon, Aug 17, 2009 at 3:49 PM, Martin Weiss<>

On -ds- also see

Scott Merryman

You can use macro list.  See -help macrolists-

For example:

. sysuse auto ,clear
(1978 Automobile Data)

. ds
make          mpg           headroom      weight        turn
price         rep78         trunk         length

. 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

On Mon, Aug 17, 2009 at 8:38 AM, Augusto Cadenas

I have to collapse a series of datasets and I would appreciate
help. The issue is that these datasets have different variables,
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!

*   For searches and help try:

*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index