How can I count the number of episodes per patID? And tag only one of the observations, per episode, per patID?
I would like to have something like
patID 76779 episodes:2, tot_dose in episode 1: 50, tot_dose in episode 2: 50.
patID 76812 episodes: 1, ttot_dose in episode 1: 250
patID 77072 episodes: 2, tot_dose in episode 1: 100, tot_dose in episode 2: 200
I would like to have something like
patID 76779 episodes:2, tot_dose in episode 1: 50, tot_dose in episode 2: 50.
patID 76812 episodes: 1, ttot_dose in episode 1: 250
patID 77072 episodes: 2, tot_dose in episode 1: 100, tot_dose in episode 2: 200
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input long patID float(date med1 dose gap episode tot_dose) 76779 19058 1 50 . 1 50 76779 21626 1 50 2568 2 50 76796 19109 1 50 . 1 50 76804 21509 1 50 . 1 50 76806 20612 1 50 . 1 100 76806 20685 1 50 73 1 100 76812 19108 1 50 . 1 250 76812 19197 1 50 89 1 250 76812 19319 1 50 122 1 250 76812 19423 1 50 104 1 250 76812 19696 1 50 273 1 250 76837 19709 1 50 . 1 50 76911 20403 1 50 . 1 200 76911 20458 1 50 55 1 200 76911 20511 1 50 53 1 200 76911 20581 1 50 70 1 200 77072 20485 1 50 . 1 100 77072 20544 1 50 59 1 100 77072 21565 1 50 1021 2 200 77072 21595 1 50 30 2 200 77072 21862 1 50 267 2 200 77072 21875 1 50 13 2 200 77103 19355 1 50 . 1 100 77103 19425 1 50 70 1 100 77103 20381 1 50 956 2 200 77103 20441 1 50 60 2 200 77103 20597 1 50 156 2 200 77103 20780 1 50 183 2 200 77516 19086 1 60 . 1 120 77516 19107 1 60 21 1 120 77675 20170 1 50 . 1 100 77675 20251 1 50 81 1 100 77745 21265 1 50 . 1 50 77745 21803 1 50 538 2 50 77906 19149 1 50 . 1 100 77906 19286 1 50 137 1 100 77930 21346 1 50 . 1 250 77930 21428 1 50 82 1 250 77930 21503 1 50 75 1 250 77930 21566 1 50 63 1 250 77930 21632 1 50 66 1 250 77939 19976 1 50 . 1 50 78173 20801 1 60 . 1 60 78624 19607 1 60 . 1 110 78624 19767 1 50 160 1 110 78624 21909 1 50 2142 2 50 78663 20045 1 50 . 1 50 78663 21256 1 50 1211 2 100 78663 21365 1 50 109 2 100 end format %td date
Comment