The DHS Program User Forum: Dataset access » Unable to extract data using select Utility Tool

Home » Data » Dataset access » Unable to extract data using select Utility Tool

Show: Today's Messages :: Show Polls :: Message Navigator

Unable to extract data using select Utility Tool [message #4334]

Fri, 08 May 2015 19:12

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

Report message to a moderator

Re: Unable to extract data using select Utility Tool [message #4352 is a reply to message #4334]

Mon, 11 May 2015 10:31

Bridgette-DHS
Messages: 3216
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.

Report message to a moderator

Re: Unable to extract data using select Utility Tool [message #4378 is a reply to message #4352]

Sat, 16 May 2015 15:57

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.

Report message to a moderator

Re: Unable to extract data using select Utility Tool [message #4388 is a reply to message #4378]

Mon, 18 May 2015 12:56

Bridgette-DHS
Messages: 3216
Registered: February 2013

Senior Member

You are welcome.

Report message to a moderator

Previous Topic:	Ethiopian 2011 DHS dataset
Next Topic:	DHS Kids File Question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Jan 2 22:50:01 Coordinated Universal Time 2025