About CSU_KL

CSU_KL · ‎08-28-2017

Thank you! I like the codes.and get what i was looking for. tot ID 38 1 0 2

CSU_KL · ‎08-28-2017

Your codes work. Thank you for your help! I would see the total so i removed the (drop=total) and get the output below. | Obs | ID | Min | group | total | | 1 | 1 | 4 | 1 | 24 | | 2 | 1 | 5 | 1 | 24 | | 3 | 1 | 1 | 1 | 24 | | 4 | 1 | 2 | 1 | 24 | | 5 | 1 | 3 | 1 | 24 | | 6 | 1 | 4 | 1 | 24 | | 7 | 1 | 2 | 1 | 24 | | 8 | 1 | 3 | 1 | 24 | | 9 | 1 | 2 | 1 | 14 | | 10 | 1 | 3 | 1 | 14 | | 11 | 1 | 4 | 1 | 14 | | 12 | 1 | 2 | 1 | 14 | | 13 | 1 | 3 | 1 | 14 |

CSU_KL · ‎08-27-2017

Hello all, In the attached example dataset, I want to get total min by ID. But the difficult points have two: first if the group = 0 (in white), the min will not count to the total. Second, if sub-total min of consecutive observations < 10 (in gray) where group = 1, then min will not count to the total either. So basically, I need to the total min in green by ID. Thank you very much in advance for your help! Kaigang

Online Status	Offline
Date Last Visited	‎08-28-2017 02:23 AM

Re: Collapse observations by ID as well as some conditions

Re: Collapse observations by ID as well as some conditions

Collapse observations by ID as well as some conditions

Re: Collapse observations by ID as well as some conditions

Re: Collapse observations by ID as well as some conditions

Re: Collapse observations by ID as well as some conditions

Re: Collapse observations by ID as well as some conditions

Collapse observations by ID as well as some conditions