Year Two - Margo

Margo's IRB proposal has been approved and the next step is for her to acquire the data. With the aid of an informatician, Margo will obtain the data of interest from the EMR. This can be a lengthy process and has many pitfalls. It is important for Margo to understand the many issues involved in acquiring data from Electronic Medical Records, which include but are not limited to:

Now that Margo has dealt with the above issues, she needs to get her data set into an analyzable form. To do this she brings her data into an excel spreadsheet such that each row corresponds to one subject and each column corresponds to one variable. Along with this spreadsheet, Margo prepares a codebook which describes what the variable in each column stands for, how it's measured, and the possible values that it can take on. She also notes how missing values are notated in the data set. Lastly, Margo removes any patient identifiers before sending the data to the statistician.

Return to the previous page.

-- ErinEsp - 07 May 2012