Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Difficult merging process


From   Nathan Hutto <nathandavidhutto@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: Difficult merging process
Date   Mon, 20 Dec 2010 20:46:27 -0500

Hi all,

I am attempting to merge two data sets in a way that is new to am and
am having trouble figuring out how to do so. One data set contains
geo-coded birth certificates and the other contains weather events. I
want to determine whether a mother was exposed to a weather event
during the course of her pregnancy. I have the birth date and
gestational length, so I can determine the dates of gestation by
subtracting one from the other. I also have the latitude and
longitude, address, city, and state of each pregnancy and weather
event. For this case, exposure to a weather event would be defined as
being pregnant when a weather event occurred in close proximity.

I'm ok with over-merging a little bit; I can determine the exact
exposure by using one of Stata's length commands that can calculate
distance with latitude and longitude. But given that many people in my
data are exposed to a number of weather events, I'd like to whittle
down the amount of false positives.

Any thoughts on this?

Thank you,
Nathan
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index