I have three variables gender sector and wf. Gender and sector are categorical variables, where gender takes values between male and female & sector takes a value between rural and urban. wf is a binary variable which takes the value 1 if the individual is in the workforce and zero otherwise. I want to create four new variables rural_male_wf, rural_female_wf, urban_male_wf and urban_female_wf that take value from variable wf if an individual is from the rural sector and male and so on. Can someone please help me regarding the same?
clear
input str5(sector gender) float(wf rural_male_wf rural_female_wf urban_male_wf urban_female_wf)
"rural" "male" 0 0 . . .
"rural" "femal" 1 . 1 . .
"urban" "male" 1 . . 1 .
"rural" "male" 1 1 . . .
"urban" "femal" 0 . . . 0
"urban" "femal" 0 . . . 0
"rural" "femal" 1 . 1 . .
"rural" "male" 0 0 . . .
"urban" "femal" 1 . . . 1
"urban" "male" 0 . . 0 .
"urban" "male" 1 . . 1 .
"rural" "femal" 0 . 0 . .
"rural" "male" 1 1 . . .
"urban" "male" 0 . . 0 .
end
Related Posts with Create new variables using two categorical variables
Panel regressions with an interaction term between a time dummy variable and a time invariant variableThis question is cross posted here: https://stats.stackexchange.com/ques...riable-and-a-t The ques…
How can i extract a portion of a string variableI was to extract the first part of a string variable. example 12.2.2 1.1.1 54.1 in these examples I …
Data Cleaning: Calculate DateHello, I have the following dataset, I need to check if drug date is done after the death date: Give…
“Smart” quotes and Stata 17A common question on Statalist results from the user copying-and-pasting into Stata a piece of code …
Help generating variables incorporating multiple conditionsHello for a bit of context here are some descriptions of the variables: ano_nac is the year the bir…
Subscribe to:
Post Comments (Atom)
0 Response to Create new variables using two categorical variables
Post a Comment