Health Economics

I am working for the economics professors in the Health Center. They are trying to determine 1) if people with insurance go to the hospital less during recessions and 2) if as a result, doctors substitute for this loss of income by either preforming more procedures on their medicare patients. The data set we’re working with tracks all patients in Florida hospitals from 1997 to 2008 (about 14M patients). My job is to “clean” the data, which basically involves getting it into a format that the Professors can easily run regressions on.