Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: st: RE: Tabulating data with multiple visits--repost
From
Tasha Amin <[email protected]>
To
<[email protected]>
Subject
RE: st: RE: Tabulating data with multiple visits--repost
Date
Fri, 4 Mar 2011 15:19:56 -0500
Yeah, the formatting got messed up in the email. Apologies. Let me try writing the dataset thus to represent individuals with multiple visits and binary variable "clear":
ID: 1,2,3,4,5 corresponding to 5 individuals
visits: ID 1 had visits (1,2,3,4,5), 2 had visits (1,3,4), 3 had visits (1,2), 4 had visits (1,2,3), 5 had visits (1,2,3)
clear: ID 1 cleared on visit 4 so had clear (0,0,0,1,1), 2 clear (0,0,1),3 clear (0,0),4 clear (0,1,1),5 clear (0,0,0)
I want to know how many people had "clear=1" by counting the IDs once, not the visits. Correct output for frequency of "clear" would be 3 (for IDs 1, 2, and 4), NOT 5 from the visits. Does that make sense?
----------------------------------------
> From: [email protected]
> To: [email protected]
> Date: Fri, 4 Mar 2011 19:51:57 +0000
> Subject: st: RE: Tabulating data with multiple visits--simple question
>
> This doesn't look simple at all to me in so far as your data example is unclear to me in my mailer, at the StataCorp version of the archives, and at the HSPH version too.
>
> Perhaps someone else can figure it out. If not, please post again with clear structure to data example.
>
> Nick
> [email protected]
>
> Tasha Amin
>
> Sorry for how simple this is. Having too many problems with it so far.
> I have data with multiple visits by the same person and would like to summarize results by counting their id's only once. How do I tabulate it? Data looks like
> ID visits clear1 1 01 2 0 1 3 11 4 11 5 12 1 02 2 13 1 0 4 1 04 2 1
> When tabulating, I would like the frequency of "clear" to be 3 (corresponding to ID's 1,2, and 4) NOT 5, based on visits. Please help. Thanks!
>
> *
> * 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/