Question

Status:Closed    Asked:Mar 06, 2014 - 01:27 PM

Could I get the 2000PUMAsASCII.txt file in excel format?

For my research project, I need to calculate the pouplation by city and county. For this purpose I am using the 2000PUMAsACSII.txt. However, when I try to import the txt file into stata (or excel) some columns are combined and I cannot identify the variables anymore. I already used different formats (tab, space, semicolon delimit) but nothing is working. Is it possible to obtain the file in excel format?


Thank you very much

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Joe_Grover

Staff

Unfortunately, I cannot provide the excel document here because the file is to large to link. Instead I have attached a text file with the 2000PUMAs data in tab delimited form. Copying all of the contents of the file should paste nicely into excel. You will still need the original text file for the explanation and column headers.


I hope this helps.

 

Mar 06, 2014 - 03:12 PM

0
0
Report it

Answers

Thank you for the file.

It works now!


 

Mar 10, 2014 - 04:31 PM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

zero wages
Sample weights
tehre is information about the size of the firm in the Census/ASEC datasets?
Sample selection for a study of a subgroup over time?
Is it possible to get information on municipality or district of respondent i...
Weekly earnings and usual hours
Login   |   Register

Recently Active Members

View More »

Share |