Käynnissä

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.

Taidot: tietojenkäsittely, tekniikka

Näytä lisää: loop stata, stata loop, sas loop, loops stata, loop sas, sas data stata loop, stata database, write loop stata, stata programming, s programming, race writing, programming if, programming database, origin writing, if programming, loop programming, data programming, programming loop, sas stata programmer, stata sas loop, stata simple loop, stata help loop, loop sas database, sas loop database, twitter sas sweden programming

About the Employer:
( 30 reviews ) New Haven, United States

Projektin tunnus: #416044

Myönnetty käyttäjälle:

rahulb84

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

500 $ USD 2 päivässä
(0 arvostelua)
3.4

9 freelanceria on tarjonnut keskimäärin 561 $ tähän työhön

schandraram

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

350 $ USD 2 päivässä
(133 arvostelua)
6.8
ExactSystems

Please see detail on PMB. regards

700 $ USD 5 päivässä
(3 arvostelua)
3.8
musaulker

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

750 $ USD 10 päivässä
(2 arvostelua)
3.7
wsh2

Greetings, once again.. {gentle smile} J writes: "Assign an unassigned death to the maximum likelihood census tract. Update the share differences, proceed to the next unassigned death" Updating the share differen Lisää

749.95 $ USD 7 päivässä
(5 arvostelua)
3.6
kamosion

Hello! Please read PM.

250 $ USD 5 päivässä
(3 arvostelua)
2.9
Shibu71

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 Lisää

400 $ USD 7 päivässä
(0 arvostelua)
0.0
somico

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

600 $ USD 7 päivässä
(0 arvostelua)
0.0
stephguggi

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 3 päivässä
(0 arvostelua)
0.0