Thank you for the code, but I tried it and it didn't work. I have included some example data lines: infile datalines dsd truncover;
input PatientID:$12. age_months2:32. Index_Visit2:$14.;
label PatientID="PatientID";
datalines;
0-00000001 66.72 Yes
0-00000002 58.72 Yes
0-00000003 58.96 Yes
0-00000004 23.68 No
0-00000004 31.84 No
0-00000004 41.84 No
0-00000005 30.32 No
0-00000005 57.36 Yes
0-00000006 8.32 No
0-00000006 8.48 No
0-00000006 9.04 No
0-00000006 12.32 No
0-00000006 18.8 No
0-00000006 39.76 Yes
0-00000007 22.32 No
0-00000007 27.36 No
0-00000007 41.76 No
0-00000007 46 Yes
0-00000007 46 No
0-00000008 6.08 No
0-00000008 39.6 Yes Hopefully I did that right. When I ran the code provided, a couple problems emerged. First, it is counting the "Yes" instances even if there are not any "No" instances first. Second, it is counting the instances of "No" that occur prior to a "Yes" correctly, but in the rows where there is a "Yes" it is not repeating the count from the row prior. I'm not sure what it is doing, actually. Finally, when a "No" occurs after a "Yes", it seems to be repeating the incorrect count from the prior "Yes" row.
... View more