Hi there, I am a Grad student and I am working with administrative health data. I am working with 4 different databases that will allow me to locate a patient based on which database they are in. I am wanting to create a new data set and all it would have is all the patient IDs as observations and then the variables would be dates 1 through to 365 of a given year. The trick is that I want to write a program that will scan the 4 databases for each day variable and if a patient ID is found in that database on the given day a database specific flag will be returned to the set in the correct observation. Ideally this gives me a data set that I can see any time over a year a patient has used a health service from the 4 different data bases. Is this possible? More basic than that I am curious how I can transpose a given data set. As a hypothetical the data I am working with has patient's visits in chronological order as observations. Something like this: Patient ID Visit Date 1 1/25/2015 1 5/26/2016 4 6/14/2013 5 7/7/2010 5 9/15/2015 Now what I want to do is create a data set where each observation is a patient and the variables are the different visit dates. Something like this: Patient ID 1 2 1 1/25/2015 5/26/2016 4 6/14/2013 5 7/7/2010 9/15/2015 Is it possible to create a new data set that references the old one to sort of transpose the visit dates? Thank you for any input. It is much valued.
... View more