A partial ETL of SEER Medicare data into OMOP CDMv4
Outcomes Insights ETLed a subset of SEER Medicare data in preparation for a demonstration of Jigsaw to NCI in November, 2014. As members of the CMS ETL Working Group, we believed it might be helpful if we provided the OHDSI community with the SAS code we used to perform this incomplete ETL of SEER Medicare into OMOP CDMv4.
Please note the SAS code is for reference only and not intended to be reusable. It is also not intended to serve as a basis for implementation of future ETLs.
The ETL only generates CDMv4-compatible CSV files for the following tables:
- Person
- Condition Occurrence
- Procedure Occurence
- Visit Occurence
- Payer Plan Period
- Observation Period
- Death
Outcomes Insights created a partial ETL specification which contains additional information about this ETL implementation.