The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Data » Dataset access » Unable to extract data using select Utility Tool
Unable to extract data using select Utility Tool [message #4334] Fri, 08 May 2015 19:12 Go to next message
ahmed is currently offline  ahmed
Messages: 2
Registered: May 2015
Member
Hi,
I have a problem with data extraction using the 'SELECT' software: I selected some variables into the right hand side panel of the software and then tried saving them into an SPSS file by pressing the GO button of the tool bar. Two SPSS files were produced (an SPSS Statistic Syntax File and an SPSS Statistics Data Document). The former contains a list of my selected variables while the latter is empty. I assume the Syntax File is my data definition file so I tried running it on the .DAT file but I discovered that the .DAT file actually contains a VLC Media Player which has 7 options: Media, Playback, Audio, Video, Tools, View and Help. How do I run the Syntax file in the VLC Player? I don't know what I am doing wrong. Kindly advice.
Regards,
Ahmed
Re: Unable to extract data using select Utility Tool [message #4352 is a reply to message #4334] Mon, 11 May 2015 10:31 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1161
Registered: February 2013
Senior Member
Using EGKR61FL.ZIP as our example:

Extract the .dat and the .sps files from the zip. Run the SELECT utility, select the variables of interest in the left panel, then click "GO" to create your new syntax file. Give it any name, e.g. newdata.sps. Open the newdata.sps in SPSS, and run it on the original .dat file: EGKR61FL.DAT. You might need to modify the path in line 1 of newdata.sps. This should create your new dataset.

Please note that EGKR61FL.DAT is the Hierarchical ASCII data (not a VLC Media Player file).

You can post again if you still have problems.
Re: Unable to extract data using select Utility Tool [message #4378 is a reply to message #4352] Sat, 16 May 2015 15:57 Go to previous messageGo to next message
ahmed is currently offline  ahmed
Messages: 2
Registered: May 2015
Member
Dear Bridgette,
Thanks for the response. I was able to extract the data after reading your response.I realized the mistake I made was trying to run the syntax file in the .dat file contained in the Flat ASCII data instead of the one contained in the Hierarchical ASCII data.

Regards,
Ahmed.
Re: Unable to extract data using select Utility Tool [message #4388 is a reply to message #4378] Mon, 18 May 2015 12:56 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1161
Registered: February 2013
Senior Member
You are welcome.
Previous Topic: Ethiopian 2011 DHS dataset
Next Topic: DHS Kids File Question
Goto Forum:
  


Current Time: Mon Dec 11 06:16:02 Eastern Standard Time 2017