publoc: Local government employee

Description

publoc indicates whether the respondent is a local government employee.

Availability

Sample	Years
Basic	1989 - present
ORG	1989 - present

Values

Value	Label
0	Not in local government
1	In local government

Detailed comments

The analysis above uses employed workers in the CPS Basic for 1989-2023.

Code

Variable creation

*******************************************************************************
* Public sector: local
*******************************************************************************
gen byte publoc = .

if $monthlycps == 1 {
    if tm(1989m1) <= $date & $date <= tm(1993m12) {
        replace publoc = 0 if class >= 1 & class ~= .
        replace publoc = 1 if class == 4
    }
    if tm(1994m1) <= $date {
        replace publoc = 0 if peio1cow >= 1 & peio1cow ~= .
        replace publoc = 1 if peio1cow == 3
    }
}

lab var publoc "Local government employee"
lab def publoc 1 "In local government" 0 "Not in local government"
lab val publoc publoc
notes publoc: Different definitions/universes in 1989-1993, 1994-present
notes publoc: 1994-present: For first job only
notes publoc: 1989-1993 Unicon: class
notes publoc: 1994-present CPS: peio1cow

Figure creation

keep if publoc ~= .
keep if age >= 16 & age <= 64
keep if emp == 1

gcollapse (mean) publoc_ = publoc [pw=basicwgt], by(year female) fast

* make wide and graph
reshape wide publoc_, i(year) j(female)
foreach var of varlist publoc_* {
    replace `var' = `var' * 100
    sum `var' if year == 2014
    local `var'yvalue = r(mean)
    local `var'xvalue = 2014
}
local publoc_0yvalue = `publoc_0yvalue' - 2
local publoc_1yvalue = `publoc_1yvalue' + 2

local color1 228 26 28
local color2 55 126 184
local color3 77 175 74
local color4 152 78 163
local color5 255 127 0

line publoc_0 publoc_1 year if year <= 1975, lcolor("`color4'" "`color2'") || ///
line publoc_0 publoc_1 year if 1976 <= year & year <= 1988, lcolor("`color4'" "`color2'") || ///
line publoc_0 publoc_1 year if 1989 <= year & year <= 1993, lcolor("`color4'" "`color2'") || ///
line publoc_0 publoc_1 year if 1994 <= year, lcolor("`color4'" "`color2'") ///
legend(off) ///
xlabel(1990(5)2020) ///
ylabel(0(5)20 25 "25%", angle(0) gmin gmax) ///
xtitle("") ytitle("") ///
lcolor("`color4'" "`color2'") ///
graphregion(color(white)) plotregion(color(white)) ///
title("Local government share of workforce, ages 16-64, by gender", size(medium)) ///
text(`publoc_0yvalue' `publoc_0xvalue' "Male", color("`color4'") placement(c)) ///
text(`publoc_1yvalue' `publoc_1xvalue' "Female", color("`color2'") placement(c))
graph export ${variableimages}publoc_titleimage.svg, replace

/***
The analysis above uses employed workers in the CPS Basic for 1989-2023.
***/