The 2025 ACS Data Users Conference will be held on May 29, 2025 (virtual day) and June 3, 2025 (in-person in DC)
American Community Survey Data Users Group
Search for topics, people, or keywords
Sign Up
Log in
Site
Search for topics, people, or keywords
User
Home
Discussion Forum
ACS Resources
Webinars
Conferences
Steering Committee
More
Cancel
Home
Discussion Forum
ACS Resources
Webinars
Conferences
About
More
Cancel
Details
Views
6785 views
Replies
6 replies
Subscribers
542 subscribers
Users
0 members are here
Labels
Summary File
Related Census Bureau Resources
Related Forum Threads
Datapoint level/hierarchy in raw data downloads
Chris Engle
over 9 years ago
Hi - Does anyone know if the Census has documentation that explains the hierarchy of data for ACS tables? I'm working with raw data and it doesn't include the indentions that the Census uses. I only see that the TableShells Excel file (attached) shows the hierarchy as formatted indentions.
I'm trying to create a system that will allow me to calculate a 3rd-level datapoint as a % of a 2nd-level datapoint. For example (chosen randomly), calculating the % of children under 6 living with 2 parents that are foreign-born for this table (screenshot attached).
Does this exist?
Thanks for any advice you have.
Parents
Chris Engle
over 9 years ago
JamieRae and Joe - Thanks for your reply. I think we figured it out. We're creating the numeric hierarchy using a Visual Basic function that determines the level of indention on a cell. I'll keep you posted on our progress.
Cancel
Up
0
Down
Reply
Cancel
Reply
Chris Engle
over 9 years ago
JamieRae and Joe - Thanks for your reply. I think we figured it out. We're creating the numeric hierarchy using a Visual Basic function that determines the level of indention on a cell. I'll keep you posted on our progress.
Cancel
Up
0
Down
Reply
Cancel
Children
No Data