Dear SAS users, I have a large dataset of children. I am looking at children’s antibiotic consumption patterns from birth up to 5 years of age. I have the following variables of children: childs_ID, date of birth, name of antibiotic ( eg. Antibiotic_A, Antibiotic_B, Antibiotic_C), date_antibiotic_dispensed. Some children have no antibiotic dispensed date which means they did not use any while many have several antibiotics. From the birth date of the child, I have created the following variables: Date_of_1st_birthday, Date_of_2nd_birthdays, Date_of_3rd _birthdays, Date_of_4th _birthdays, Date_of_5th_birthdays, Now, I'd like to create several variables for each child as follows: 1. Total counts of antibiotics per child over 5 years period 2. Number of antibiotics used in the 1st Year ( i.e between birth to the first birthday 3. Number of antibiotics used in the 2nd Year (i.e., between first birthday and 2nd birthday) 4. Number of antibiotics used in the 3rd Year (i.e., between 2nd birthday and 3rd birthday) PS: Please see attached example of dataset/ variables. I am looking forward to your kind help.
... View more