Appendix C: How to Unpack Multiple Entries

Appendix C: How to Unpack Multiple Entries
Appendix C: How to Unpack Multiple Entries (Young Women Cohort)
Responses to multiple entry questions found in early years of the surveys of the four Original Cohorts were coded in a geometric progression format to conserve space on the tape. Variables such as 'Method of Seeking Employment,' 'Method of Finding Current or Last Job,' 'Type of Financial Aid Received,' 'Type of Child Care Arrangement,' and numerous health-related questions have been formatted in this way since the surveys began. Multiple entry items are identified by an asterisk under the source code box in the questionnaire and by a special detailed codeblock in the documentation. These responses need to be "unpacked" before they can be used in analysis. The example below pertains specifically to the Mature Women's cohort; it is applicable to all Original Cohort multiple entry variables, including the Young Women.
In later survey rounds, choose-all-that-apply items are coded as a series of yes-no variables in the data set. For example, although the respondent would see a list of possible fringe benefits and select all that were available to her, in the data this question is represented as a series of questions like "Did your employer make medical benefits available," "Did your employer make paid vacation available," and so on (see R20086.00-R20190.00 in 1995).
Example
Codes for the Mature Women's variable R03380., 'Fringe Benefits at Current Job 77,' range from 1 (the respondent reported only one such benefit, "medical insurance") to 259 (the respondent reported "medical insurance," "life insurance," and "paid sick leave") to 1023 (the respondent reported that she had access to all of the benefits listed). Although there are several different ways to sort out which respondent has positive answers on which components, this appendix provides one example in SAS and one example in SPSS.
Program 1: Unpacking Fringe Benefits Data in SAS
This SAS program unpacks fringe benefits from the variable "fringe." It creates 10 (dichotomous) dummy variables indicating the presence or absence of each of the 10 benefits. Each dummy is set to missing if fringe is missing (coded at -998 or -999). Note that the variables are created in reverse order from the codeblock, i.e., MEDICAL is code 1 on the tape and FRINGE10 in the program. The program statements listed below can be modified by the user to include the expanded set of fringe benefits available in later survey years as well as to unpack other multiple entry variables by extending the dummy, the counter, and the number of variables to agree with the total number of responses listed in the codeblock in the documentation.
data benefits;
infile 'D:\documents\requests\unpack.dat' lrecl=4;
input
R0338000 4.;
if R0338000 = -998 then R0338000 = .;
if R0338000 = -999 then R0338000 = .;
label R0338000 = "FRINGE BNFTS CUR_JOB_77";
array fringe fringe01-fringe10;
do over fringe; if R0338000 ne . then fringe=0; end;
all=R0338000;
if all ge 512 then do; fringe10=1; all=all-512; end;
if all ge 256 then do; fringe09=1; all=all-256; end;
if all ge 128 then do; fringe08=1; all=all-128; end;
if all ge 64 then do; fringe07=1; all=all- 64; end;
if all ge 32 then do; fringe06=1; all=all- 32; end;
if all ge 16 then do; fringe05=1; all=all- 16; end;
if all ge 8 then do; fringe04=1; all=all- 8; end;
if all ge 4 then do; fringe03=1; all=all- 4; end;
if all ge 2 then do; fringe02=1; all=all- 2; end;
if all ge 1 then do; fringe01=1; all=all- 1; end;
label fringe01='medical,surgi';
label fringe02='life insuranc';
label fringe03='a retirement ';
label fringe04='training/educ';
label fringe05='profit sharin';
label fringe06='stock options';
label fringe07='free….meals';
label fringe08='free…..mdse';
label fringe09='paid sick lea';
label fringe10='paid vacation';
run;
Program 2: Unpacking Fringe Benefits Data in SPSS
The SPSS program works in the same way as the SAS program. Users of this alternative package can follow this template.
/* UNPACKING 1981 YOUNG MEN FRINGE BENEFITS: SPSS/
compute FB1=0
variable labels FB1 '81 NONE'
compute FB2=0
variable labels FB2 '81 FLEX HRS'
compute FB3=0
variable labels FB3 '81 PAID VACATION'
compute FB4=0
variable labels FB4 '81 PD SICK'
compute FB5=0
variable labels FB5 '81 FR MERCH'
compute FB6=0
variable labels FB6 '81 FR MEALS'
compute FB7=0
variable labels FB7 '81 STOCK'
compute FB8=0
variable labels FB8 '81 PROFT'
compute FB9=0
variable labels FB9 '81 TRED'
compute FB10=0
variable labels FB10 '81 RETR'
compute FB11=0
variable labels FB11= '81 LIFE'
compute FB12=0
variable labels FB12 '81 HLTH'
compute FB81a=FB81
variable labels FB81a 'VARIABLE FOR NONE'
do if (2048 le FB81)
compute FB1=1
compute FB81=FB81-2048
else
compute FB1=-4
end if
do if (1024 le FB81)
compute FB2=1
compute FB81=FB81-1024
else
compute FB2=-4
end if
do if (512 le FB81)
compute FB3=1
compute FB81=FB81-512
else
compute FB=-4
end if
do if (256 le FB81)
compute FB4=1
compute FB81=FB81-256
else
compute FB4=-4
endif
do if (128 le FB81)
compute FB5=1
compute FB81=FB81-128
else
compute FB5=-4
end if
do if (64 le FB81)
compute FB6=1
compute FB81=FB81-64
else
compute FB6=-4
end if
do if (32 le FB81)
compute FB7=1
compute FB81=FB81-32
else compute FB7=-4
end if
do if (16 le FB81)
compute FB8=1
compute FB81=FB81-16
else
compute FB8=-4
end if
do if (8 le FB81)
compute FB9=1
compute FB81=FB81-8
else
compute FB9=-4
end if
do if (4 le FB81)
compute FB10=1
compute FB81=FB81-4
else
compute FB10=-4
end if
do if (2 le FB81)
compute FB11=1
compute FB81=FB81-2
else
compute FB11=-4
end if
do if (1 le FB81)
compute FB12=1
compute FB81=FB81-1
else
compute FB12=-4
end if
Cohorts
- NLSY97
- Topical Guide to the Data
- Asterisk Tables
- I. Employment, Unemployment, and Job Search (age restrictions as of interview date)
- II. Schooling (age restrictions as of 12/31/96)
- III. Training (age restrictions as of interview date)
- IV. Income, Assets, and Program Participation
- V. Family Formation (age restrictions as of end of previous calendar year--12/31/96 in rd 1, 12/31/97 in rd 2, and so on)
- VI. Family Background (age restrictions as of 12/31/1996)
- VII. Expectations
- VIII. Attitudes, Behaviors, and Time Use
- IX. Health (age restrictions as of 12/31/96)
- X. Political Participation
- XI. Environmental Variables (in main data set)
- Education
- Employment
- Household, Geography & Contextual Variables
- Family Background
- Marital History, Childcare & Fertility
- Income
- Health
- Attitudes
- Crime & Substance Use
- Asterisk Tables
- Intro to the Sample
- Using & Understanding the Data
- Other Documentation
- Codebook Supplement
- Introduction to the NLSY97 Created Variable Appendices
- Appendix 1: Education Variable Creation
- Enrollment Status and Highest Grade/Degree - Appendix 1
- Date Received Diploma or Degree - Appendix 1
- Number of Grades Repeated or Skipped - Appendix 1
- Number of Schools Attended - Appendix 1
- Credits Earned toward Bachelor's/Associate's Degree - Appendix 1
- Date Left High School and Highest High School Grade - Appendix 1
- Private or Parochial School - Appendix 1
- SAT/ACT Scores - Appendix 1
- Training: Receipt of Certificate or Vocational License - Appendix 1
- Appendix 2: Employment Variable Creation
- Appendix 3: Family Background and Formation
- Household Size as of Survey Date - Appendix 3
- Marital Status and Marital/Cohabitation History - Appendix 3
- Fertility and Child Status - Appendix 3
- Number of Residences since Age 12 - Appendix 3
- Current Citizenship Status - Appendix 3
- Mother's Age at First Birth/Respondent's Birth
- Relationship to Household Parent Figures (Round 1 Parent Interview) - Appendix 3
- Relationship to Household Parent Figures (Rounds 7-9 Childhood Retrospective) - Appendix 3
- Relationship to Household Parent Figures (Interview Date) - Appendix 3
- Appendix 4: Geographic Variable Creation
- Appendix 5: Income and Assets Variable Creation
- Appendix 6: Event History Creation and Documentation
- Appendix 7: Continuous Month Scheme and Crosswalk
- Appendix 8: Instrument Rosters
- Appendix 9: Family Process and Adolescent Outcome Measures
- Appendix 10: CAT-ASVAB Scores
- Appendix 11: Collection of the Transcript Data (High School)
- Appendix 12: Post-Secondary Transcript Study
- Appendix 13: Cross-Cohort NLSY79/97 Overview
- Attachment 1: Census Industrial & Occupational Classification Codes
- Geocode Codebook Supplement
- Introduction to NLSY97 Geocode Data
- Attachment 100: Census Bureau State and County Codes
- Attachment 101: Metropolitan Statistical Area (MSA)/Core-Based Statistical Area (CBSA) Codes
- Attachment 102: IPEDS Data and College Identification Codes
- Attachment 103: Migration Distance Variables for Respondent Locations
- Attachment 104: Codebook Pages for Geocode and Zipcode Variables
- Questionnaires
- Errata
- Errata for NLSY97 Round 17 Release
- Errata for NLSY97 Round 16 Release
- Addendum: Additional NLSY97 Speech & Post-Secondary Variables Available
- Addendum: NLSY97 Post-Secondary Data and Transcript Data Files Now Available
- Errata for NLSY97 Round 15 Release
- Errata for NLSY97 Round 14 Release
- Errata for NLSY97 Round 13 Release
- Errata for NLSY97 Round 12 Release
- Errata for NLSY97 Round 11 Release
- Errata for NLSY97 Round 10 Release
- Errata for NLSY97 Round 9 Release
- Errata for NLSY97 Round 8 Release
- Errata for NLSY97 Round 7 Release
- Errata for NLSY97 Round 6 Release
- Errata for NLSY97 Round 5 Release
- Errata for NLSY97 Round 4 Release
- Errata for NLSY97 Round 3 Release
- Tutorials
- Technical Sampling Report
- Codebook Supplement
- Get Data
- Topical Guide to the Data
- NLSY79
- Topical Guide to the Data
- Asterisk Tables
- Education
- Employment
- Employment: An Introduction
- Work Experience
- Jobs & Employers
- Class of Worker
- Discrimination
- Fringe Benefits
- Industries
- Job Characteristics Index
- Job Satisfaction
- Job Search
- Labor Force Status
- Military
- Occupations
- Time & Tenure with Employers
- Wages
- Work History Data
- Employer History Roster
- Business Ownership
- Retirement
- Household, Geography & Contextual Variables
- Family Background
- Marital History, Childcare & Fertility
- Income
- Health
- Attitudes
- Crime & Substance Use
- Intro to the Sample
- Using & Understanding the Data
- Other Documentation
- Codebook Supplement
- NLSY79 Attachment 3: Industrial and Occupational Classification Codes
- NLSY79 Attachment 4: Fields of Study in College
- NLSY79 Attachment 5: Index of Labor Unions and Employee Associations
- NLSY79 Attachment 6: Other Kinds of Training Codes
- NLSY79 Attachment 7: Other Certificate Codes
- NLSY79 Attachment 8: Health Codes
- NLSY79 Attachment 100: Geographic Regions
- NLSY79 Attachment 101: Country Codes
- NLSY79 Attachment 102: Federal Information Processing Standards (FIPS)
- NLSY79 Attachment 103: Religion Codes
- NLSY79 Attachment 106: Profiles of American Youth (ASVAB Data/AFQT Scores)
- NLSY79 Appendix 1: Employment Status Recode Variables (1979-1998 and 2006)
- NLSY79 Appendix 2: Total Net Family Income Variable Creation (1979-2014)
- NLSY79 Appendix 3: Job Satisfaction Measures
- NLSY79 Appendix 4: Job Characteristics Index 1979-1982
- NLSY79 Appendix 5: Supplemental Fertility and Relationship Variables
- NLSY79 Appendix 6: Urban-Rural and SMSA-Central City Variables
- NLSY79 Appendix 7: Unemployment Rate
- NLSY79 Appendix 8: Highest Grade Completed & Enrollment Status Variable Creation
- NLSY79 Appendix 9: Linking Employers Through Survey Years
- NLSY79 Appendix 11: Round 12 (1990) Survey Administration Methods
- NLSY79 Appendix 12: Most Important Job Learning Activities (1993-94)
- NLSY79 Appendix 13: Intro to CAPI Questionnaires and Codebooks
- NLSY79 Appendix 14: Instrument Rosters
- NLSY79 Appendix 15: Recipiency Event Histories
- NLSY79 Appendix 16: 1994 Recall Experiment
- NLSY79 Appendix 17: Interviewer Characteristics Data
- NLSY79 Appendix 18: Work History Data
- NLSY79 Appendix 19: SF-12 Health Scale Scoring
- NLSY79 Appendix 20: Round 20 (2002) Early Bird and Income Recall Experiments
- NLSY79 Appendix 21: Attitudinal Scales
- NLSY79 Appendix 22: Migration Distance Variables for Respondent Locations
- NLSY79 Appendix 23: Revised Asset and Debt Variables and Computed TOTAL Net Wealth Variables
- NLSY79 Appendix 24: Reanalysis of the 1980 AFQT Data from the NLSY79
- NLSY79 Appendix 25: Attitudinal Scale Scoring
- NLSY79 Appendix 26: Non-Response to Financial Questions and Entry Points
- NLSY79 Appendix 27: IRT Item Parameter Estimates, Scores and Standard Errors
- NLSY79 Appendix 28: NLSY79 Employer History Roster
- NLSY79 Appendix 29: Date of Interview Current Status Variables
- NLSY79/97 Cross-Cohort Data
- Geocode Codebook Supplement
- Appendix 7: Unemployment Rates
- Appendix 10: Geocode Documentation
- Attachment 100: Geographic Regions
- Attachment 101: Country Codes
- Attachment 102: State FIPS Codes
- Attachment 104, Part A: 1981 Standard Metropolitan Statistical Areas (SMSAs)
- Attachment 104, Part B: 1983 Metropolitan Statistical Areas (MSAs)
- Attachment 104, Part C: 1983 Consolidated MSAs and Associated Primary MSAs (CMSAs and PMSAs)
- Attachment 104, Part D: 1983 PMSAs and Associated CMSAs
- Attachment 104, Part E: 1988 MSAs, CMSAs, and Associated PMSAs
- Attachment 104, Part F: 2004 MSAs, CMSAs, and Associated PMSAs
- Attachment 104, Part G: 2006 Core-Based Statistical Areas (CBSAs)
- Attachment 105: Addendum to FICE Codes
- Attachment 106: Codebook Pages for Geocode and Zipcode Variables
- Questionnaires
- Tutorials
- Errata
- Errata for 1979-2016 Data Release
- Errata for 1979-2014 Data Release
- Errata for 1979-2012 Data Release
- Errata for 1979-2010 Data Release
- Errata for 1979-2008 Data Release
- Errata for 1979-2006 Data Release
- Errata for 1979-2004 Data Release
- Errata for 1979-2002 Data Release
- Errata for 1979-2000 Data Release
- Technical Sampling Report
- School & Transcript Surveys Documentation
- Codebook Supplement
- Get Data
- Topical Guide to the Data
- NLSY79 Child/YA
- Topical Guide to the Data
- Intro to the Sample
- Using & Understanding the Data
- Other Documentation
- Codebook Supplement
- Appendix A: HOME-SF Scales (NLSY79 Child)
- Appendix B: Composition of the Temperament Scales (NLSY79 Child)
- Appendix C: Motor & Social Development (NLSY79 Child)
- Appendix D: Behavior Problems Index (NLSY79 Child)
- Appendix D, Part 1: Composition of the BPI subscales
- Appendix D, Part 2a: BPI Anxious/Depressed Subscale
- Appendix D, Part 2b: BPI Antisocial Subscale
- Appendix D, Part 2c: BPI Dependent Subscale
- Appendix D, Part 2d: BPI Headstrong Subscale
- Appendix D, Part 2e: BPI Hyperactive Subscale
- Appendix D, Part 2f: BPI Peer Conflicts/Withdrawn Subscale
- Appendix D, Part 2g: BPI Full Scale
- Appendix D, Part 3a: BPI Internalizing Subscale
- Appendix D, Part 3b: BPI Externalizing Subscale
- Appendix D, Part 3c: BPI Total Scores
- Appendix E: Sample SPSSx Program for Merging NLSY79 Child/YA & Mother Files
- Appendix F: Sample SAS Program for Merging NLSY79 Child/YA & Mother Files
- Appendix G: NLSY79 Child Assessment Scores, Reference Numbers (2010-2014)
- Appendix H: Identification Codes in the Child and Young Adult Database
- Attachment 100: Codebook Pages for Young Adult Geocode Data
- Questionnaires
- Errata
- Errata for 2016 Child/Young Adult Release
- Errata for 2014 Child/Young Adult Release
- Data Addition: New Work and School Status Variables Created
- Errata for 2012 Child/Young Adult Release
- Errata for 2010 Child/Young Adult Release
- Errata for 2008 Child/Young Adult Release
- Errata for 2006 Child/Young Adult Release
- Errata for 2004 Child/Young Adult Release
- Errata for 2002 Child/Young Adult Release
- Errata for 2000 Child/Young Adult Release
- Research/Technical Reports
- Codebook Supplement
- Get Data
- NLS Mature and Young Women
- NLS Older and Young Men