|
I have a huge immunization data set with multiple records for each client
for a variety of vaccines. I am trying to calculate
1. Count and the time (# of days) from date of birth to when the third dose
of vaccine "DaPTP" was given
2. The time (# of days) from date of birth when the first dose of vaccine
MMR was given and list those who had their first MMR at or after 590 days.
3. To create a list of cases if the second dose of Influenza was not given
with in six weeks of the first dose of Influenza.
Any help will be greatly appreciated.
Below is sample data for two clients
ID BirthDate ImmunizationDate Vaccine days
42 13/11/2008 16/01/2009 DaPTP-Hib 64
42 13/11/2008 16/01/2009 Pneumococcal 7 64
42 13/11/2008 18/03/2009 Pneumococcal 7 125
42 13/11/2008 18/03/2009 DaPTP-Hib 125
42 13/11/2008 20/05/2009 DaPTP-Hib 188
42 13/11/2008 20/05/2009 Pneumococcal 7 188
42 13/11/2008 13/05/2010 DaPTP-Hib 546
42 13/11/2008 13/05/2010 MMR 546
42 13/11/2008 13/05/2010 Pneumococcal 7 546
42 13/11/2008 09/12/2009 pH1N1 391
42 13/11/2008 06/11/2009 Influenza 368
42 13/11/2008 16/11/2009 pH1N1 368
42 13/11/2008 16/11/2009 Varicella 368
42 13/11/2008 16/11/2009 MMR 368
42 13/11/2008 16/11/2009 Meningococcal C 368
92 10/11/2008 21/03/2009 DaPTP-Hib 131
92 10/11/2008 21/03/2009 Pneumococcal 7 131
92 10/11/2008 21/03/2009 Meningococcal C 131
92 10/11/2008 21/03/2009 Hep B 131
92 10/11/2008 10/01/2009 DaPTP-Hib 61
92 10/11/2008 10/01/2009 Pneumococcal 7 61
92 10/11/2008 10/01/2009 Meningococcal C 61
92 10/11/2008 10/01/2009 Hep B 61
92 10/11/2008 31/05/2009 DaPTP-Hib 202
92 10/11/2008 31/05/2009 Pneumococcal 7 202
92 10/11/2008 15/07/2010 DaPTP-Hib 612
92 10/11/2008 15/07/2010 MMR 612
92 10/11/2008 15/07/2010 Meningococcal C 612
92 10/11/2008 15/07/2010 Varicella 612
92 10/11/2008 15/07/2010 Pneumococcal 13 612
92 10/11/2008 09/10/2010 Influenza 698
=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
| 
