Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Prakash Singh <prakashbhu@gmail.com> |
To | statalist <statalist@hsphsun2.harvard.edu> |
Subject | Re: st: generating variable with condition on same variable |
Date | Mon, 30 Dec 2013 10:12:42 +0530 |
Thanks Ronnie it did work with slight modification. Thanks a lot On Fri, Dec 27, 2013 at 2:26 PM, Ronnie Babigumira <rb.glists@gmail.com> wrote: > Does this work? > > clear > input hhid pump > 7 3 > 8 3 > 8 4 > 9 3 > 9 4 > 10 3 > 10 . > 11 1 > end > > label define pmpl 1"Tube" 3"Diesel" 4"Electric" > la val pump pmpl > > * How many pumps > bys hhid : egen n_allpumps = count(pump) > bys hhid : egen n_dieselpumps = total(pump == 3) > bys hhid : egen n_otherpumps = total(!inlist(pump,3,.)) > list > > hhid pump n_allpumps n_dieselpumps n_otherpumps > 7 Diesel 1 1 0 > 8 Diesel 2 1 1 > 8 Electric 2 1 1 > 9 Diesel 2 1 1 > 9 Electric 2 1 1 > 10 Diesel 1 1 0 > 10 . 1 1 0 > 11 Tube 1 0 1 > > On Fri, Dec 27, 2013 at 5:22 AM, Prakash Singh <prakashbhu@gmail.com> wrote: >> Hello, >> I need help in generating a variable based on following condition >> >> I have one data file at household level where the variable itemcode >> indicates type of pump household own. I want to see how may of the >> households who have diesel pump also own any other type of pump. For >> example a new variable can be created where if the farm (diesel pump >> owner) have one electric pump or one tube well. >> >> >> Many thanks in advance >> >> Regards >> Prakash >> * >> * For searches and help try: >> * http://www.stata.com/help.cgi?search >> * http://www.stata.com/support/faqs/resources/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/faqs/resources/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/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/