replace wife's ocupation using husband's

[Yawen LI]

Dear listers,
I want to replace housewives' occupation by their husband's. My data was in
long form, meaning each individual has one line of data.
should my syntax write like this?

comp new=0.
if gender=female & missing (ocupation)  new=?.

how do i refer to husband's occupation in the syntax?
Hope i am clear.

--
Yawen Li
Ph.D candidate
Program Manager/China Program
School of Social Work
University of Southern California
MRF 347, 669 W 34th St. Los Angeles
Tel: [phone]
Email: [hidden email]

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[ViAnn Beadle]

How do you identify the wife of a husband or vice-versa.
Is there some family ID variable?
Is occupation numeric or string?
Do all individuals have spouses?
What if husband's occupation is also missing?


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Yawen LI
Sent: Wednesday, April 16, 2008 7:20 PM
To: [hidden email]
Subject: replace wife's ocupation using husband's

Dear listers,
I want to replace housewives' occupation by their husband's. My data was in
long form, meaning each individual has one line of data.
should my syntax write like this?

comp new=0.
if gender=female & missing (ocupation)  new=?.

how do i refer to husband's occupation in the syntax?
Hope i am clear.

--
Yawen Li
Ph.D candidate
Program Manager/China Program
School of Social Work
University of Southern California
MRF 347, 669 W 34th St. Los Angeles
Tel: [phone]
Email: [hidden email]

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Yawen LI]

Thanks for replying. good questions.

I have the following variables:
HHID: household ID
Line:  individual ID within the household
V1: variable indicating the relationships within the household (0=household
head, 1=spouse to the household head)
Gender: 1=male, 2=female.
V2: ocupation variable for each individual as in numeric form (1-14).

if the husband's occupation is also missing, then i have to treat the wife's
occupation as missing as well. But that missing is in a small percentage.

Thanks
Yawen

On Wed, Apr 16, 2008 at 6:56 PM, ViAnn Beadle <[hidden email]> wrote:

> How do you identify the wife of a husband or vice-versa.
> Is there some family ID variable?
> Is occupation numeric or string?
> Do all individuals have spouses?
> What if husband's occupation is also missing?
>
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> Yawen LI
> Sent: Wednesday, April 16, 2008 7:20 PM
> To: [hidden email]
> Subject: replace wife's ocupation using husband's
>
> Dear listers,
> I want to replace housewives' occupation by their husband's. My data was
> in
> long form, meaning each individual has one line of data.
> should my syntax write like this?
>
> comp new=0.
> if gender=female & missing (ocupation)  new=?.
>
> how do i refer to husband's occupation in the syntax?
> Hope i am clear.
>
> --
> Yawen Li
> Ph.D candidate
> Program Manager/China Program
> School of Social Work
> University of Southern California
> MRF 347, 669 W 34th St. Los Angeles
> Tel: [phone]
> Email: [hidden email]
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>
>

--
Yawen Li
Ph.D candidate
Program Manager/China Program
School of Social Work
University of Southern California
MRF 347, 669 W 34th St. Los Angeles
Tel: [phone]
Email: [hidden email]
http://www-scf.usc.edu/~yawenli/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[ViAnn Beadle]

What happens if you have two females in household or two mails in household?
Do you also have others in household?

Assuming that you only have a max of two people in household and if two
people, husband  and wife, something like this should work.





*completely untested; best bet is to try it and then eyeball the results in
the data editor window.

*make sure that the husband record is followed by the wife record sorted in
household order.

sort cases by hhid gender.

If gender eq 2 and hhid eq lag(hhid,1) and missing(v2) v2=lag(v2,1).



From: [hidden email] [mailto:[hidden email]] On Behalf Of Yawen LI
Sent: Wednesday, April 16, 2008 8:05 PM
To: ViAnn Beadle
Cc: [hidden email]
Subject: Re: replace wife's ocupation using husband's



Thanks for replying. good questions.



I have the following variables:

HHID: household ID

Line:  individual ID within the household

V1: variable indicating the relationships within the household (0=household
head, 1=spouse to the household head)

Gender: 1=male, 2=female.

V2: ocupation variable for each individual as in numeric form (1-14).



if the husband's occupation is also missing, then i have to treat the wife's
occupation as missing as well. But that missing is in a small percentage.



Thanks

Yawen

On Wed, Apr 16, 2008 at 6:56 PM, ViAnn Beadle <[hidden email]> wrote:

How do you identify the wife of a husband or vice-versa.
Is there some family ID variable?
Is occupation numeric or string?
Do all individuals have spouses?
What if husband's occupation is also missing?



-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Yawen LI
Sent: Wednesday, April 16, 2008 7:20 PM
To: [hidden email]
Subject: replace wife's ocupation using husband's

Dear listers,
I want to replace housewives' occupation by their husband's. My data was in
long form, meaning each individual has one line of data.
should my syntax write like this?

comp new=0.
if gender=female & missing (ocupation)  new=?.

how do i refer to husband's occupation in the syntax?
Hope i am clear.

--
Yawen Li
Ph.D candidate
Program Manager/China Program
School of Social Work
University of Southern California
MRF 347, 669 W 34th St. Los Angeles
Tel: [phone]
Email: [hidden email]

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD




--
Yawen Li
Ph.D candidate
Program Manager/China Program
School of Social Work
University of Southern California
MRF 347, 669 W 34th St. Los Angeles
Tel: [phone]
Email: [hidden email]
http://www-scf.usc.edu/~yawenli/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD