Family Data » Creating Parent Files with One Record Per Respondent »
SAS Code for: [2000] [1998] [1996] [1994] [1992]
Respondent Record with Mother and Father Variables: 2000
Note: Modify variable list as needed; for a listing of parent (and equivalent parent-in-law) variables consult the 2000 Parent to Parent-in-Law Variables Cross-Reference Table .
* STEP 1: PARENT INFORMATION FOR FAMILY RESPONDENTS' PARENTS;
DATA FAMR;
* TO CONTROL POSITION IN OUTPUT FILE;
ATTRIB
HHID LABEL='HOUSEHOLD IDENTIFIER' FORMAT=$CHAR6.
PN LABEL='PERSON NUMBER' FORMAT=$CHAR3.
GPN_SP LABEL='2000 SPOUSE/PARTNER PERSON NUMBER' FORMAT=$CHAR3.
GSUBHH LABEL='2000 SUB-HOUSEHOLD IDENTIFIER' FORMAT=$CHAR1.
;
SET IN.H00D_H;
WHERE GPN_FAM NE '';
PN=GPN_FAM;
GPN_SP=GPN_NFAM;
KEEP HHID PN GPN_SP GSUBHH;
* KEEP PARENT VARIABLES OF INTEREST;
KEEP G2122 G2132;
RUN;
* STEP 2: PARENT INFORMATION FOR NON-FAMILY RESPONDENTS' PARENTS;
DATA NFAMR;
SET IN.H00D_H;
WHERE GPN_NFAM NE '';
PN=GPN_NFAM;
GPN_SP=GPN_FAM;
KEEP HHID PN GPN_SP GSUBHH;
* COPY PARENT-IN-LAW VARIABLES TO OUTPUT VARIABLES LOCATIONS;
G2122=G2309;
G2132=G2319;
KEEP G2122 G2132;
RUN;
* STEP 3: CONCATENATE TWO PARENT FILES;
DATA PARENTS;
SET FAMR NFAMR;
RUN;
PROC SORT DATA=PARENTS;
BY HHID PN;
RUN;
Respondent Record with Mother and Father Variables: 1998
Note: Modify variable list as needed; for a listing of parent (and equivalent parent-in-law) variables consult the 1998 Parent to Parent-in-Law Variables Cross-Reference Table .
* STEP 1: PARENT INFORMATION FOR FAMILY RESPONDENTS' PARENTS;
DATA FAMR;
* TO CONTROL POSITION IN OUTPUT FILE;
ATTRIB
HHID LABEL='HOUSEHOLD IDENTIFIER' FORMAT=$CHAR6.
PN LABEL='PERSON NUMBER' FORMAT=$CHAR3.
FPN_SP LABEL='1998 SPOUSE/PARTNER PERSON NUMBER' FORMAT=$CHAR3.
FSUBHH LABEL='1998 SUB-HOUSEHOLD IDENTIFIER' FORMAT=$CHAR1.
;
SET IN.H98D_H;
WHERE FPN_FAM NE '';
PN=FPN_FAM;
FPN_SP=FPN_NFAM;
KEEP HHID PN FPN_SP FSUBHH;
* KEEP PARENT VARIABLES OF INTEREST;
KEEP F1906 F1916;
RUN;
* STEP 2: PARENT INFORMATION FOR NON-FAMILY RESPONDENTS' PARENTS;
DATA NFAMR;
SET IN.H98D_H;
WHERE FPN_NFAM NE '';
PN=FPN_NFAM;
FPN_SP=FPN_FAM;
KEEP HHID PN FPN_SP FSUBHH;
* COPY PARENT-IN-LAW VARIABLES TO OUTPUT VARIABLES LOCATIONS;
F1906=F2068;
F1916=F2078;
KEEP F1906 F1916;
RUN;
* STEP 3: CONCATENATE TWO PARENT FILES;
DATA PARENTS;
SET FAMR NFAMR;
RUN;
PROC SORT DATA=PARENTS;
BY HHID PN;
RUN;
Respondent Record with Mother and Father Variables: 1996
Note: Modify variable list as needed; for a listing of parent (and equivalent parent-in-law) variables consult the 1996 Parent to Parent-in-Law Variables Cross-Reference Table .
* STEP 1: PARENT INFORMATION FOR FAMILY RESPONDENTS' PARENTS;
DATA FAMR;
* TO CONTROL POSITION IN OUTPUT FILE;
ATTRIB
HHID LABEL='HOUSEHOLD IDENTIFIER' FORMAT=$CHAR6.
PN LABEL='PERSON NUMBER' FORMAT=$CHAR3.
EPN_SP LABEL='1996 SPOUSE/PARTNER PERSON NUMBER' FORMAT=$CHAR3.
ESUBHH LABEL='1996 SUB-HOUSEHOLD IDENTIFIER' FORMAT=$CHAR1.
;
SET IN.H96D_H;
WHERE EPN_FAM NE '';
PN=EPN_FAM;
EPN_SP=EPN_NFAM;
KEEP HHID PN EPN_SP ESUBHH;
* KEEP PARENT VARIABLES OF INTEREST;
KEEP E1557_1 E1566_1;
RUN;
* STEP 2: PARENT INFORMATION FOR NON-FAMILY RESPONDENTS' PARENTS;
DATA NFAMR;
SET IN.H96D_H;
WHERE EPN_NFAM NE '';
PN=EPN_NFAM;
EPN_SP=EPN_FAM;
KEEP HHID PN EPN_SP ESUBHH;
* COPY PARENT-IN-LAW VARIABLES TO OUTPUT VARIABLES LOCATIONS;
E1557_1=E1557_2;
E1566_1=E1566_2A;
KEEP E1557_1 E1566_1;
RUN;
* Step 3: Concatenate two parent files;
DATA PARENTS;
SET FAMR NFAMR;
RUN;
PROC SORT DATA=PARENTS;
BY HHID PN;
RUN;
Respondent Record with Mother and Father Variables: 1994
* REFORMAT PARENTS FILE TO ONE PER RESPONDENT;
* STEP 1: SORT W2PARS FILE;
PROC SORT DATA=IN.W2PARS OUT=W2PARS;
BY HHID PN CSUBHH;
RUN;
* STEP 2: CREATE FILE WITH MOTHER RECORDS;
DATA MOM;
SET W2PARS;
WHERE CPARCODE IN ('1');
KEEP HHID PN CSUBHH ASUBHH CPN_SP COPN_CS CCSR CFAMR CFINR RPN FAMFLAG
W8201-W8211 W8213-W8219;
RENAME
W8201 = W8201M
W8202 = W8202M
W8203 = W8203M
W8204 = W8204M
W8205 = W8205M
W8206 = W8206M
W8207 = W8207M
W8208 = W8208M
W8209 = W8209M
W8210 = W8210M
W8211 = W8211M
W8213 = W8213M
W8214 = W8214M
W8215 = W8215M
W8216 = W8216M
W8217 = W8217M
W8218 = W8218M
W8219 = W8219M
;
RUN;
* STEP 3: CREATE FILE WITH FATHER RECORDS;
DATA DAD;
SET W2PARS;
IF CPARCODE IN ('2');
KEEP HHID PN CSUBHH ASUBHH CPN_SP COPN_CS CCSR CFAMR CFINR RPN FAMFLAG
W8201-W8211 W8213-W8219;
RENAME
W8201 = W8201F
W8202 = W8202F
W8203 = W8203F
W8204 = W8204F
W8205 = W8205F
W8206 = W8206F
W8207 = W8207F
W8208 = W8208F
W8209 = W8209F
W8210 = W8210F
W8211 = W8211F
W8213 = W8213F
W8214 = W8214F
W8215 = W8215F
W8216 = W8216F
W8217 = W8217F
W8218 = W8218F
W8219 = W8219F
;
RUN;
* STEP 4: CREATE FILE WITH PARENT RECORDS;
DATA PARENT;
SET W2PARS;
WHERE CPARCODE IN ('3');
KEEP HHID PN CSUBHH ASUBHH CPN_SP COPN_CS CCSR CFAMR CFINR RPN FAMFLAG
W8209-W8219 ;
RENAME
W8209 = W8209P
W8210 = W8210P
W8211 = W8211P
W8212 = W8212P
W8213 = W8213P
W8214 = W8214P
W8215 = W8215P
W8216 = W8216P
W8217 = W8217P
W8218 = W8218P
W8219 = W8219P
;
RUN;
* STEP 5: MERGE MOTHER FATHER AND PARENT FILES;
DATA PARENTS;
MERGE MOM(in=a) DAD(in=b) PARENT(in=c);
BY HHID PN CSUBHH;
RUN;
Respondent Record with Mother and Father Variables: 1992
* REFORMAT PARENTS FILE FROM ONE PER PARENT TO ONE PER RESPONDENT;
* STEP 1: SORT PARENTSW FILE;
PROC SORT DATA=IN.PARENTS OUT=PARENT1;
BY HHID PN;
RUN;
* STEP 2: CREATE FILE WITH MOTHER RECORDS;
DATA MOTHERS;
SET PARENT1;
WHERE ATYPEPAR EQ '1';
KEEP HHID PN ASUBHH APN_SP AFAMR AFINR V1 V2 V3
V8201-V8224 V18205-V18211 V18213-V18224;
RENAME
V8201 = V8201M
V8202 = V8202M
V8203 = V8203M
V8204 = V8204M
V8205 = V8205M
V8206 = V8206M
V8207 = V8207M
V8208 = V8208M
V8209 = V8209M
V8210 = V8210M
V8211 = V8211M
V8212 = V8212M
V8213 = V8213M
V8214 = V8214M
V8215 = V8215M
V8216 = V8216M
V8217 = V8217M
V8218 = V8218M
V8219 = V8219M
V8220 = V8220M
V8221 = V8221M
V8222 = V8222M
V8223 = V8223M
V8224 = V8224M
V18205 = V18205M
V18206 = V18206M
V18207 = V18207M
V18208 = V18208M
V18209 = V18209M
V18210 = V18210M
V18211 = V18211M
V18213 = V18213M
V18214 = V18214M
V18215 = V18215M
V18216 = V18216M
V18217 = V18217M
V18218 = V18218M
V18219 = V18219M
V18220 = V18220M
V18221 = V18221M
V18222 = V18222M
V18223 = V18223M
V18224 = V18224M
;
RUN;
* STEP 3: CREATE FILE WITH FATHER RECORDS;
DATA FATHERS;
SET PARENT1;
WHERE ATYPEPAR EQ '2';
KEEP HHID PN ASUBHH APN_SP AFAMR AFINR V1 V2 V3
V8201-V8224 V18205-V18211 V18213-V18224;
RENAME
V8201 = V8201F
V8202 = V8202F
V8203 = V8203F
V8204 = V8204F
V8205 = V8205F
V8206 = V8206F
V8207 = V8207F
V8208 = V8208F
V8209 = V8209F
V8210 = V8210F
V8211 = V8211F
V8212 = V8212F
V8213 = V8213F
V8214 = V8214F
V8215 = V8215F
V8216 = V8216F
V8217 = V8217F
V8218 = V8218F
V8219 = V8219F
V8220 = V8220F
V8221 = V8221F
V8222 = V8222F
V8223 = V8223F
V8224 = V8224F
V18205 = V18205F
V18206 = V18206F
V18207 = V18207F
V18208 = V18208F
V18209 = V18209F
V18210 = V18210F
V18211 = V18211F
V18213 = V18213F
V18214 = V18214F
V18215 = V18215F
V18216 = V18216F
V18217 = V18217F
V18218 = V18218F
V18219 = V18219F
V18220 = V18220F
V18221 = V18221F
V18222 = V18222F
V18223 = V18223F
V18224 = V18224F
;
RUN;
* STEP 4: MERGE MOTHER AND FATHER FILES;
DATA PARENTS;
MERGE MOTHERS FATHERS;
BY HHID PN;
RUN;
