SAS/Stata/or Database loop programming task.

I have an individual record-level database of deaths in Florida for one year. Most of the records contain the census tract of the individual. All records contain race and hispanic origin. However, some could not be geocoded and only the county is noted. I also have data, at the census tract level on population by race and hispanic origin. The task is to probabilistically assign the non-geocoded deaths in each count to census tracts. So, if a county has 300 deaths that are not geocoded, they should be assigned to the tracts where they are most likely to have occurred, based on the race of the person and the population of the county. (The way I thought about writing the code was a loop. Calculate the difference between each tract's share of the population of a certain type and that tract's deaths of that type. Assign an unassigned death to the maximum likelihood census tract. Update the share differences, proceed to the next unassigned death). There are 600000 deaths of which about 12000 are unassigned to census tracts. Currently these are just ascii files.

Must be an experienced programmer.

Evner: Databehandling, Ingeniørarbejde

Se mere: loop stata, stata loop, sas loop, loops stata, loop sas, sas data stata loop, stata database, write loop stata, stata programming, writing programming in c++, s programming, race writing, programming loop, programming if, programming database, origin of writing, loop programming, if programming, for loop in c programming, for loop c programming

Om arbejdsgiveren:
( 30 bedømmelser ) New Haven, United States

Projekt ID: #416044

Tildelt til:


I have a long experience of working on STATA, can do this task very quickly and efficiently....

$500 USD in 2 dage
(0 bedømmelser)

8 freelancere byder i gennemsnit $538 på dette job


Hello - Please see PMB for details of my bid. Thank you. Chandra Ram.

$350 USD in 2 dage
(94 bedømmelser)

Hello, I can provide you a solution.. Your regards,

$750 USD in 10 dage
(2 bedømmelser)

Please see detail on PMB. regards

$700 USD in 5 dage
(3 bedømmelser)

Hello! Please read PM.

$250 USD in 5 dage
(3 bedømmelser)

Hi We are new to SAS Development, We have more than 2 years of Intense SAS Training Exp in BASE -SAS and Advance SAS. We have professionals working with us with more than 10 Years of IT Exp in Data Integration Flere

$400 USD in 7 dage
(0 bedømmelser)

the loop method doesn't seem to work but it can be done with some statistical methods

$600 USD in 7 dage
(0 bedømmelser)

Hi- I have 15+ years of SAS programming, and a M.S. in Statistics. From what I've read, you're going to need both programming and stats help with this merge. I'd be happy to help - Stephanie

$750 USD in 3 dage
(0 bedømmelser)