Creating a New Variable Dependent on Gender

[JR Rea]

CODE]
* Example generated by -dataex-. For more info, type help dataex
clear
input str7 MCSID byte AHPSEX00 float(recodedAPACQU00 recodedAPVCQU00)
"M10016V" 2 1 0
"M10044Z" 2 0 0
"M10062B" 2 4 .
"M10068H" 2 2 1
"M10083G" 2 2 0
"M10134A" 2 3 4
"M10146E" 2 5 6
"M10153D" 2 1 0
"M10195P" 2 2 0
"M10313B" 2 1 2
"M10349P" 2 2 6
"M10379V" 2 1 0
"M10455Q" 2 0 0
"M10492V" 2 0 0
"M10537R" 2 0 0
"M10541M" 2 2 0
"M10567X" 2 2 0
"M10603J" 2 2 6
"M10614M" 2 0 0
"M10617Q" 2 2 4
"M10620K" 2 5 6
"M10639W" 2 0 1
"M10675A" 2 2 0
"M10728W" 2 4 0
"M10762Y" 2 5 0
"M10781B" 2 2 0
"M10801N" 2 6 6
"M10809W" 2 0 0
"M10816V" 2 2 4
"M10819Y" 2 6 6
"M10843Y" 2 3 0
"M10914W" 2 0 0
"M10998S" 2 4 6
"M11019C" 2 5 0
"M11077N" 2 4 6
"M11091L" 2 6 6
"M11167P" 2 2 4
"M11197V" 2 5 0
"M11220B" 2 3 0
"M11247N" 2 0 0
"M11295W" 2 3 5
"M11335M" 2 5 1
"M11345P" 2 5 0
"M11370Q" 2 1 .
"M11386Y" 2 6 6
"M11395Z" 1 5 6
"M11403G" 2 2 6
"M11422K" 2 2 4
"M11466X" 2 3 .
"M11505M" 2 2 6
"M11753B" 2 5 0
"M11763D" 2 3 4
"M11774G" 2 2 1
"M11789P" 2 0 0
"M11805W" 2 2 2
"M11816Z" 2 2 2
"M11845E" 2 5 6
"M11889S" 2 2 0
"M11949M" 2 0 2
"M12039L" 2 0 6
"M12099Y" 2 3 1
"M12165R" 2 . .
"M12166S" 2 2 2
"M12189Z" 2 2 1
"M12223J" 2 5 6
"M12234M" 2 2 3
"M12271S" 2 3 4
"M12272T" 2 3 6
"M12293Y" 2 0 0
"M12386C" 1 2 5
"M12402K" 2 0 0
"M12461W" 2 0 1
"M12464Z" 2 2 2
"M12547B" 2 4 0
"M12567F" 2 5 0
"M12608X" 2 2 0
"M12612T" 2 4 5
"M12653C" 2 2 4
"M12657G" 2 3 6
"M12679N" 2 0 0
"M12717B" 2 2 4
"M12720W" 2 3 2
"M12732A" 2 5 6
"M12750C" 2 0 0
"M12762G" 2 2 1
"M12778Q" 2 5 5
"M12817E" 2 2 1
"M12886T" 2 2 4
"M12914E" 2 1 4
"M12919K" 2 0 0
"M12928L" 2 . 4
"M13017J" 2 5 6
"M13021E" 2 3 0
"M13032H" 2 2 0
"M13126N" 2 2 4
"M13144Q" 2 4 5
"M13195B" 2 2 0
"M13240P" 2 6 6
"M13252T" 2 2 6
"M13284B" 2 5 6
end
label values AHPSEX00 AHPSEX00
label def AHPSEX00 1 "Male", modify
label def AHPSEX00 2 "Female", modify
[/CODE]


I need to create two new variables related to the variables recodedAPACQU00 (academic attainment) and recodedAPVCQU00 (vocational attainment). I only want to measure maternal education, and need to take out any male cases for the new variables. Would appreciate some guidance. I don't want to drop the cases as this reduces the overall sample in a combined dataset. J Rea

[Clyde Schechter]

two new variables related to the variables recodedAPACQU00 (academic attainment) and recodedAPVCQU00 (vocational attainment)

Without knowing what "related to" means, specifically, I don't see how any helpful advice can be given. Depending on the particular commands that might be used, there are different ways one might go about using only the female observations. Please clarify.

[JR Rea]

Apologies, the new variables are to be derived from 'recodedAPACQU00' and 'recodedAPVCQU00'. The first new variable will measure the academic achievement of the female only (AHPSEX00 = 2) and the second new variable will measure the vocational achievement of the female only. Thank you, J Rea

[JR Rea]

Managed to work it out, thank you, J Rea