Hi, I have a dataset "Reproduction" with data from artificial inseminations(AI) in animals during 1 oestrous period. Data Reproduction ID AI1 AI2 AI3 AI4 AIn 1 B2 B2 B1 B2 4 2 B1 B1 B1 . 3 3 B1 B3 B3 B3 4 4 B2 B2 B2 . 3 5 B1 B1 . . 2 ...(5400 obs) The values "B1, B2 or B3" are male ID. I want to know if inseminations are with same male (event '1') or different male (event '0'), like this: Data Reproduction ID AI1 AI2 AI3 AI4 AIn Want 1 B2 B2 B1 B2 4 0 2 B1 B1 B1 . 3 1 3 B1 B3 B3 B3 4 0 4 B2 B2 B2 . 3 1 5 B1 B1 . . 2 1 ...(5400 obs)
... View more