Hi, all, As Susan mentioned in the dev-call today, there were some bugs in the SAS codes I sent out last night. Thanks to her help and Kris’s testing, I’m sharing this revised SAS script for you to run. These new codes have also been updated in the original GPC DROC request.
Please let me know if you have any questions! Song From: Xing Song Sent: Monday, August 3, 2020 11:38 PM To: gpc-dev@listserv.kumc.edu; gpc-d...@listserv.kumc.edu Cc: Maren Lowrance <mlowra...@kumc.edu>; Susan Rea <susan....@imail.org> Subject: SAS codes updated - RE: [GPC-DROC] GPC DROC Request Submission #81 Hi, all, If you have already fulfilled the request and haven’t received any follow-up inquiry from me, please ignore this message! If you haven’t run the query by today (08/03), please run the revised scripts which can be downloaded either from the DROC survey or from this email. Since these changes are made two days before the original deadline, we would like to extend the request for another week (due 08/13). Please let me know if you have any questions! We really appreciate your support! Xing Song, Ph.D. Research Assistant Professor Center for Medical Informatics and Enterprise Analytics University of Kansas Medical Center Email: xs...@kumc.edu<mailto:xs...@kumc.edu> Phone: (913)-588-7605 From: Xing Song Sent: Thursday, July 30, 2020 5:36 PM To: gpc-dev@listserv.kumc.edu<mailto:gpc-dev@listserv.kumc.edu>; gpc-d...@listserv.kumc.edu<mailto:gpc-d...@listserv.kumc.edu> Cc: Maren Lowrance <mlowra...@kumc.edu<mailto:mlowra...@kumc.edu>>; Susan Rea <susan....@imail.org<mailto:susan....@imail.org>> Subject: SAS codes added - RE: [GPC-DROC] GPC DROC Request Submission #81 Hi, All, Thanks to Susan Rea’s share, now we have the SAS extraction codes added to DROC request #81! I have modified Request #81<https://redcap.kumc.edu/redcap_v9.5.25/DataEntry/index.php?pid=16659&id=81&event_id=44812&page=gpc_droc_oversight_request> with a zip file containing both SQL and SAS codes. Hope it would provide more flexibility for sites to collect the prelim counts. Again, thank you, Susan, for sharing the codes with us all! Please let me know if you have any questions! We really appreciate your support! Xing Song, Ph.D. Research Assistant Professor Center for Medical Informatics and Enterprise Analytics University of Kansas Medical Center Email: xs...@kumc.edu<mailto:xs...@kumc.edu> Phone: (913)-588-7605 From: Maren Lowrance <mlowra...@kumc.edu<mailto:mlowra...@kumc.edu>> Sent: Tuesday, July 28, 2020 1:33 PM To: Xing Song <xs...@kumc.edu<mailto:xs...@kumc.edu>> Cc: Roush, Steffani <roush.steff...@marshfieldresearch.org<mailto:roush.steff...@marshfieldresearch.org>> Subject: Re: [GPC-DROC] GPC DROC Request Submission #81 Hi Song, Let’s modify the droc and then can send a notification to the gpc-droc and gpc-dev listserv for them to review the REDCap to pull the new code. Thanks, Maren From: Xing Song <xs...@kumc.edu<mailto:xs...@kumc.edu>> Date: Tuesday, July 28, 2020 at 1:28 PM To: Maren Lowrance <mlowra...@kumc.edu<mailto:mlowra...@kumc.edu>> Cc: "Roush, Steffani" <roush.steff...@marshfieldresearch.org<mailto:roush.steff...@marshfieldresearch.org>> Subject: RE: [GPC-DROC] GPC DROC Request Submission #81 Sounds good. I will try to get the SAS query developed no later than Thursday. A quick question: once I have the SAS query ready, do I go back modifying the DROC request or should I just send it out to sites? Song From: Maren Lowrance <mlowra...@kumc.edu<mailto:mlowra...@kumc.edu>> Sent: Tuesday, July 28, 2020 1:25 PM To: Xing Song <xs...@kumc.edu<mailto:xs...@kumc.edu>>; Roush, Steffani <roush.steff...@marshfieldresearch.org<mailto:roush.steff...@marshfieldresearch.org>> Subject: Re: [GPC-DROC] GPC DROC Request Submission #81 Hi Song, I know we’ve heard from MU, MCRF, and Intermountain. If you develop the SAS we can distribute to everyone and let sites choose. Thanks, Maren From: Xing Song <xs...@kumc.edu<mailto:xs...@kumc.edu>> Date: Tuesday, July 28, 2020 at 11:42 AM To: "Roush, Steffani" <roush.steff...@marshfieldresearch.org<mailto:roush.steff...@marshfieldresearch.org>>, Maren Lowrance <mlowra...@kumc.edu<mailto:mlowra...@kumc.edu>> Subject: RE: [GPC-DROC] GPC DROC Request Submission #81 Hi, Steffani, Thank you for reaching out! Yes. I think I can develop an equivalent SAS script for the summary extraction. However, as I’m more fluent with SQL then SAS, I submitted the request with SQL so that sites with SQL capability or preference can run it first. I will try to get the SAS script out in 1 or 2 days. Maren - May I know which are the sites that prefer SAS scripts and which prefer SQL? Song From: Maren Lowrance <mlowra...@kumc.edu<mailto:mlowra...@kumc.edu>> Sent: Tuesday, July 28, 2020 11:28 AM To: Roush, Steffani <roush.steff...@marshfieldresearch.org<mailto:roush.steff...@marshfieldresearch.org>> Cc: Xing Song <xs...@kumc.edu<mailto:xs...@kumc.edu>> Subject: Re: [GPC-DROC] GPC DROC Request Submission #81 Hi Steffani, I’m including Dr. Song who wrote the code. Song – several sites prefer code being shared in SAS instead of SQL. Are you able to provide the code in SAS instead? Thanks, Maren Lowrance Assistant Director of Product Design and Analysis GPC Honest Broker University of Kansas Medical Center 913-588-7688 From: "Roush, Steffani" <roush.steff...@marshfieldresearch.org<mailto:roush.steff...@marshfieldresearch.org>> Date: Monday, July 27, 2020 at 3:27 PM To: Maren Lowrance <mlowra...@kumc.edu<mailto:mlowra...@kumc.edu>> Subject: RE: [GPC-DROC] GPC DROC Request Submission #81 Hi Maren, Do you know if there are plans to distribute code that hits the CDM tables using SAS? Or are sites expected to rewrite this to work in whatever environment they use? Thanks, [image006]Steffani Roush Research Programmer Analyst Senior | Office of Research Computing and Analytics Marshfield Clinic Research Institute Office: 715-221-6442 | Ext: 1-6442 From: Gpc-droc <gpc-droc-boun...@listserv.kumc.edu<mailto:gpc-droc-boun...@listserv.kumc.edu>> On Behalf Of mwennb...@kumc.edu<mailto:mwennb...@kumc.edu> Sent: Saturday, July 25, 2020 4:00 AM To: mwennb...@kumc.edu<mailto:mwennb...@kumc.edu>; gpc-d...@listserv.kumc.edu<mailto:gpc-d...@listserv.kumc.edu> Subject: [EXTERNAL] [GPC-DROC] GPC DROC Request Submission #81 CAUTION: This email originated from outside of the Marshfield Clinic Health System. Do not click links or open attachments unless you recognize the sender and know the content is safe. Dear GPC-DROC Members, Please review Request # 81<https://urldefense.com/v3/__https:/redcap.kumc.edu/redcap_v9.5.25/DataEntry/index.php?pid=16659&id=81&page=gpc_droc_oversight_request&event_id=44812&instance=1__;!!J7HzeEKFbK9hUUY!d_5xazB1Kt9LEARtfg9yO2LQhGu39ti_4AqDDV8L9iq7vDOfVO5ybvO9dCZPXafOHp8GzGCspD2I$> * Requestor: Jeffery Statland * GPC's Datamart Feasibility Query (counts only) * Title: Cardiac and Respiratory evaluations and interventions for people with myotonic dystrophy (CARE DM) * Deadline: 08-06-2020 * Requested sites are as follows: * All * Submission Link: * If blank, the submission link will soon be populated on the submission link form<https://urldefense.com/v3/__https:/redcap.kumc.edu/redcap_v9.5.25/DataEntry/index.php?pid=16659&id=81&event_id=44812&page=honest_broker_tracker__;!!J7HzeEKFbK9hUUY!d_5xazB1Kt9LEARtfg9yO2LQhGu39ti_4AqDDV8L9iq7vDOfVO5ybvO9dCZPXafOHp8GzKo-HDRb$> Please contact me with any questions. Thank you, Maren Lowrance GPC Honest Broker ________________________________ 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.
<<attachment: care_dm_prelim_cdm_v2dot3.zip>>
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
