Re: Outbreak analysis diary - attack rate table
thanks very much Jens, Hans and Jamie for the suggestions and Alistair for the encouragement. Hans thanks I tried your suggestion for the browse and it worked well. The other suggestions will take a bit longer to work through. I will report back when I do but this post I want to report on the analysis and also the success of creating and combining two data entry files.
Attack rate table of exposures As has been said several times on this list but is worth saying again, the 'outbreak analysis' function in Epidata that creates a single attack rate table showing attack rates, relative risks, CIS and pvalues of all exposures of interest against the outcome of 'case' is a wonderful feature. The command is TAB CASE .....all exposures of interest/OA
The steps I took were: 1. Click on Browse Data from the menu bar 2. Tick my outcome of interest (Case) and all my exposures of interest (foods etc) 3. Click on Paste (this copies all the selected variables into the section at the bottom of the output screen) 4. I then copied this line into the programme editor, took out the browse at the start and added/OA at the end as below:
TAB CASE ANYFOOD COURTL1 COURTL2 JUNGLEPLAY JTOILET BTOILET KIOSK M1NUGGETS M2CHEERIOS M3CHIPS M4SAUCE M5PIZZA M6JUICE M7JELLYICE M8YOGURT M9CHOCCRAC M10CAKE M11LOLLIES M12TEA M13COFFEE M14SAV M15SAND M16HOTDOG M18FISHBIT M19FISHFIL M20FRUITSA M21DANISH M22BURGER/OA
Note: Adding EX after OA gives the pvalue
I then selected run programme - this creates the attack rate table in the output screen, and also in the default output file.
I really like the outbreak analysis feature but on my wish list would be 1. for 'outbreak analysis' to be an option in one of the menus somewhere. I only knew about this feature through someone mentioning it on the list and I had to search through the docuentation to find it. Maybe this was what the 'attack rate plus RR' option was but I could not seem to select this - it stayed greyed out. 2. If a select' has been used for this to show above the attack rate table. I ran the outbreak analysis above again but this time selecting only people who had attended the centre on a certain date. The command I used was Select Day25 = TRUE
I know the select has worked because N has gone down from 251 to 66, but there is no indicaiton on the output file or the information under the attack rate table that a 'select' is in place.
Thank you all again for your feedback on these postings. I will do one maybe two more - covering the process of sending the data output to a report and a final summary of the main steps and final programme I used.
Christine
Having more than one data entry file
We ended up with 250 questionnaires so decided we would try using several data entry operators to enter the data
Christine Roseveare Analyst Regional Public Health 570 9194 027 495 9671
epidata-list@lists.umanitoba.ca 6/06/2008 8:56 a.m. >>>
Dear Christine:
Just a quick comment on BROWSE.
Did you use the command:
set display databrowser=on
before issuing the BROWSE field1 field2 command? The default is that the browser is off. Note that this works fine with the public release version, but if you experiment withe (marvelous) test version build 134, there seems to be some hickup that occasionally blocks the program, but I believe to have noted that it works if the command is in the beginning of the program before reading the file (not yet certain).
In any case, I appreciate your telling us your experiences, they are useful for many. Apologies for not taking the time to answer to more of your queries, but I am currently a bit taken with traveling between continents.
Regards,
Hans
epidata-list@lists.umanitoba.ca wrote:
The TAB menu for outbreak analysis is "Compact". Then you can choose OR or RR & Attack Rates. It will let you select all of the exposures using check boxes.
Have you clicked on the Editor button and then chosen "Insert History"? This is the easiest way to create a .PGM file.
For multiple data sets (we do this every year in our Field Epidemiology Course), you can use Merge in EpiData Entry or just READ multiple data sets on one line in Analysis and then SAVEDATA.
Jamie
Christine wrote:
participants (1)
-
epidata-list@lists.umanitoba.ca