*Attach characteristics of immediate family members (spouse and children) to mothers.
List of variables: Variable name with "SP_" added to beginning

Continuous variables:
	SP_AGE 
	SP_INCOMEP 

Categorical variables:
	SP_IMOVER 
	SP_SA_CTZN 
	SP_FOREIGN
	SP_RACE3
	SP_RACE4
	SP_RECENT 
	SP_ORIGIN 
	SP_MARRIED 
	SP_NOTMAR 
	SP_EDU 
	SP_EMPLOY 
	SP_SINGLE 
	SP_OWNER 
	SP_URBAN1 
	SP_URBAN_I
	SP_URBAN_F
	SP_RURAL
;

PROC SORT DATA=sa.ipumsi_SA2;
BY year serial pernum ;
RUN ;

*Spouse's age:  SP_AGE;
PROC SQL ;
CREATE TABLE temp
AS SELECT year, serial, sploc AS pernum, age as SP_AGE
FROM sa.ipumsi_SA2
WHERE sploc > 0
ORDER BY year, serial, pernum ;

CREATE TABLE sa.merged1
AS SELECT a.*, b.SP_AGE label="Spouse's age"
FROM sa.ipumsi_SA2 AS a LEFT JOIN temp AS b
ON (a.year=b.year AND a.serial=b.serial AND a.pernum=b.pernum) ;
QUIT ; 

*Spouse's personal income: SP_INCOMEP;
PROC SQL ;
CREATE TABLE temp
AS SELECT year, serial, sploc AS pernum, INCOMEP as SP_INCOMEP
FROM sa.merged1
WHERE sploc > 0
ORDER BY year, serial, pernum ;

CREATE TABLE sa.merged2
AS SELECT a.*, b.SP_INCOMEP label="Spouse's personal income"
FROM sa.merged1 AS a LEFT JOIN temp AS b
ON (a.year=b.year AND a.serial=b.serial AND a.pernum=b.pernum) ;
QUIT ; 


*Spouse internal mover:  SP_IMOVER;
PROC SQL ;
CREATE TABLE temp
AS SELECT year, serial, sploc AS pernum, IMOVER as SP_IMOVER
FROM sa.merged2
WHERE sploc > 0
ORDER BY year, serial, pernum ;

CREATE TABLE sa.merged3
AS SELECT a.*, b.SP_IMOVER label="Spouse internal mover"
FROM sa.merged2 AS a LEFT JOIN temp AS b
ON (a.year=b.year AND a.serial=b.serial AND a.pernum=b.pernum) ;
QUIT ;

*Spouse SA citizen:  SP_SA_CTZN;
PROC SQL ;
CREATE TABLE temp
AS SELECT year, serial, sploc AS pernum, SA_CTZN as SP_SA_CTZN
FROM sa.merged3
WHERE sploc > 0
ORDER BY year, serial, pernum ;

CREATE TABLE sa.merged4
AS SELECT a.*, b.SP_SA_CTZN label="Spouse SA citizen"
FROM sa.merged3 AS a LEFT JOIN temp AS b
ON (a.year=b.year AND a.serial=b.serial AND a.pernum=b.pernum) ;
QUIT ;

*Spouse foreign born:  SP_FOREIGN;
PROC SQL ;
CREATE TABLE temp
AS SELECT year, serial, sploc AS pernum, FOREIGN as SP_FOREIGN
FROM sa.merged4
WHERE sploc > 0
ORDER BY year, serial, pernum ;

CREATE TABLE sa.merged5
AS SELECT a.*, b.SP_FOREIGN label="Spouse foreign"
FROM sa.merged4 AS a LEFT JOIN temp AS b
ON (a.year=b.year AND a.serial=b.serial AND a.pernum=b.pernum) ;
QUIT ;