Looking for veterans statistics joined with household data in PUMS - Help appreciated!

Hi Julie,

I ran a tabulation through MAST that may answer your questions, if the 2014 data is acceptable to you. Unfortunately, when I tried to upload it, I got a message that it is either too large or an unacceptable file type. It was .csv, then I tried .ods. And it's not a large file. Anyway, the top half of the spreadsheet is the household level data and the bottom half is the person level data. Each person inherits all the characteristics of the household, so all household dimensions appear in the person section in addition to the household section.

The columns in the household level section are:
VetsInPov – tells how many vets in poverty live in each household, either 0 or 1+
HHSz – tells how many people live in the households. It is presented as a range, because that's how MAST works, but in your case each range is limited to a single number.
Wgtp, as you know, is the weighted household count.
UW_hdrs is the unweighted header count. Since you have the background of having worked with the file, I thought there might be some value in including this. Note that group quarters are counted as '1' here, whereas in the weighted count, they are treated as zero.
Hincp_vwa is the weighted, adjusted, volumetric portion of household income. Given that you are looking for children who are living with vets who are in poverty, I'm guessing that this number might be important to you.
LoVal/HiVal are Wgtp +/- margin of error.
Ave HH Income is Hincp_vwa/Wgtp. This column was created in the spreadsheet, not by MAST.

Using line 26 as an example, we see households that have at least one vet (based on Vps) with a Povpip of 0-200, and 3 other people live with the vet. There are 3,701 actual records in the 2014 file with this situation, and they are weighted to represent 351,937 households. The average reported income of these households is about $38,000, which can be compared with other households that have 4 people in them (line 6) which report about $103,000 income.

In the person level section, we see all the dimensions of the household level section, plus information about the people who live in those households.

New columns in the person level section are:
Banded age: since you are interested in the presence of children, I dimensionalized the occupants of the household into those 0-17 and 18+.
Pwgtp, as you know, is weighted person count.
People is unweighted person count.
PL_Wgtp is weighted household count at the person level. Sticking with the example of households that have 4 people and one+ veteran with a Povpip of 0-200, lines 92-93 can be used in conjunction with line 26. Line 26 said that there were 351,937 households with this condition. Line 93 tells us that every one of those households has a person 18+ in it, and line 92 tells us that 278,893 of those households have children in them.
LoVal/HiVal are Pwgtp +/- margin of error.

Using the unweighted counts, you can do some cross-checks that might be useful. For example, line 26 told us that there are 3,701 unweighted households in the condition that we are examining, and each of those households has 4 people. Lines 92-93 tell us that there are a total of 5014+9790 people living in those households. 3701*4=14,804. 5014+9790=14,804.

On another note, today I released an android app in the Google Play Store that allows anyone with an android device to run MAST tabulations. However, the app is in its infancy, and it wouldn't be able to create this tabulation because I haven't yet given it the capability to create household level dimensions based on person level data. That capability is essential to solving your problem, and is no problem for MAST, but the app doesn't have that portion of the interface built yet.

Hi Julie,

I ran a tabulation through MAST that may answer your questions, if the 2014 data is acceptable to you. Unfortunately, when I tried to upload it, I got a message that it is either too large or an unacceptable file type. It was .csv, then I tried .ods. And it's not a large file. Anyway, the top half of the spreadsheet is the household level data and the bottom half is the person level data. Each person inherits all the characteristics of the household, so all household dimensions appear in the person section in addition to the household section.

The columns in the household level section are:
VetsInPov – tells how many vets in poverty live in each household, either 0 or 1+
HHSz – tells how many people live in the households. It is presented as a range, because that's how MAST works, but in your case each range is limited to a single number.
Wgtp, as you know, is the weighted household count.
UW_hdrs is the unweighted header count. Since you have the background of having worked with the file, I thought there might be some value in including this. Note that group quarters are counted as '1' here, whereas in the weighted count, they are treated as zero.
Hincp_vwa is the weighted, adjusted, volumetric portion of household income. Given that you are looking for children who are living with vets who are in poverty, I'm guessing that this number might be important to you.
LoVal/HiVal are Wgtp +/- margin of error.
Ave HH Income is Hincp_vwa/Wgtp. This column was created in the spreadsheet, not by MAST.

Using line 26 as an example, we see households that have at least one vet (based on Vps) with a Povpip of 0-200, and 3 other people live with the vet. There are 3,701 actual records in the 2014 file with this situation, and they are weighted to represent 351,937 households. The average reported income of these households is about $38,000, which can be compared with other households that have 4 people in them (line 6) which report about $103,000 income.

In the person level section, we see all the dimensions of the household level section, plus information about the people who live in those households.

New columns in the person level section are:
Banded age: since you are interested in the presence of children, I dimensionalized the occupants of the household into those 0-17 and 18+.
Pwgtp, as you know, is weighted person count.
People is unweighted person count.
PL_Wgtp is weighted household count at the person level. Sticking with the example of households that have 4 people and one+ veteran with a Povpip of 0-200, lines 92-93 can be used in conjunction with line 26. Line 26 said that there were 351,937 households with this condition. Line 93 tells us that every one of those households has a person 18+ in it, and line 92 tells us that 278,893 of those households have children in them.
LoVal/HiVal are Pwgtp +/- margin of error.

Using the unweighted counts, you can do some cross-checks that might be useful. For example, line 26 told us that there are 3,701 unweighted households in the condition that we are examining, and each of those households has 4 people. Lines 92-93 tell us that there are a total of 5014+9790 people living in those households. 3701*4=14,804. 5014+9790=14,804.

On another note, today I released an android app in the Google Play Store that allows anyone with an android device to run MAST tabulations. However, the app is in its infancy, and it wouldn't be able to create this tabulation because I haven't yet given it the capability to create household level dimensions based on person level data. That capability is essential to solving your problem, and is no problem for MAST, but the app doesn't have that portion of the interface built yet.