I am trying to extract workers at their place of work from the 1-year ACS microdata but I am having a hard time figuring out the right variables. I have an Access database with the 1-year data so I am looking for the correct query. If I pull all records where Employment status recode is 1 (Civilian employed, at work), 2 (Civilian employed, with a job but not at work), 4 (Armed forces, at work), and 5 (Armed forces, with a job but not at work) along with the POWPUMA number and the person weight, will that get me the correct number?
I tried getting it from iPUMS but for some reason even with selecting out only employed ESR codes I kept getting a number that looked closer to the residential population than the number of workers for each POWPUMA/county. I used to rely on DataFerret but it no longer works on my computer at all, even using their very specific technical requirements.
In reply to JamiRae:
In reply to John Grumbine: