Status:Closed    Asked:Jan 02, 2014 - 08:04 AM

In 2012 ACS data, why am I getting breaks where all variables have 000?

When I pull unformatted data from 2012 ACS into Excel, about every 50 lines or so is what looks like bad data, where it starts 2012 (year) 0 (datanum) and then a serial number, followed by only zeros for the rest of the variable. Are these bad responses that should be discarded, or should I wait for formatted data to come through? I've never had this problem before, but I've only used formatted data.

I'm trying to use the unformatted .dat files because I've been waiting for three days and haven't gotten anything yet, and I need the numbers soon.

Do you have the same question? Follow this Question

Staff Answer




I looked into your data extracts and it appears that the CSV formatted data is now available for your last two extracts.

I was unable to replicate your issue reading the fixed-width data file into Excel. It sounds like your file was not fully decompressed. If you still want to open the fixed width data file in Excel, I would recommend redownloading the file, decompressing the file using a program like 7-zip, then open the file using Excel's Text Import Wizard.

I hope this helps.


Jan 02, 2014 - 10:22 AM

Report it


Change in CPS EMPSTAT (A-LFSR Labor force status recode) in 2001?
I have an extract 2001 to 2015. Total number of people: 4 million, but in bir...
Why are there fewer counties in the 1950 1% sample compared to the 1940 1% sa...
Is the value of INCWKCOM included in the value of INCDISAB?
Trying to access CPS online analysis tool
ACS METRO variable construction
Login   |   Register

Recently Active Members

View More »

Share |