Section III: Creation of Yearly Files
In the process of tracking labor market behaviors such as multiple job holding (i.e., when an
individual simultaneously works two or more jobs), R&P decided that quarterly files alone were
inadequate, because the time frame within the quarter a job was worked is unknown. A year-based file
was created to aid this tracking process (See Appendix C for more extensive
information on Multiple Job Holding). R&P developed a new file structure and procedures for
populating that structure with data.
R&P personal created several programs that systematically reproduce the population process.
The following basic steps describe the process of populating these yearly files (some steps are
processed basically at the same time during the execution of these programs):
- Compile the SSNs in the four quarterly files into a list of unique SSNs for the year.
- Sum all wages earned in the year by SSN to total_wa.
- Calculate the number of employers worked for in the year by SSN to count_em.
- Calculate the number of quarters worked for each SSN to quarters.
- Calculate the primary employer (employer of most wages) for the year by SSN to pri_emp.
- Calculate wages earned from primary employer by SSN to pri_wage.
- Calculate secondary employer (employer of second highest wages) for the year by SSN to
- Calculate wages earned for secondary employer by SSN to sec_wage.
- Calculate the quintile distribution based on total_wa and assign a quintile to each SSN.
- Compile the QUI (Quarterly Unemployment Insurance, ES-202) database by year.
- Match the compiled QUI with the yearly file based on the UI tax number of both the primary and
secondary employers. This adds the employer-based information to the file (Ownership,
Industry, Employment Size and County of physical location). Ownership is government or
private (government is divided into three groups, local, state and federal).
- Create a demographic file by compiling all available administrative databases.
- Match the demographic file with the yearly file on SSN. This adds Date of Birth and Gender to
most of the records. Race, education level and place of residence may be added to this file in the
- An individual's age as of December 31 of that year is then calculated from the Date of Birth.
- An individual's attachment to the labor market is calculated by a process that uses the four
quarters of the reference year, the fourth quarter previous year and the first quarter of the
following year when needed (see Appendix C Part B pg. C-4 for examples of criteria for
inclusion in an attachment category).
- This attachment variable is then added to the file by matching on SSN.
Part B of this section contains crosstabulations of economic and demographic variables for the
years 1992 through 1998. They show the distribution and relationship of these variables to each
other in Wyoming's labor market over this time period.
Part C of this section contains crosstabulations of the variable Attachment to the Labor Market
by Primary Industry, Gender and (Current Population Survey) CPS Age Group for the years
1993 and 1998. They show how different age groups, genders and industries have chosen to
interact with the labor market over time.
Part D of this section contains crosstabulations of Primary Industry by Secondary Industry for
1993 and 1998. They show what industries tend to employ individuals who work for more than
one employer in a year and in what industry that second job tends to occur.