We might be crossing some streams... but maybe in a useful way. #647 is about collecting entire copies of CDM datamarts for integration into GROUSE for Aim 3. SAS datasets should work there.
I think Brian's question is about collecting subsets of CDM tables, filtered by the RCR cohort. (#659<https://informatics.gpcnetwork.org/trac/Project/ticket/659> for #660<https://informatics.gpcnetwork.org/trac/Project/ticket/660>) Maybe SAS datasets are appropriate there too... I dunno. -- Dan ________________________________ From: Gpc-rcr [gpc-rcr-boun...@listserv.kumc.edu] on behalf of Verhagen, Laurel A [verhagen.lau...@marshfieldresearch.org] Sent: Wednesday, November 29, 2017 1:55 PM To: Gryzlak, Brian M; gpc-dev@listserv.kumc.edu; gpc-...@listserv.kumc.edu Subject: Re: [Gpc-rcr] CDM table export question Hi Brian, I talked with Dan about this a little at the LEC. Our plan was to zip the SAS datasets that we use for running PCORnet queries and send them via the KUMC Secure FTP site for RCR. We would likely need to add a processing step to ensure that the correct study IDs were sent. https://informatics.gpcnetwork.org/trac/Project/ticket/647 Let me know if we need to explore a different approach? Thanks, Laurel Laurel Verhagen | Office of Research Computing and Analytics | Marshfield Clinic Research Institute | 715-221-6433 | verhagen.lau...@marshfieldresearch.org<mailto:verhagen.lau...@marshfieldresearch.org> From: Gpc-rcr [mailto:gpc-rcr-boun...@listserv.kumc.edu] On Behalf Of Gryzlak, Brian M Sent: Wednesday, November 29, 2017 1:34 PM To: gpc-dev@listserv.kumc.edu; gpc-...@listserv.kumc.edu Subject: [Gpc-rcr] CDM table export question Hi everyone, UIOWA is exploring the optimal format for sites to export and share PCORnet CDM table files for the RCR project. Potential issues we are anticipating include file size limitations, data export errors (e.g., using a delimiter that is also included in a field value), etc. Currently our understanding is that most or all sites are using SQL Server or Oracle databases. So we are hoping to issue guidance on these platforms and the running option seems to be CSV file format. Is anyone aware of standards issued by PCORnet that may address the preferred means by which CDM files should be exported for eventual consumption by SQL? Or does anyone have experience in exporting CDM tables for consumption by another party? Thanks, Brian Brian M. Gryzlak, MSW, MA Project Coordinator 2127 Westlawn 319.335.4897 (primary) S533 Pharmacy 319.353.3857 The University of Iowa Iowa City, IA 52242 brian-gryz...@uiowa.edu<mailto:brian-gryz...@uiowa.edu> Health Effectiveness Research Center (HERCe)<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.public-2Dhealth.uiowa.edu_herce_&d=DwMFAg&c=KNVzINr6WAqWApikNSnyDeOu0ck0iFwcrMz92MxUhIs&r=A2PXk2ZGVGBzoEOQMwrrboZc0kb2NWGliRjTa4b3xxXo7HiAVoZaxWlIgfPM_ia9&m=GTiC9-ntz74yWAunLK6r-nUysbgvo-bxUdIdAr0DPtE&s=f-xJRjolUxUIun-rbAkw0lyFtXhSLdQKQFT8jHtyrnE&e=> ________________________________ The contents of this message may contain private, protected and/or privileged information. If you received this message in error, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained within. Please contact the sender and advise of the erroneous delivery by return e-mail or telephone. Thank you for your cooperation.
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
