Hi Keith, The SAS code that I wrote to build and validate the data-step-views off of our Oracle backend here at KUMC is available on GitHub (kumc-bmi/PCORnet-Diagnostic-Query/data_step_views<https://github.com/kumc-bmi/PCORnet-Diagnostic-Query/tree/master/data_step_views>). If you’re not using Oracle, you would need to modify the code to work with your RDBMS. Let me know if you have any questions. I know that Angela Bos (UTHSCSA) and George Kowalski (MCW) have also used the data-step-view approach, so they might be able to help you as well if you run into any issues getting this working.
Best, Michael Prittie (KUMC) From: <[email protected]<mailto:[email protected]>> on behalf of Wanta Keith M <[email protected]<mailto:[email protected]>> Date: Monday, April 11, 2016 at 7:07 PM To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Subject: SAS views for CDM v3 data characterization query GPC – Is there anyone in GPC that has built the SAS views for the data characterization query? I couldn’t find any files that contain the SAS Views source code for the date and time conversions for the data characterization query for CDM v3. It appears that we have a choice of using them or not. I’m guessing PCORI has a good reason to use them other than for the date/time conversions that is not in the current requirements, that has not been disclosed, so I’d like to try it anyway. If nobody from our group has not, I’ll take the time to do so and give it a shot. Thanks, Keith Wanta (WISC)
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
