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: anycount .a and .b


From   Jörg Eulenberger <j.eulenberger@web.de>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: anycount .a and .b
Date   Tue, 03 Jul 2012 20:02:44 +0200


No i will not. All strings are dropped:

ds, has(type string)
drop `r(varlist)'

gen a_missing = 0
gen b_missing = 0

ds , has(type numeric)

foreach v in `r(varlist)' {
       replace a_missing = a_missing + (`v' == .a)
       replace b_missing = b_missing + (`v' == .b)
}

Thanks a lot Nick. It works fine.
Jörg




Am 03.07.2012 19:53, schrieb Nick Cox:
> You will probably tell me next that there are string variables too.
>
>
> gen a_missing = 0
> gen b_missing = 0
>
> ds , has(type numeric)
>
> foreach v in `r(varlist)' {
>        replace a_missing = a_missing + (var`j' == .a)
>        replace b_missing = b_missing + (var`j' == .b)
> }
>
> See
>
> SJ-2-2  pr0005  . . . . . .  Speaking Stata:  How to face lists with fortitude
>         . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  N. J. Cox
>         Q2/02   SJ 2(2):202--222                                 (no commands)
>         demonstrates the usefulness of for, foreach, forvalues, and
>         local macros for interactive (non programming) tasks
>
> SJ-9-1  pr0046  . . . . . . . . . . . . . . . . . . .  Speaking Stata: Rowwise
>         (help rowsort, rowranks if installed) . . . . . . . . . . .  N. J. Cox
>         Q1/09   SJ 9(1):137--157
>         shows how to exploit functions, egen functions, and Mata
>         for working rowwise; rowsort and rowranks are introduced
>
>
> On Tue, Jul 3, 2012 at 6:47 PM, Jörg Eulenberger <j.eulenberger@web.de> wrote:
>> Thanks Nick for the solution.
>>
>> But i was  not quite correct  by the varnames. Sorry.  Many variables
>> have different names like: eis01 anzahlki GEBJA01K STU01K KT01K EP01K
>> name04k.
>>
>> Now i could  rename all vars but is there any way to avoid this?
>>
>> Sorry for myincorrectness.
>>
>> Jörg
>>
>>
>>
>>
>> Am 03.07.2012 19:17, schrieb Nick Cox:
>>> gen a_missing = var1 == .a
>>> gen b_missing = var1 == .b
>>>
>>> qui forval j = 2/600 {
>>>       replace a_missing = a_missing + (var`j' == .a)
>>>       replace b_missing = b_missing + (var`j' == .b)
>>> }
> *
> *   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/


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