Statalist


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

Re: st: How to sort out missing data


From   "Ziad El-Khatib" <Ziad.El-Khatib@ki.se>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: How to sort out missing data
Date   Tue, 20 Nov 2007 06:54:49 -0800

Thank you a lot!
best regards
ziad


On Nov 20, 2007 6:17 AM, Maarten buis <maartenbuis@yahoo.co.uk> wrote:
> --- Ziad El-Khatib <Ziad.El-Khatib@ki.se> wrote:
>
> > I have cohort patients following on visit: 0,2,4,8,12,16,20,24,36&52
> > When I tab the dataset i see that the total number of patients per
> > visit is not consistent.
> >
> > Is it possible to sort out the studyid number of patients who did not
> > come on every visit?
> > if yes, would it be possible to find at which visit number?
>
> asuming your data is in long format, your id variable is called id,
> your visit variable is called visit, and you are looking for missing
> values in the variable called var:
>
> list id visit if missing(var)
>
> assuming your data is in wide format and you are looking for for
> missing values in variables var0, var2, ..., var52 (the values for var
> at visit 1/52):
> list id var* if missing(var0, var2, var4, var8, var12, var16, var20,
> var24, var36, var52)
>
> Hope this helps,
> Maarten
>
>
> -----------------------------------------
> Maarten L. Buis
> Department of Social Research Methodology
> Vrije Universiteit Amsterdam
> Boelelaan 1081
> 1081 HV Amsterdam
> The Netherlands
>
> visiting address:
> Buitenveldertselaan 3 (Metropolitan), room Z434
>
> +31 20 5986715
>
> http://home.fsw.vu.nl/m.buis/
> -----------------------------------------
>
>
>       ___________________________________________________________
> Want ideas for reducing your carbon footprint? Visit Yahoo! For Good  http://uk.promotions.yahoo.com/forgood/environment.html
>
> *
> *   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/
>



-- 
Ziad El-Khatib
AIDS Unit
National Institute for Communicable Diseases (NICD)
1 Modderfontein Road
Private Bag X4, Sandringham, 2131
Johannesburg, South Africa
Mobile: +27 (0) 72-52 39 716
Phone: +27 (0) 11-386 6433
Fax (NICD): +27 (0)11 386 6453
Fax (alternative): +27 (0)866 18 2871
http://www.nicd.ac.za/

Division of International Health (IHCAR)
Karolinska Institutet
www.phs.ki.se/ihcar
*
*   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