-
Notifications
You must be signed in to change notification settings - Fork 0
/
cepr_acs_ew_2016-21_tables.do
40 lines (26 loc) · 1.3 KB
/
cepr_acs_ew_2016-21_tables.do
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
clear
/*
File: cepr_acs_ew_2016-21_tables.do
Date: 01 Dec 2022
Desc: ACS tables for expert witness statement calculations
*/
/* set directories */
/* dropbox - pandeMAC deux */
global do "/Users/glooper/Dropbox (CEPR)/Data/homestata/projects/disability/do/2022_expertwitness_ACS" /* do files */
global raw "/Users/glooper/Dropbox (CEPR)/Data/homestata/projects/disability/data/raw" /* ipums extracts */
global working "/Users/glooper/Dropbox (CEPR)/Data/homestata/projects/disability/data/working" /* recoded extracts */
global log "/Users/glooper/Dropbox (CEPR)/Data/homestata/projects/disability/log/2022_expertwitness_ACS" /* log files */
cd "$working"
use "ipums_acs_2016-2021_disability_recode.dta"
cd "$log"
log using cepr_tables_ew_2016-2021.log, replace
/* employment-to-population ratio (epop) */
/* disabled epop by state, ages 21 to 64 */
tab statefip epop [aw=rndwt] if disability==1 & agewk==1 & inst==0, row nofreq
/* all epop by state, ages 21 to 64 */
tab statefip epop [aw=rndwt] if agewk==1 & inst==0, row nofreq
/* Disabled epop by state by year, ages 21 to 64 */
bysort year: tab statefip epop [aw=perwt] if disability==1 & agewk==1 & inst==0, row nofreq
/* all epop by state by year, ages 21 to 64 */
bysort year: tab statefip epop [aw=perwt] if agewk==1 & inst==0, row nofreq
log close