Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: collapse if at least X or more obs. per group are non-missing

From   [email protected]
To   [email protected]
Subject   Re: st: collapse if at least X or more obs. per group are non-missing
Date   Tue, 24 Aug 2004 21:03:46 +0200 (CEST)

Dear Jens,

the stata help provides information about the collapse syntax. There:

.help collapse
collapse clist [...]

where clist is either
[(stat)] varlist [ [(stat)] ... ]
[(stat)] target_var=varname [target_var=varname ...] [ [(stat)] ...]

If you choose (which at least your syntax does) the first option, the data will
be collapsed using the variables in <varlist> as both, the new and old variable
Thus, collapse (count) GDP (mean) GDP, by(sftgcode decade), tries to write
both, the number of nonmissing observations and their mean of GDP into the
variable GDP. This will obviously not work.
So you have to choose the second <clist> syntax; in your example you should
collapse (count) GDP_N=GDP (mean) GDP_mea=GDP, by(sftgcode decade)
Keep in mind that stata allows only variable names with 8 characters (that's
why GDP_mea and not GDP_mean).


> . collapse (count) GDP (mean)	GDP, by(sftgcode decade)
> error:
> GDP = (count) GDP
> GDP = (mean) GDP
> name conflict
> r(198);
> Does this mean that I cannot get means and counts for the same variable at
> the same time when using collapse? Moreover, is there any way to directly
> aggregate annual obs to decadal country averages while omitting those
> averages for which a pre-specified number of obs. is missing per country?
> I wasn't able to find any solution to this on the archives, although I
> assume it's a rather common problem. Thank you very much for your help.
> Best,
> Jens Hainmueller
*   For searches and help try:

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