I have been trying to estimate active duty and veteran populations in a specific MSA with a large military base with 1-year microdata. Using perwt I’ve been trying to measure increases and decreases in these two populations for the MSA with respect to the census population estimates. For example, if there is large net out migration in the MSA according to the PEP estimates, I would check if there was a decrease in populations related to the military. While doing this I realized that https://www.militaryonesource.mil/reports-and-surveys/demographic-profiles exists, but when I check the directional change of the active duty members, the change in the microdata does not mach with the change between years in these reports from the military.
I’ve been using vetstatd == 12 for active duty military and then using perwt to get the population. Is there something I’m not understanding about the microdata when comparing it with these military reports? I’m not so much concerned about the numbers being exact, I just want the directional change to be similar so I can be confident when I’m looking at other demographic statistics.