HDSS Data Cleaning and Integration Using SAS Business Intelligence Tool

Abstract

HDSS's (Health and Demographic and Surveillance Systems) are typically structured around subjects within the DSA (Demographic Surveillance Area). These subjects have both a conceptual and a logistical rationale. Major subject areas are: birth, death, in-migration, outmigration and delivery. Field workers collect HDSS data in various points of time and feed the data into computer systems manually. Further data analysis takes place. To have a concise view about major elements data cleaning and integration are required. Due to many dimensions and large volume of data, integration is becoming a challenging issue. Researcher performs data cleaning, transformation and integration manually. Which is a time consuming task? The current paper highlights the use of Business intelligence tools (SAS) for HDSS data integration. The experiment starts with Vadu-HDSS site (which is a member of INDEPTH NETWORK, Ghana), Pune, and Maharashtra. The current paper addresses the complexities in the HDSS data Integration, implementation, advantages and results.