The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Weighting data » Create a variable using Percentage from cross tabulation
Re: Create a variable using Percentage from cross tabulation [message #23662 is a reply to message #23655] Thu, 28 October 2021 15:41 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

What survey? What do you want to be the cases? The possibilities are households (the HR file), individuals in households (the PR file), women (the IR file), men (the MR file), or children (the KR file). The variable names for regions, the wealth quintiles, and the weights are different in different files. Apparently you are using Stata. You CAN use a full svyset command with the tab command, but the only part that actually matters for a crosstab is the weight variable, and you can include that with just the weight option.

If, say, you wanted to get the percentage distribution of households across wealth quintiles, for all regions, you could open the HR file and enter this command: "tab hv024 hv270 [iweight=hv005/1000000], row" .

 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Adjusting survey weights in melogit in Stata
Next Topic: Using Normalized Weight in Analysis
Goto Forum:
  


Current Time: Wed Nov 27 04:50:38 Coordinated Universal Time 2024