1 / 11

GINI/LISA Birth Cohort Studies Internal Record Linking For Analysis

GINI/LISA Birth Cohort Studies Internal Record Linking For Analysis. Wolfgang Lohr Helmholtz Zentrum München Institute of Epidemiology. Wesel. Leipzig. Bad Honnef. Munich. study population. GINI 2 study centers recruitment period 1995-1998 5991 newborns recruited LISA

vance
Download Presentation

GINI/LISA Birth Cohort Studies Internal Record Linking For Analysis

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. GINI/LISA Birth Cohort StudiesInternal Record Linking For Analysis Wolfgang Lohr Helmholtz Zentrum München Institute of Epidemiology

  2. Wesel Leipzig Bad Honnef Munich study population GINI • 2 study centers • recruitment period 1995-1998 • 5991 newborns recruited LISA • 4 study centers • recruitment period 1997-1999 • 3097 newborns recruited

  3. study objectives • development of atopic diseases • development of the immune system • growth and obesity • metabolic and inflammatory markers • pre- and postnatal environmental exposure • genetic predisposition • lifestyle factors • nutrition

  4. collected data

  5. SAS .csv/.txt Access Excel source data – intial situation • non-uniform data sources and formats • different file locations • different file versions • considerable effort to create a subset of data for analysis • modifications/corrections can hardly be achieved

  6. SAS .csv/.txt Access Excel coding labels standardised data 1

  7. standardised data 2 • conversion to a uniform data format (Access) • plausibility checks of master data (ID, date of birth, sex) • harmonization of variable names/coding

  8. export of linked datasets (user form) • list of all variables (sort/filter option) • fast access to original datasets • save/load user-defined variable sets • view information on single variables (frequency table/summary statistics)

  9. export of linked datasets (result) • csv-file with actual data • script to import csv-file into SAS • script to apply SAS-formats • variable description/code book

  10. record linkage with google maps 1 features: • check addresses for correct spelling • complete missing address information • uniform address format • geocoding

  11. record linkage with google maps 2 concerns: • googles’ “collection mania”: do they use the sent addresses? • limit of 2500 addresses/day • free use of google maps geocoding data only for publication in google maps(http://code.google.com/intl/en/apis/maps/terms.html) technical documentation: • http://code.google.com/intl/en/apis/maps/documentation/geocoding implementation with ms access: • www.access-im-unternehmen.de/746

More Related