Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: Filling gaps???


From   "Scott Merryman" <smerryman@kc.rr.com>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Filling gaps???
Date   Thu, 30 Nov 2006 07:15:59 -0600

In addition to the suggestions by Maarten and Philipp, another way would be:

clear
input str6 householdid  str8 personid  infected
010101         01010101        1
010101         01010102        1
010102         01010201        0
010102         01010202        1
010102         01010203        1
010103         01010301        0
010103         01010302        0
010103         01010303        0
010104         01010401        0
010104         01010402        1
end
gen hinfect = infect == 1
bys hous (hinfect): replace hinfect = hinfect[_N]
l, sepby(householdid)

Scott


> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
> statalist@hsphsun2.harvard.edu] On Behalf Of Honorati Masanja
> Sent: Wednesday, November 29, 2006 4:08 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: Filling gaps???
> 
> Dear all
> 
> I have a dataset with individuals in households. Each individual has a
> unique identifier. Some individuals in the households are infected and
> some are not. My problem is how do I tell Stata to create a new variable
> which will have 1 for households with at least one infected person  and
> 0 for households without infected persons. The datasets looks like this
> 
> HouseholdID  PersonID      Infected
> 010101         01010101        1
> 010101         01010102        1
> 010102         01010201        0
> 010102         01010202        1
> 010102         01010203        1
> 010103         01010301        0
> 010103         01010302        0
> 010103         01010303        0
> 010104         01010401        0
> 010104         01010402        1
> 
> Many thanks
> 


*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   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   |   What's new   |   Site index