Comments (6)
Sorry to hear that. If you're willing and able, please feel free to submit a pull request with your SAS SQL implementation if you'd like it to live in this repository.
from etl-cms.
Also, don't hesitate to let us know if you have any questions on the ETL spec, or the test cases.
from etl-cms.
Here is the repository with what we have so far (not much, I admit):
https://github.com/fabkury/cms_vrdc_etl
In short, this is an ETL code built to be executable inside the CMS VRDC. It is not a port of your ETL, but your work was good as an orienting example.
We will be presenting the rationale and challenges about this in-VRDC ETL in a poster at the OHDSI Symposium next month. We referenced your Python work in the poster.
from etl-cms.
Can you run Java in the CMS VRDC? If so, consider Jython.
How about .Net stuff? If so, IronPython might work.
On the other hand, SQL might be a more natural way to represent the ETL. I haven't studied the details.
from etl-cms.
Now that I have looked into the details a bit, using SQL does seem to be a good approach. In fact, our SamTheEagle project mostly uses SQL. We load the CSV files into Oracle and then use SQL to transform the data.
Our target is i2b2 rather than OMOP, but I think it would be interesting to factor out the common bits.
We haven't managed to publish the SQL code yet. IOU.
from etl-cms.
Closing this request to port the repository to another language.
from etl-cms.
Related Issues (20)
- Column mismatch in create_CDMv5_tables.sql and load_CDMv5_vocabulary.sql HOT 1
- Error on Step 5 of Python ETL process HOT 2
- Person ID as integer, CMS's synthetic data has string IDs HOT 1
- CMS RIF to OMOP ETL? HOT 2
- CMS ACO CCLF --> OMOP V5 HOT 1
- md5 sums don't match files - https://github.com/OHDSI/ETL-CMS/blob/master/python_etl/README.md HOT 4
- Issue while running python code to get the claims data HOT 6
- Memory issue of steps 5 in ETL Script HOT 9
- drug_era, observation_period, cost column mismatch HOT 5
- Update ETL logic to support CDM 6.X HOT 5
- CDMv5.2 is not accessible HOT 2
- KeyError: 'Place of Service' HOT 3
- location_id is null for all care_site records HOT 3
- missing 'DE1_0_2010_Beneficiary_Summary_File_Sample_1.zip' HOT 5
- FTP server down? HOT 1
- Downloading final data HOT 1
- Incorrect URL to one source Synpuf file HOT 5
- Updating to newer CDM versions + upload R script available HOT 1
- key error '40213148'
- Convert CMS SynPUF to OMOP v5.4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from etl-cms.