The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in Stata » CSPro and Select Utility tools
CSPro and Select Utility tools [message #1718] Wed, 02 April 2014 00:43 Go to next message
malayaka is currently offline  malayaka
Messages: 18
Registered: March 2014
Member
Hi,

I am attempting to use the Select Utility tool to extract select variables from the Kenya 2010 DHS. However, it seems I will need to use CSPro to convert it to the format that Select Utility uses. Can someone please walk me through how to go about doing this?

Any help would be appreciated.

Thank you!
Re: CSPro and Select Utility tools [message #1727 is a reply to message #1718] Wed, 02 April 2014 10:01 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1643
Registered: February 2013
Senior Member
The purpose of the SELECT program is to use the SPSS (.SPS) or Stata (.DCT) data definition produced by CSPro, with a user defined list of variables, to create a new (subset) SPSS or Stata data definition. To run SELECT, you will need to download the "Flat Data", which will include the following files: *.DAT/*.SPS/*.DO/*.DCT.

Select does not work with the system data files (.SAV or .DTA). Following are some quick steps on using SELECT:

1. Open SELECT.
2. On the menu, click on "File", and then open the data definition file: .DCT or .SPS
3. Wait while the program checks the data definition file for duplicates
4. Select/highlight the variables of interest on the left panel
5. Click on the "right" pointing arrow in the menu toolbar to transfer your variables of interest to the right panel
6. Click on the "red" GO button in the menu toolbar, to create the new data definition file(s)
7. Select the path and name for the new data definition file(s)
8. Exit the SELECT program. You may save your list of variables in a parameters file, for future use with other surveys.
9. Now run your new data definition on the .DAT file.

I hope this helps.

Bridgette-DHS

[Updated on: Wed, 04 February 2015 09:13]

Report message to a moderator

Re: CSPro and Select Utility tools [message #1730 is a reply to message #1727] Wed, 02 April 2014 10:19 Go to previous messageGo to next message
malayaka is currently offline  malayaka
Messages: 18
Registered: March 2014
Member
Thank you for your reply!

It was my understanding that I need to use CSPro first to convert the STATA files into a format that SELECT can read? Can you give guidance on how I can use CSPro? When I open CSPro it asks whether I want to create a new application or open an existing one. Then when I select "create a new application" it prompts me to select either a Data Entry Application, Batch Edit Application or Tabulation Application? I merely want to covert or reformat the STATA files I downloaded (Kenya DHS 2010) into CSPro so I can use the Select Utility. Any guidance on how to do this would be appreciated.


Thank you in advance.

- Jessica
Re: CSPro and Select Utility tools [message #1731 is a reply to message #1730] Wed, 02 April 2014 10:26 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1643
Registered: February 2013
Senior Member
You do not need CSPro to use SELECT.

The files you download from our website were produced using CSPro, so they provide you with the files needed for SELECT: (.dat, .do, .dct) or (.dat .sps) - see my earlier post.

Thanks,

Bridgette-DHS
Re: CSPro and Select Utility tools [message #1732 is a reply to message #1731] Wed, 02 April 2014 10:29 Go to previous messageGo to next message
malayaka is currently offline  malayaka
Messages: 18
Registered: March 2014
Member
Oh I see. My apologies. I did not catch that. I will give it a try!

Thank you!!
Re: CSPro and Select Utility tools [message #1733 is a reply to message #1732] Wed, 02 April 2014 10:32 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1643
Registered: February 2013
Senior Member
No problem, and you're welcome. Please let us know if you run into problems using the SELECT utility.

Bridgette-DHS
Re: CSPro and Select Utility tools [message #1737 is a reply to message #1731] Wed, 02 April 2014 11:18 Go to previous messageGo to next message
malayaka is currently offline  malayaka
Messages: 18
Registered: March 2014
Member
Hi Bridgette,

Apologies for the multiple inquiries.

I downloaded the Individual Recode zip file for Malawi 2010 DHS. The folder contained these files:
MWIR61FL.DOC
MWIR61FL.DTA
MWIR61FL.FRQ
MWIR61FL.FRW
MWIR61FL.MAP

The same goes for the Male Recode zip file.

Yet none of these formats works with the Select Utility tool. I'm using STATA and would need the files to be in DAT format (I think?). Please help!

Best,

Jessica
Re: CSPro and Select Utility tools [message #1740 is a reply to message #1737] Wed, 02 April 2014 11:22 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1643
Registered: February 2013
Senior Member
Please read the instructions carefully - it directs you to download the "Flat Data", but you have downloaded the "Stata System File".

Thanks,

Bridgette-DHS
Re: CSPro and Select Utility tools [message #1746 is a reply to message #1740] Wed, 02 April 2014 11:43 Go to previous messageGo to next message
malayaka is currently offline  malayaka
Messages: 18
Registered: March 2014
Member
Oh my. My mistake. I am so sorry. This is not my expertise by a long shot, so I truly apologize. Yes, got it to work! Thank you!

Another question, will I need to do weights on STATA 11.2 for these (ie. will I need to download the sample weight variable "v005") for simple crosstabs? If so, would you happen to know what the STATA code I need? Is it:

generate wgt = v005/1000000
tab v005 [iweight=wgt]

When I run this on STATA, I do not get the same outputs for my cross tabs as the outputs on the DHS. For instance:

Percent of youth ages 20-24 who control their own cash earnings
DHS: Females (35.2%); Males (47.9%)
STATA 11.2: Females: 34.36%; Males (50%)

Any thoughts why?


Thank you again for all your help.
Re: CSPro and Select Utility tools [message #1749 is a reply to message #1746] Wed, 02 April 2014 11:52 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1643
Registered: February 2013
Senior Member
It's good to hear that you got SELECT to work.

Regarding your additional question, you already have it in another posting (msg_1717) and we will respond to it there.

Thanks,

Bridgette-DHS

[Updated on: Wed, 02 April 2014 11:53]

Report message to a moderator

Re: CSPro and Select Utility tools [message #17561 is a reply to message #1718] Tue, 16 April 2019 02:20 Go to previous messageGo to next message
Ajay is currently offline  Ajay
Messages: 2
Registered: April 2019
Member
Dear DHS expert

Can you share CSpro dictionary and application file
Re: CSPro and Select Utility tools [message #17562 is a reply to message #17561] Tue, 16 April 2019 06:28 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1643
Registered: February 2013
Senior Member
The files you downloaded include the CSPro dictionary - please look for the file with the .dcf extension. Regarding the "application file", it's unclear what you are referring to.
Re: CSPro and Select Utility tools [message #17568 is a reply to message #17562] Wed, 17 April 2019 10:19 Go to previous message
Ajay is currently offline  Ajay
Messages: 2
Registered: April 2019
Member
Dear sir thanks for kindly response

Actually I want data entry file and capi file of CSrpo
Previous Topic: hypertension
Next Topic: Postnatal care of mother and newborn
Goto Forum:
  


Current Time: Fri Jul 19 21:48:36 Eastern Daylight Time 2019