I am trying to analyze some data on blood unit age and usage, and am having problems figuring out the code for what I want to do!
I have Blood unit number, Patients name, the age of the RBC unit
Some people got more than one unit.There names are duplicated each time they receive a unit of blood, beside that new units number. So some people have their names entered more than once.
Because I am analyzing this by age of unit, I want to exclude people that received more than one unit of blood with different ages (ie its ok if they got two units that are both 'new' but not ok if they got one that is 'new' and one that is 'old', I want to delete them)
I want to create a variable that is '1' for people with blood all of the same age, 0 for those that received mixed blood.
Any ideas??