Hi Everyone,

I am working with a datset that has following variables:

1) mrn: unique identifier
2) l1 : treatment line
3) combo_1 - combo_104: unique combination of treatment

I would liek to create a new variable that can list combo name in a coloumn.

For example,
for mrn 2167534 for l1 == 3, combo_name should be a value of 14
for mrn 2547115 for l1 ==3, combo_name should be a value of 10.

Any help would be great!

Thanks
Anindit Chhiber


input long mrn byte(l1 combo_1 combo_2 combo_3 combo_4 combo_5 combo_6 combo_7 combo_8 combo_9 combo_10 combo_11 combo_12 combo_13 combo_14 combo_15)
513168 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
513168 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1094887 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1248087 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1978535 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1978535 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1978535 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1978535 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2167534 3 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0
2167534 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2167534 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2414191 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2547115 3 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
2547115 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2547115 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2547115 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3190469 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3756996 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3756996 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3756996 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3877198 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3877198 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3877198 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3877198 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3936622 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4160321 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4231270 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4272878 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4272878 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4272878 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4272878 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4272878 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4299731 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4733234 3 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
4733234 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4733234 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4983425 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4983425 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4983425 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4983425 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4983425 7 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0
4983425 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5041702 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5041702 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5041702 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5041702 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5157409 3 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0
5746698 1 . . . . . . . . . . . . . . .
5783717 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6321418 3 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
6321418 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6565014 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6565014 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6565014 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6662902 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6662902 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6670822 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6699946 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6699946 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6733562 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6733562 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6733562 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6733562 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6733562 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7383193 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7388762 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7388762 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7388762 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7388762 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7536212 1 . . . . . . . . . . . . . . .
7857667 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7898976 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7898976 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7970247 3 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
8015810 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
8015810 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
8088858 3 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
8162430 3 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
8162430 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
8495798 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
8598344 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
8598344 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
8845307 3 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
8845307 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
8849788 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9179607 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9179607 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9281544 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9281544 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9281544 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9281544 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9342528 1 . . . . . . . . . . . . . . .
9441395 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9441395 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9555525 3 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
9555525 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9569427 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9653205 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9653205 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9653205 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
end
[/CODE]