Hello,
My dataset is geocoded and a census tract code is attached to each individual. I also have census tract data (aka % poverty, % white, etc.) for the each census tract in the U.S. I used the many to one merge code and now the datasets are merged. But now I want to collapse individuals into census tracts and then delete the rest of the census tracts that don't contain any individuals. I tried the collapse code, collapse childid, by(tract) and I get a 'type mismatch' error code. Any advice how to collapse the individuals into census tracts? Or perhaps different merging advice? I would be so grateful for any advice!
Carlyn
My dataset is geocoded and a census tract code is attached to each individual. I also have census tract data (aka % poverty, % white, etc.) for the each census tract in the U.S. I used the many to one merge code and now the datasets are merged. But now I want to collapse individuals into census tracts and then delete the rest of the census tracts that don't contain any individuals. I tried the collapse code, collapse childid, by(tract) and I get a 'type mismatch' error code. Any advice how to collapse the individuals into census tracts? Or perhaps different merging advice? I would be so grateful for any advice!
Carlyn
Comment