* Date: Nov2006 * Purpose: Create SAS data set from ASCII data * Data in: ...\NSFG6HHvars.dat * Data out: ...\NSFG6HHvars.sas7bdat ****************************************************************************************; options nofmterr nocenter caps; proc format; value R_SEX 1 = "1-FEMALE" 2 = "2-MALE" ; value HHFAMTYP 1 = "1-NO SPS/PARTNER, NO CHILDREN (OF R) <19" 2 = "2-SPS/PARTNER, NO CHILDREN (OF R) <19" 3 = "3-SPOUSE AND R'S CHILD(REN) <19" 4 = "4-COHAB PARTNER AND R'S CHILDREN <19" 5 = "5-NO SPS/PARTNER, CHILDREN (OF R) <19" ; value HHPARTYP 1 = "1-BOTH BIOLOGICAL OR BOTH ADOPTIVE PARENTS" 2 = "2-STEPPARENT (WITH/WITHOUT OTHER PARENT/PARENT-FIGURE" 3 = "3-OTHER OR NO PARENT/PARENT-FIGURE" ; VALUE NCHILD 0 = "0-NO CHILD (OF ANY RELATION) <19 IN HH" 1 = "1-1 CHILD (OF ANY RELATION) <19 IN HH" 2 = "2-2 CHILDREN (OF ANY RELATION) <19 IN HH" 3 = "3-3 OR MOREN CHILDREN (OF ANY RELATION) <19 IN HH" ; value HHKIDTYP 0 = "0-NO CHILDREN <19 IN HH" 1 = "1-1 OR MORE BIO CHILD (OF R), NO NONBIO CHILD" 2 = "2-ANY NONBIOLOGICAL CHILD (OF R'S) < 19 IN HH" ; value CSPBIO . = ".-NOT APPLICABLE" 0 = "0-NO JOINT BIOLOGICAL CHILDREN" 1 = "1-1 JOINT BIOLOGICAL CHILD" 2 = "2-2 JOINT BIOLOGICAL CHILDREN" 3 = "3-3 OR MORE JOINT BIOLOGICAL CHILDREN" ; value CSPNOT . = ".-NOT APPLICABLE" 0 = "0-NO SUCH CHILD" 1 = "1-1 OR MORE SUCH CHILDREN" ; run; data /*...2002HHvars*/; infile /*'...\2002HHvars.dat'*/; input CASEID 12. R_SEX 1. HHFAMTYP 1. HHPARTYP 1. NCHILDHH 1. HHKIDTYP 1. CSPBBHH 1. CSPBSHH 1. CSPSBHH 1. CSPOKDHH 1. ; label CASEID = "CASEID OF RESPONDENT" R_SEX = "SEX OF RESPONDENT" HHFAMTYP = "TYPE OF HOUSEHOLD/FAMILY STRUCTURE" HHPARTYP = "TYPE OF PARENTAL SITUATION IN HOUSEHOLD" NCHILDHH = "NUMBER OF R'S CHILDREN (18 OR YOUNGER) LIVING IN HOUSEHOLD" HHKIDTYP = "RESPONDENT'S CHILDREN (18 OR YOUNGER) LIVING IN THE HOUSEHOLD" CSPBBHH = "# OF R'S BIO CHILDREN (<19) W/CURR SPOUSE/COHAB PARTNER IN HH" CSPBSHH = "# FEM R'S BIO KIDS (<19)--NOT CURR HUSBAND'S/PRTNR'S BIO KIDS" CSPSBHH = "# MALE R'S NONBIO KIDS (<19)--CURR WIFE'S/PRTNR'S BIO KIDS" CSPOKDHH = "# OF CHILDREN OF OTHER RLTHNSHPS LIVING WITH R & CURR SPS/PART" ; run; proc contents; run; proc freq; tables (HHFAMTYP HHPARTYP NCHILDHH HHKIDTYP CSPBBHH CSPBSHH CSPSBHH CSPOKDHH) * r_sex/missing norow nocol nopct; format hhfamtyp hhfamtyp. hhpartyp hhpartyp. hhkidtyp hhkidtyp. CSPBBHH cspbio. CSPBSHH CSPSBHH CSPOKDHH cspnot. NCHILDHH NCHILD. R_SEX R_SEX.; run;