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
Collinearity issue for difference-in-differenceHello, I am trying to obtain signficance levels for a synthetic control method (SCM) result that I …
Summation of data before and after an event (dummy variable)Hi fellow experienced researchers and STATA users, I am trying to find the summation of a variable …
CRSP Wharton ResearchHi guys, I know this thread is kind of offtopic, but I think my chance is quite hight to get an ans…
How to get residuals returned after a rolling window by groups regression?Hello all! I've got a panel data with variables: firmid, year, and rdexpenditure. I want to get th…
"matsize too small" for logistic regressionsHello all! I am running a logistic regression by including fixed effects. The code I use is as foll…
Subscribe to:
Post Comments (Atom)
0 Response to Create new variables using two categorical variables
Post a Comment