The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use (other programs) » importing data to PSSP which is similar to SPSS
importing data to PSSP which is similar to SPSS [message #18154] Mon, 30 September 2019 16:39 Go to next message
Mariela Contreras is currently offline  Mariela Contreras
Messages: 7
Registered: September 2019
Member
Dear all,

We are analyzing data on intimate partner violence and child nutrition using the Honduras DHS 2011-12. I am having issues importing the dataset to PSSP which is a similar statistical program to SPSS. I imported the dataset file .dat and converted it to Excel CSV. However once I imported it to PSSP there are no column headers of the variables and I am unable to recognize the variables. Is there another better way to import the data? Would it be better to import the data to R?

Thank you for your support.
Re: importing data to PSSP which is similar to SPSS [message #18162 is a reply to message #18154] Wed, 02 October 2019 05:41 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 787
Registered: January 2013
Senior Member
If you convert to Excel, then yes, you will lose the labels. I haven't used PSPP for some time, but I believe that you can use the .SPS commands found in the flat ASCII format download file to import the data. You should then have a file in memory with the labels. Saving the file as an Excel CSV file you will then lose the labels. Instead, I suggest saving the file as a system file.

Alternatively, I believe that PSPP can read the ,sav files diretly, so you should be able to download the SPSS files (SV) directly, and these files include all of the labels.
Re: importing data to PSSP which is similar to SPSS [message #18164 is a reply to message #18162] Wed, 02 October 2019 20:07 Go to previous messageGo to next message
Mariela Contreras is currently offline  Mariela Contreras
Messages: 7
Registered: September 2019
Member
Thank you very much for your response Trevor. I downloaded the SPSS files directly and now I am able to see the variable labels. I have another question. If I save my files as a system file, is it possible to import these files to R to be able to run the analyses with this statistical program?

Thank you for your support.
Re: importing data to PSSP which is similar to SPSS [message #18165 is a reply to message #18154] Thu, 03 October 2019 03:18 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 787
Registered: January 2013
Senior Member
See the read.spss package in R
Re: importing data to PSSP which is similar to SPSS [message #18173 is a reply to message #18165] Thu, 03 October 2019 13:36 Go to previous message
Mariela Contreras is currently offline  Mariela Contreras
Messages: 7
Registered: September 2019
Member
Thank you for the information.
Previous Topic: Potential bias of DHS data set
Next Topic: MERGING BR,IR and HR DATA FILES IN R
Goto Forum:
  


Current Time: Thu Mar 28 20:17:24 Coordinated Universal Time 2024