Hi Everyone,

I am working with a dataset that has foloowing varibales:

1) mrn (unique identifier)
2) x_status (unique for each mrn)
3) l1 (treatment line)
4) rx1-rx5 (treatments under each line)

I would like to tabulate counts of x_status but don't want to count repetetive values across each mrn.
.
Any help would be great!

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input long mrn float x_status_final byte(l1 rx___1 rx___2 rx___3 rx___4 rx___5)
 513168 2 3 1 0 0 0 0
 513168 2 4 0 0 0 0 1
1094887 2 3 0 0 0 1 0
1248087 2 3 0 0 0 1 0
1978535 2 3 0 0 0 0 1
1978535 2 4 0 0 0 1 0
1978535 2 5 0 0 0 0 0
1978535 2 6 0 0 0 0 0
2167534 2 3 0 0 0 0 0
2167534 2 4 0 0 0 0 0
2167534 2 5 0 0 0 0 1
2414191 2 3 0 0 0 1 0
2547115 2 3 0 0 0 0 0
2547115 2 4 0 0 0 0 0
2547115 2 5 0 0 0 0 0
2547115 2 6 0 0 0 0 0
3190469 2 3 0 0 0 0 1
3756996 2 3 0 0 0 0 0
3756996 2 4 1 0 0 0 0
3756996 2 5 0 0 0 0 1
3877198 2 3 0 0 0 1 0
3877198 2 4 0 0 0 0 1
3877198 2 5 0 0 0 0 1
3877198 2 6 0 0 1 0 0
3936622 2 3 0 0 0 1 0
4160321 2 3 0 0 0 1 0
4231270 2 3 0 0 0 0 1
4272878 2 3 0 0 0 0 1
4272878 2 4 1 0 0 0 0
4272878 2 5 0 0 1 0 0
4272878 2 6 0 0 0 0 0
4272878 2 7 0 0 0 0 0
4299731 2 3 0 0 1 0 0
4733234 2 3 0 0 0 0 0
4733234 2 4 1 0 0 0 0
4733234 2 5 0 0 0 1 0
4983425 2 3 0 0 0 0 0
4983425 2 4 0 0 0 1 0
4983425 2 5 0 0 1 0 0
4983425 2 6 0 0 0 0 0
4983425 2 7 0 0 0 0 0
4983425 2 8 0 0 0 0 0
4983425 2 8 0 0 0 0 0
4983425 2 8 0 0 0 0 0
5041702 2 3 1 0 0 0 0
5041702 2 4 0 0 0 0 0
5041702 2 5 0 0 0 1 0
5041702 2 6 0 0 0 0 0
5157409 2 3 0 0 0 0 0
5746698 2 1 0 0 0 0 0
5783717 2 3 0 0 0 0 0
6321418 2 3 0 0 0 0 0
6321418 2 4 0 0 0 0 0
6565014 2 3 1 0 0 0 0
6565014 2 4 0 0 0 1 0
6565014 2 5 0 0 1 0 0
6662902 2 3 0 0 1 0 0
6662902 2 4 0 0 0 0 0
6670822 2 3 1 0 0 0 0
6699946 2 3 1 0 0 0 0
6699946 2 4 0 0 0 1 0
6733562 2 3 0 0 0 0 1
6733562 2 4 0 0 0 1 0
6733562 2 4 0 0 1 0 0
6733562 2 6 1 0 0 0 0
6733562 2 7 0 0 0 0 0
7383193 2 3 0 0 0 1 0
7388762 2 3 0 0 0 0 0
7388762 2 4 0 0 0 0 0
7388762 2 5 0 0 0 0 0
7388762 2 6 0 0 0 0 0
7536212 2 1 0 0 0 0 0
7857667 2 3 0 0 0 0 0
7898976 2 3 0 0 0 1 0
7898976 2 4 0 0 0 0 0
7970247 2 3 0 0 0 0 0
8015810 2 3 0 0 0 0 1
8015810 2 4 0 0 1 0 0
8088858 2 3 0 0 0 0 0
8162430 2 3 0 0 0 0 0
8162430 2 4 0 0 0 0 1
8495798 2 3 1 0 0 0 0
8598344 2 3 0 0 0 1 0
8598344 2 4 0 0 0 0 0
8688186 1 3 0 0 0 1 0
8688186 1 4 0 0 1 0 0
8688186 1 5 0 0 0 0 0
8688186 1 6 0 0 0 0 0
8688186 1 7 0 0 1 0 0
8845307 2 3 0 0 0 0 0
8845307 2 3 0 0 0 1 0
8849788 2 3 0 0 0 0 1
9179607 2 3 0 0 0 0 0
9179607 2 3 0 0 0 0 1
9179607 2 4 0 0 0 0 0
9281544 2 3 0 0 0 0 0
9281544 2 4 0 0 0 0 0
9281544 2 5 0 0 0 0 0
9281544 2 6 0 0 0 0 0
9342528 2 1 0 0 0 0 0
end
Anindit Chhibber