A Stand-Alone Windows Application for Computing Exact Person-Years, Standardized Mortality Ratios and Confidence Intervals in Epidemiological Studies
Taeger, Dirk; Sun, Yi; Keil, Ulrich; Straif, Kurt
From Institute of Epidemiology and Social Medicine, University of Muenster, Germany.
Submitted December 13, 1999; final version accepted April 6, 2000.
Address correspondence to: Dirk Taeger, Institute of Epidemiology and Social Medicine, University of Muenster, Domagkstrasse 3, D-48129 Muenster, Germany.
We introduce a stand-alone and user-friendly person-years and mortality computation program (PAMCOMP) for calculating exact person-years and standardized mortality and incidence ratios running under Windows® 95/98 and NT. The calculation of person-years allows flexible stratification by self-defined and unrestricted categories of age and calendar years. Furthermore, it is possible to lag person-years to account for latency periods. The standardized mortality ratio computation includes calculation of 90%, 95%, and 99% confidence intervals. Import and export filters for standard personal computer file formats are available. The software is free of charge and can be downloaded from: http://medweb.uni-muenster.de/institute/epi/pamcomp/pamcomp.html
Standardized mortality ratio (SMR) estimation is the most commonly used effect estimation in occupational cohort studies. 1 It is usually applied to compare mortality in specific industries with mortality in national or regional reference populations, especially when numbers of observed and expected deaths were small or when detailed exposure data were unavailable. Furthermore, even if more sophisticated modeling is performed, the calculation of SMRs for major cause groups is often a first step of the analysis. Although the principle of calculating SMR is easy, its implementation is not always straightforward. The main problem is the need for a calculation of the person-year distribution of the study cohort by age and calendar years. Several computer algorithms for calculating person-years have been published, 2–6 and the increasing number of algorithms in recent years may be an indicator for the need of stable and ready-to-use person-years computer programs. Nevertheless, most of these published algorithms 3–6 were written in the SAS language 7 and the use of the programs required that both the cohort data and the algorithm were adjusted to fit each other. The latter task may have been difficult for researchers who were not familiar with the SAS language. Furthermore, some researchers routinely may use other statistical packages and, therefore, may not have an SAS license.
The person-years and mortality computation program (PAMCOMP) offers a stand-alone user-friendly and flexible program to calculate person-year distributions and standardized mortality ratios in epidemiological research. Table 1 presents the basic variables needed to perform a person-years and SMR computation using PAMCOMP. Date variables indicate the date-of birth, entry point of study (EPS), ie, individual start of follow-up, and termination point of study, ie, individual end of follow-up, which may be defined as censoring due to loss to follow-up, attainment of an upper age limit, death or end of the observation period. These values may be different for each individual cohort member and must be provided in a four-digit year format to establish year 2000 compliance.
For inception cohorts the entry point of study is usually equal to the date of hire (DOH) of the individual cohort member. Alternatively, according to the cohort definition, the entry point of study may also be 1 year (or any other specified period) after the date of hire of each cohort member. The specification of two variables, EPS and DOH, gives the opportunity to operate with start of follow-up and date of hire independently, as it may be necessary for specific time-related analyses of census cohorts. Optionally, a numeric variable can be used to stratify by sex. Moreover, this variable can also be used for other non-time-related dichotomous variables such as race, nationality, or socioeconomic status. There is also the possibility to lag person-years from date of hire to account for different latency periods, eg, if the considered outcome is cancer. Lagging is implemented such that a person’s current person-year at risk will be accounted x years after the date of hire. 8 The optional lag may be specified between 1 and 100 years.
The program will compute the exact person-year distribution of all cohort members, ie, person-days divided by 365.25, and report them in a matrix where rows represent the age categories and columns represent the calendar year groups.
Once the person-year distribution is established, the SMR can be calculated by providing a file with the death rates for the respective age and calendar distribution, and the ICD variable is needed to indicate whether a cohort member died from a specific cause of interest. Substituting incidence and incidence reference rates for mortality and mortality reference rates, respectively, the program will calculate standardized incidence ratios (SIR). The calculation of 90%, 95%, and 99% confidence intervals is based on approximations of the chi-square percentiles. 9,10 Furthermore, appropriate matrices of the distribution of deaths are provided.
PAMCOMP is written in Visual Basic® 6.0 and Visual C++® 6.0 and provides a user-friendly interface. All necessary files to run the software will be supplied; no additional run-time environment or software is required. It comes with documentation integrated as a windows help file. Major strengths of PAMCOMP in comparison with previously published algorithms and programs 2–6,11 are that PAMCOMP runs under Windows® 95/98 and NT, and supports ASCII, dBase®, Paradox®, MS-Excel®, and MS-ACCESS® file formats to import cohort and reference data and to export person-year data, death distributions, and SMR or SIR results. Stratification by age and calendar year may be done flexibly and is not restricted to equal interval length of categories of age and calendar years. A weakness of PAMCOMP in comparison with published algorithms and programs 3–4,6,11 is that time-related exposure data may not be considered in the current version, but will be implemented in an updated version.
PAMCOMP is under further development, and can be used without any fees. Exact confidence intervals for sparse cases (less than 5) and weighted SMR as well as standardized rate ratios (SRR) are under way. For interested programmers the source code is also supplied. The program is available at http://medweb.uni-muenster.de/institute/epi/pamcomp/pamcomp.html
1. Callas PW, Pastides H, Hosmer DW. Survey of methods and statistical models used in the analysis of occupational cohort studies. Occup Environ Med 1994; 51: 649–655.
2. Monson RR. Analysis of relative survival and proportional mortality. Comput Biomed Res 1974; 7: 325–332.
3. Pearce N, Checkoway H. A simple computer program for generating person-time data in cohort studies involving time-related factors. Am J Epidemiol 1987; 125: 1085–1091.
4. Macaluso M. Exact Stratification of person-years. Epidemiology 1992; 3: 441–448.
5. Sun J, Shibata E, Kamijima M, Toida M, Takeuch Y. An efficient SAS program for exact stratification of person-years. Comput Biol Med 1996; 27: 49–53.
6. Wood J, Richardson D, Wing S. A simple program to create exact person-time data in cohort analyses. Int J Epidemiol 1997; 26: 395–399.
7. SAS Institute. SAS Language: Reference. Version 6. Cary, NC: SAS Institute, 1990.
8. Checkoway H, Pearce NE, Crawford-Brown DJ. Research Methods in Occupational Epidemiology. New York: Oxford University Press, Inc., 1989.
9. Breslow NE, Day NE. Statistical Methods in Cancer Research. vol. 2. The Design and Analysis of Cohort Studies. IARC Scientific Pub. No. 82. Lyon: International Agency for Research on Cancer, 1987.
10. Sahai H, Khurshid A. Statistics in Epidemiology. Methods, Techniques, and Applications. Boca Raton: CRC Press, 1996.
11. Steenland K, Beaumont J, Spaeth S, Brown D, Okun A, Jurcenko L, Ryan B, Phillips S, Roscoe R, Stayner L, Morris J. New Developments in the Life Table Analysis System of the National Institute for Occupational Safety and Health. J Occup Med 1990; 32: 1091–1098.
This article has been cited 32 time(s).
Arthritis and RheumatismEosinophilic granulomatosis with polyangiitis (Churg-Strauss): Clinical characteristics and long-term followup of the 383 patients enrolled in the French Vasculitis Study Group cohortArthritis and Rheumatism
Psychiatry ResearchSuicide mortality and risk factors in the 12 months after discharge from psychiatric inpatient care in Korea: 1989-2006Psychiatry Research
CancerOutcomes in stage I testicular seminoma: A population-based study of 9193 patientsCancer
Alcoholism-Clinical and Experimental ResearchClinical and Laboratory Predictors of All Causes Deaths and Alcohol-Attributable Deaths Among Discharged Alcohol-Dependent PatientsAlcoholism-Clinical and Experimental Research
Computer Methods and Programs in BiomedicineA Windows application for computing standardized mortality ratios and standardized incidence ratios in cohort studies based on calculation of exact person-years at riskComputer Methods and Programs in Biomedicine
Journal of NeurologyEstimation of Parkinson's disease survival in Israeli men and women, using health maintenance organization pharmacy data in a unique approachJournal of Neurology
Journal of Clinical EpidemiologyCauses of death in obesity: Relevant increase in cardiovascular but not in all-cancer mortalityJournal of Clinical Epidemiology
Statistics in MedicineThe heritability of cause-specific mortality: a correlated gamma-frailty model applied to mortality due to respiratory diseases in Danish twins born 1870-1930Statistics in Medicine
Annals of Oncology
Second malignancies after Ewing tumor treatment in 690 patients from a cooperative German/Austrian/Dutch study
Annals of Oncology, 12():
Emerging Infectious Diseases
Long-term death rates, West Nile virus epidemic, Israel, 2000
Emerging Infectious Diseases, 11():
Social Psychiatry and Psychiatric EpidemiologyPredictors of suicide in a community-based cohort of individuals with severe mental disorderSocial Psychiatry and Psychiatric Epidemiology
Journal of Occupational Health
Asthma mortality in male workers of the dye industry in Korea
Journal of Occupational Health, 50(2):
Journal of Toxicology and Environmental Health-Part A-Current IssuesA study on lung cancer mortality related to radon, quartz, and arsenic exposures in German uranium minersJournal of Toxicology and Environmental Health-Part A-Current Issues
Biology of Blood and Marrow TransplantationLong-term survival after blood and marrow transplantation: Comparison with an age- and gender-matched normative populationBiology of Blood and Marrow Transplantation
Multiple SclerosisCancer risk and impact of disease-modifying treatments in patients with multiple sclerosisMultiple Sclerosis
Arthritis and RheumatismRisk of malignancy in scleroderma - A population-based cohort studyArthritis and Rheumatism
Occupational and Environmental MedicineCancer and non-cancer mortality in a cohort of recent entrants (1981-2000) to the German rubber industryOccupational and Environmental Medicine
CancerMortality after cure of soft-tissue sarcoma treated with conservation surgery and radiotherapyCancer
Journal of Clinical OncologyRisk of second primary malignancy after esophagectomy for squamous cell carcinoma of the thoracic esophagusJournal of Clinical Oncology
Journal of Clinical OncologyMortality after cure of testicular seminomaJournal of Clinical Oncology
Jama-Journal of the American Medical Association
History and molecular genetics of Lynch syndrome in family G - A century later
Jama-Journal of the American Medical Association, 294():
Risk AnalysisEpidemiologic Evidence for Chloroprene Carcinogenicity: Review of Study Quality and its Application to Risk AssessmentRisk Analysis
RheumatologyAge-related survival and clinical features in systemic sclerosis patients older or younger than 65 at diagnosisRheumatology
Canadian Journal of Ophthalmology-Journal Canadien D Ophtalmologie
The risk of other primary cancer in patients with uveal melanoma: a retrospective cohort study of a Canadian population
Canadian Journal of Ophthalmology-Journal Canadien D Ophtalmologie, 39(4):
International Archives of Occupational and Environmental HealthCancer incidence in the wastewater treatment plant of a large chemical companyInternational Archives of Occupational and Environmental Health
International Journal of Hygiene and Environmental HealthCancer mortality in a surveillance cohort of German males formerly exposed to asbestosInternational Journal of Hygiene and Environmental Health
Australian and New Zealand Journal of Criminology
Post-prison mortality: Unnatural death among people released from Victorian prisons between January 1990 and December 1999
Australian and New Zealand Journal of Criminology, 36(1):
Journal of Occupational and Environmental Medicine
Arsenic in drinking water and bladder cancer mortality in the United States: An analysis based on 133 US counties and 30 years of observation (J Occup Environ Med. 2004;46 : 298-306)
Journal of Occupational and Environmental Medicine, 46():
American Journal of Industrial MedicineCancer incidence and mortality in aircraft maintenance workersAmerican Journal of Industrial Medicine
Lung CancerSecondary cancers after a lung carcinoid primary: A population-based analysisLung Cancer
Environmental Health PerspectivesLung Cancer Risk in Painters: A Meta-AnalysisEnvironmental Health Perspectives
Journal of Adolescent HealthUnnatural Causes of Death and Suicide Among Former Adolescent Psychiatric PatientsJournal of Adolescent Health
epidemiologic methods; epidemiologic measurements; incidence; mortality; software; cohort studies; computation
© 2000 Lippincott Williams & Wilkins, Inc.
Highlight selected keywords in the article text.