REDATAM+SP as a tool for data processing, analysis and dissemination

1. REDATAM+SP as a tool for data processing, analysis and dissemination 56th Session of the ISI, International Statistical Institute Lisbon, Portugal, August 2007 Alejandra Silva CELADE- Population Division of ECLAC, United Nations (1957 – 2007)

2. What is Redatam? • It’s a database management tool that administrates large volumes of census microdata with hierarchical (geographical) structure down to the smallest area of the census exercise (city blocks) • Facilitates the data processing for small areas • How? • by facilitating the NSO the creation of an encrypted database which could be provided to third parties taking into account confidentiality issues • by providing the NSO’s themselves and the end users with a user friendly and fast software for processing large volumes of data, particularly for small areas

3. What is Redatam? • It was originally (early eighties) developed at CELADE (Latin American Demographic Center/Population Division of ECLAC, United Nations) to promote access to census micro data. • The development of REDATAM was supported mainly by IDRC, CIDA, IDB and UNFPA. REDATAM: REtrieval of census DATa for small Areas by Microcomputers

4. Which data can be used with Redatam? • Currently, all data sources can be imported into Redatam • - Population, agricultural, and economic censuses • - Vital statistics • - Household and fertility surveys • - Educational and health statistics • - Trade & commerce data, etc.

5. Characteristics of REDATAM • User friendly software • Administrates Hierarchical databases • Data stored in internal (encrypted) format (no access to individual or household records) • Highly Compressed database • Fast data processing • Multisectoral databases (combining several databases) • User can define geographical area to be processed

6. Country Province Municipality . . . Block Dwelling Household Person Hierarchical Structured Database

7. Characteristics of REDATAM • Exportation of (aggregated) results to other software (Excel, ASCII, GIS) • Thematic mapping & Graphs • External data in dbf format can be accessed • On-line Help • Dissemination of Applications on CDs (xPlan) for interactive processing with the microdata as well as aggregated data. • On-line data processing (Redatam WebServer) • Available in English, Portuguese, French and Spanish

8. Create Process REDATAM+SP FAMILY EIM & EIF Demographic modules GINI module WebServer xPlan

9. Redatam+SP xPlan Applications • Redatam+ SP Stand Alone applications for population analysis • Redatam+SP xPlan applications for population data dissemination

10. Redatam Applications for Population Analysis • The Redatam+Sp EIM and EIF Demographic Modules facilitates the indirect estimation of mortality and fertility (stand alone applications) • The Redatam+Sp GINI module designed for the estimation of inequality measures (Gini, Theil and other indicators)

11. Indirect Mortality Estimation(Redatam+SP EIM) • Was developed to calculate child and infant mortality rates using the Brass method. • This method uses census microdata to indirectly estimate the mortality rate by utilizing survival information derived from the difference between the total number of children born alive and the number of children presently alive. • This information can be obtained from all population censuses or from specific health surveys in all the countries.

12. Indirect Mortality Estimation(Redatam+SP EIM) • The Brass Method to study the fertility and mortality of a population • This method requires the following variables: • Number of women by 5 years age groups, between 15 and 49 years (total, women without declaration of children ever born, and/or children missing); • Number of children ever had, classified by the mother’s age group. • Number of children surviving, classified by the mother’s age group

13. Indirect Mortality Estimation(Redatam+SP EIM) • The Redatam+SP EIM module requires in the first place completing a parameters file named “EIM.inl”

14. Indirect Mortality Estimation(Redatam+SP EIM) • In the case of Brazil, 1991 and 2000, the mortality rates for every female cohort were estimated using the entire database and also a control variable was introduced for households to segregate according to socioeconomic quintiles. • In both cases, a weight was used because this census micro data correspond to a 10% sample of the population. • Once all the parameters are defined in the EIM.inl file, we are ready to run the Redatam+SP EIM module.

15. Indirect Mortality Estimation(Redatam+SP EIM) Main window with the basic parameters used to run the model

16. Output window with the mortality rates for each female cohort, for Brazil census1991and 2000. The mean parity P(i), that is, the average number of children that women in each group of age ever had. A woman aged 45-49 at the end of her reproductive life has had an average of 4.22 children according to the 1991 census and 3.39 children according to the 2000 census

17. Infant mortality rate calculation by Quintiles Brazil, 1991 census • The Brass technique (using the Coale-Trussel variant) is utilized. Then, the q(x) values are interpolated into the West family of the model life tables of Coale & Demeny (column 9) and the corresponding mortality rates - q(1) and q(5) values are obtained.

18. Infant mortality rate calculation by Quintiles Brazil, 1991 and 2000 census • Brazil has reduced its infant mortality rate significantly in the last few years. • But still there are differences between social groups as shown in the table by differences (variation) among quintiles.

19. With the development of this IMIS tool, CELADE is collaborating with the countries to get and process population information, to measure the indicators, to archive it, and to disseminate it.

20. CELADE, Population Division of ECLAC celebrates this year its 50th anniversary. And will continue giving support to all countries in Population & Development issues. Thank you!

21. Redatam xPlan Applications for Microdata Dissemination • Special applications can be developed by data owners to disseminate their data (for example on CDs) using microdata or aggregated data. • Easy and friendly interface; without programming. • Options of tabulations and processes are defined by the user • Allows to process predefined indicators. Allow for graphing and thematic mapping. • Several applications have been undertaken with Census data, vital statistics, industrial census, agricultural census, trade statistics.

22. Census microdata dissemination on CD’s • Several countries in Latin America have distributed CDs to each municipality or province with the census data of their own territory. Or as Cambodia did with the 1998 census. • Advantage: end user does not require training, only a demonstration might be necessary. • End users don’t have access to the microdata (encrypted database) • The Distribution CD can include the Redatam xPlan interface only. • However it is recommended to allow data processing with the Redatam PROCESS module (which might require some training) • Level of geographical access can be defined by the NSO (and might differ according to the characteristics of the end user).

23. Costa Rica census dissemination From the main screen you can access several census databases

24. The table of contents

25. Chile census dissemination • This is the main screen of the CD with options to access the: • Interactive Processing module, • The Redatam Statistical Process module, • The documentation or • Exit

26. Redatam+SP WebServer • Processing census data on line (via intranet or internet) has several advantages: • Complete control of access (variables, geographical level, number of cases in cells) by NSO • Intranet: speed of data processing depends on the server and not of the PC of the user • If there are changes in the data file, only the file on the server has to be replaced • Allows to create a databank from different sources • No access to microdata (copying is not possible) • Control of users