The DHS Program User Forum: Dataset use in Stata » CSPro and Select Utility tools

Home » Data » Dataset use in Stata » CSPro and Select Utility tools

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

CSPro and Select Utility tools [message #1718]

Wed, 02 April 2014 00:43

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!

Report message to a moderator

Re: CSPro and Select Utility tools [message #1727 is a reply to message #1718]

Wed, 02 April 2014 10:01

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

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

Report message to a moderator

Re: CSPro and Select Utility tools [message #1731 is a reply to message #1730]

Wed, 02 April 2014 10:26

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

Report message to a moderator

Re: CSPro and Select Utility tools [message #1732 is a reply to message #1731]

Wed, 02 April 2014 10:29

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!!

Report message to a moderator

Re: CSPro and Select Utility tools [message #1733 is a reply to message #1732]

Wed, 02 April 2014 10:32

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

Report message to a moderator

Re: CSPro and Select Utility tools [message #1737 is a reply to message #1731]

Wed, 02 April 2014 11:18

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

Report message to a moderator

Re: CSPro and Select Utility tools [message #1740 is a reply to message #1737]

Wed, 02 April 2014 11:22

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

Report message to a moderator

Re: CSPro and Select Utility tools [message #1746 is a reply to message #1740]

Wed, 02 April 2014 11:43

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.

Report message to a moderator

Re: CSPro and Select Utility tools [message #1749 is a reply to message #1746]

Wed, 02 April 2014 11:52

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

Ajay
Messages: 2
Registered: April 2019

Member

Dear DHS expert

Can you share CSpro dictionary and application file

Report message to a moderator

Re: CSPro and Select Utility tools [message #17562 is a reply to message #17561]

Tue, 16 April 2019 06:28

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

Report message to a moderator

Re: CSPro and Select Utility tools [message #17568 is a reply to message #17562]

Wed, 17 April 2019 10:19

Ajay
Messages: 2
Registered: April 2019

Member

Dear sir thanks for kindly response

Actually I want data entry file and capi file of CSrpo

Report message to a moderator

Previous Topic:	hypertension
Next Topic:	Postnatal care of mother and newborn

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Dec 26 23:11:35 Coordinated Universal Time 2024