Home > Data Services > Catalog . Restricted Data . Census . ACS

Search Data Services

Meta Search
search across all the following databases:

Data Catalog
Data and documentation

Common questions and answers.

Entire collection of data resources.

Latest Data News

RSS Feed icon

Health ABC data available through NIA website

More apportionment fun

Great Tweetstorm: Most important year in Economics?

Risk Visualization Theater

Missing girls in China maybe weren’t missing after all

Data Services Knowledge Base:
Data Management: Merging and Concatenating Questions

  1. I am having trouble merging data from 1990 summary data at the census tract level to a crosswalk from Mable/Geocorr.
  2. I would like to merge voting district shapefiles for counties into a state file. I could do this manually in ArcGIS, but it seems like it would take a long time. Is there a solution?
  3. I have run into an ArcMap mxd file that has a cell that I am interested in joining to that is defined as 'string'. This is happening in the counties template within my ArcGIS version 9. The cell has a 5 digit value representing a state and county mixed FIPS code (i.e. 26183 ) How do I go about converting the cell to a numeric one?
  4. I downloaded the separate Cape Area Study Panel Waves 1-2-3 Household and Waves 1-2-3 Young Adult data and now I would like to merge them. How do I do that?
  5. I have duplicate variable names in two data sets that I would like to merge using stata. Do I have to go through and change variable names?
  6. I am trying to merge a file with some restricted use items with the public use version of the data. I'm using stata. When I run the merge, I got a message saying "merge already defined." Is this because some of the variable names are the same?
  7. I want to combine the 2005 and 2006 ACS microdata. What do I do to the weights?
  8. I am having trouble merging person records to the household record. There are around 5,000 person records, but when I finish my merge, I end up with almost 15,000 observations. Here's my code: use "W:\youth.dta" merge hhid using "W:\hhld.dta"
  9. I am trying to match data for 2006 and 2007 from the March CPS so that I can track respondents across the two years. I downloaded the NBER matching files, but they don't seem relevant to data this recent. I also read the information about matching in the CPS codebook, but it's not clear to me how to operationalize their suggestions. Would it be possible to get some assistance with this issue?
  10. Does the American Community Survey (ACS) have data for zip codes?
  11. I want to combine two years of the March CPS to compare with data from a survey that took place over a two-year period. The survey took place in 1994 and 1995.
  12. I have some census characteristics that I want to put into GIS. However, I am having trouble doing so because the FIPS codes in my data are represented as numbers; e.g., 1 for Alabama instead of 01. Likewise, Autauga county is represented as 1 instead of 001. I need an ID variable for Autauga county, Alabama that looks like 01001. How can I convert numeric data back to text in Excel? Right now, state is in one column and county is in the next column.
  13. I have a zip code file that has all zip codes in the nation that I am merging to a person file. When I look at the merged file I see that there is no zip code information for the respondents who live in zip code 48103, which is a valid zip code. Why didn’t the merge work?
  14. I am merging two data sets and end up with too few variables. What is going on?
  15. I am having trouble merging selected files in the Health and Retirement Study (HRS). Some of the IDs are string variables and some are numeric. I am using stata. I can convert the string ID to numeric with the following command: generate HHIDNO = real(HHID); However, when I try to convert the numeric ID back to string, something is not working and thus I cannot merge with the main file where the ID is a string variable. Here is the command I used to convert the numeric ID back to a string ID: generate HHID = " " + string(HHIDNO);
  16. I am unsure how to merge geographic data to a file that I have. I noticed that the census tract numbers do not stand alone in the data file that I downloaded from the census and that the GEO variable is saved as a text variable so I am unable to merge my data sets using that variable. Would you be willing to show me how to link these two data sets if all I have is the census tract number?
  17. I'm interested in looking at birth weight as a measure of child well-being. I can only find this in the Child Development Supplement (CDS), but this is only available from 1997 on.