Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


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

Re: st: string variable


From   Nick Cox <njcoxstata@gmail.com>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: string variable
Date   Fri, 3 Aug 2012 08:41:12 +0100

My guess is that -wtmean()- is written for some version of Stata -- say around Stata 5 -- sufficiently old that by an old misfeature it behaves as if the quotation marks were stripped on parsing. I wrote an FAQ on this about 10 or 12 years ago, but can't find it using only a phone.

Your solutions include

 to rewrite -wtmean()-

to -encode- your string variable and work with the corresponding numeric variable (this is probably closest to what else you are doing)

to write a loop using -summarize- and -replace-

to use -statsby-.

Nick

On 3 Aug 2012, at 06:14, "Fabian Schönenberger" <sch.f@gmx.ch> wrote:

Dear Statalist

I try the following commands:

. levelsof SIZEBM,local(levels)
`"BH"' `"BL"' `"BM"' `"SH"' `"SL"' `"SM"'

foreach l of local levels {
egen meanwreturn_`l'=wtmean(trt1m) if SIZEBM=="`l'",weight(size) by (datemt)
 }
BH not found
r(111);

wtmean is from SSC.

SIZEBM is a string variable, generated with the command

egen SIZEBM=concat(SIZE BM)

It seems the problem is not the foreach, but the term - SIZEBM=="`l'" -

Any ideas the solve the problem highly appreciated.



*
*   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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index