Dividing a variable into the categories of another variable

[Romy Suter]

Hi

I am writing a paper on the economic effects of male vs female decision making in the household. My variable for "main decision maker" simply lists the identifier numbers of those in the household who make decisions; however, I require these to be split into male and female. There is also a variable on gender which I have access to. Is it possible to change this decision-making variable into male and female? i.e. somehow using the gender variable to categorise the identifier numbers. From what I can tell, there is no pattern on the identifier numbers as to which one is male or female.

[Carlo Lazzaro]

Romy:
welcome to this forum.
I'm not totally sure of what you're after, but you may want to try:

 set obs 4
Number of observations (_N) was 0, now 4.

. g gender=0 in 1/2

. replace gender=1 if gender==.

. label define gender 1 female 0 male

. label val gender gender

. list

     +-------------------+
     | decisi~r   gender |
     |-------------------|
  1. |        1     male |
  2. |        2     male |
  3. |        3   female |
  4. |        4   female |
     +-------------------+

. g decision_maker_gender=0 if decision_maker!=. & gender==0

. replace decision_maker_gender=1 if decision_maker!=. & gender==1

. label define decision_maker_gender 1 female_decides 0 male_decides

. label val decision_maker_gender decision_maker_gender

. list

     +------------------------------------+
     | deci~ker   gender   decision_m~der |
     |------------------------------------|
  1. |        1     male     male_decides |
  2. |        2     male     male_decides |
  3. |        3   female   female_decides |
  4. |        4   female   female_decides |
     +------------------------------------+

.

[Nick Cox]

#1 is unclear to me without a data example. The data example doesn't have to be real, but it needs to be realistic.

Please read and act on 12.2 within https://www.statalist.org/forums/help#stata to give us a data example using dataex with your identifiers and your gender variable and show us what you want.

[Romy Suter]

Romy:
welcome to this forum.
I'm not totally sure of what you're after, but you may want to try:

 set obs 4
Number of observations (_N) was 0, now 4.

. g gender=0 in 1/2

. replace gender=1 if gender==.

. label define gender 1 female 0 male

. label val gender gender

. list

+-------------------+
| decisi~r gender |
|-------------------|
1. | 1 male |
2. | 2 male |
3. | 3 female |
4. | 4 female |
+-------------------+

. g decision_maker_gender=0 if decision_maker!=. & gender==0

. replace decision_maker_gender=1 if decision_maker!=. & gender==1

. label define decision_maker_gender 1 female_decides 0 male_decides

. label val decision_maker_gender decision_maker_gender

. list

+------------------------------------+
| deci~ker gender decision_m~der |
|------------------------------------|
1. | 1 male male_decides |
2. | 2 male male_decides |
3. | 3 female female_decides |
4. | 4 female female_decides |
+------------------------------------+

.

Thank you for your help Carlo, this worked for me!