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
Reading in 10GB .csv dataset with not enough memory on my machineHello everyone, I need help reading in a 10GB .csv dataset with very limited physical memory on my c…
Changing values of two variables within one (parallel) loopDear Stata Users, as mentioned in the thread title I got a question regarding parallel looping in S…
New to stata. Need some heplHi, I am new to Stata 15 and I need some help. I have two databases (database_y and database_x). I …
methodological question: matching/imputation based on two datasetsHello, I struggle to find the right method for what I want to do using two household surveys. I hav…
Predicting Probabilities with Fixed Effects Ordered Logit ModelHello, I am looking at whether losing a partner effects an individual's political view. I have a pan…
Subscribe to:
Post Comments (Atom)
0 Response to Create new variables using two categorical variables
Post a Comment