Thank you so much for sharing this code and it works great 🙂 ! ... View more

It is calculated as the number of days since the cohort entry year until last day of follow up for each person, and then summed up for all persons in each year. So I'm wondering, first, how do I aggregate the total persons each year so I get a year-level dataset. ... View more

Hello, Please I need help with my data structure and calculating adjusted incidence rate with CI to output on a linear trend graph. Please see below for my current data structure which is a unique ID level dataset with millions of records: ID           YEAR          EVENT     FOLLOW-UP 1              2006             1                    50 2              2006             0                   100 3              2014             1                    60 4              2006             1                    20 5              2011              1                  110 6              2006              0                  10 7              2008              1                  150 Below is the dataset I want in order to calculate incidence rate per person-time (i.e. follow-up x # of persons), including 95% CIs with Poisson regression: YEAR    # OF PERSONS      EVENT    PERSON-TIME 2006               4                        2                    720 2008               1                        1                   150 2011               1                         1                   110 2014               1                         1                   60 Please any help with this and how to output the incidence rate and 95% CI unto a linear trend line plot (x-axis= year and y-axis = incidence rate).   ... View more

Thanks all for your thoughtful response to my questions. Much appreciated! ... View more

Unfortunately, using the anonymized IDs is not possible. They are continuous variables and I want to match at least means and variances, and show a similar association with other variables in the dummy data set like odds ratio, as would be expected if using the original data set. ‘Close’ Shouldn’t be exactly the same but realistic enough to an ordinary eye. Any more thoughts? Thanks much! ... View more

Sorry, I should be more clear... so let's say you know the variables and metadata of the original data set or have confidential information in the original data set that prevents you from sharing the results, how can one generate a dummy data set that mimics the structure of the original data set given the limited information on the original data set that one knows. Thanks in advance. ... View more