The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Biomarkers » Data in CSV/XLSX Format
Data in CSV/XLSX Format [message #15359] Thu, 05 July 2018 01:27 Go to next message
minerva is currently offline  minerva
Messages: 3
Registered: July 2018
I have downloaded India survey data and working on analyzing it. Can anyone recommend me resources about how to deal with .dat files? I tried to see the content using python and found the content in the format as attached with this. Please anyone can help me with using .dat files? Is it a good idea to covert it and see it in xlsx/csv? Please let me know how do you deal with it?

Re: Data in CSV/XLSX Format [message #15436 is a reply to message #15359] Wed, 18 July 2018 12:39 Go to previous message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 721
Registered: January 2013
Senior Member
DHS data is designed for use with Statistical packages such as Stata, SPSS, R, or SAS. I would recommend using one of these software, and downloading the dataset appropriate for that package, rather than the file you have downloaded. It is not practical to use Excel to analyze DHS datasets.

If you haven't worked with DHS data before, I suggest that you try with a small survey first, and not the India survey datasets, as the India datasets are massive files. I also suggest that you look at our Youtube video tutorial series available at JRnCtM55C0o8 including the video Introduction to DHS datasets.
Previous Topic: Anthropometric measurements
Next Topic: Matching the sample size
Goto Forum:

Current Time: Fri Sep 25 20:28:58 Eastern Daylight Time 2020