Subject: Re: local govt budget data
From: Eric Rasmusen
Date: Mon, 21 Nov 2005 11:46:32 -0500
To: [email protected]
CC: Mark Ramseyer

Hmm, that is bad news about there being so much missing data for the local government budget instrument. I'm not sure what to do.

 Maybe we should try using that instrument and see if it makes a difference. If it doesn't, we might conclude that we don't need an instrument, and use the full dataset.


Eric




[email protected] wrote:
Dear Sir,

      I extracted local govt budget and number of full time employees data. This is county level data. I am attaching the file. The bad news is that data for 733 counties are missing. That is about 1/3 of all observations. I think we shouldn't use this instrument because of missing data.
      This data was in two parts, one file in fixed format containing the actual data, the other file also in fixed format containing names of county etc.
      The first file did not have around 733 observations which were in second dataset. After I merged the two, there are missing values for 733 observations which were originally in first dataset. The _merge variable will say "only in master dataset" for these observations. You can use tab _merge to see this.
      The URL for these dataset is
 http://www.census.gov/govs/www/apesstl02.html

Sincerely,
Manu Raghav