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

Re: st: How to sort out missing data

From   Maarten buis <>
Subject   Re: st: How to sort out missing data
Date   Tue, 20 Nov 2007 14:17:51 +0000 (GMT)

--- Ziad El-Khatib <> 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 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

Want ideas for reducing your carbon footprint? Visit Yahoo! For Good
*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index