MCW had the exact same problem with RESULT_NUM being seen by SAS as a character field despite being numeric in our source RDMS table (Oracle).
For us this was caused by the data_step_view_prep.sas code which explicitly forces the RESULT_NUM field to character (which was how it was originally mis-specified in the first CDM3.0 design). Deleting that explicit conversion from the data_step_view_prep.sas fixed the issue for us. Best regards, Alex Stoddard Biomedical Informatics Software Engineer CTSI Date: Tue, 11 Jul 2017 13:52:42 +0000 From: Michael Prittie <[email protected]<mailto:[email protected]>> To: Steger Donald A <[email protected]<mailto:[email protected]>>, "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Cc: Mish Thomas F <[email protected]<mailto:[email protected]>> Subject: Re: Question on CDM v3.1 Run Message-ID: <d58a4031.27e40%[email protected]<mailto:d58a4031.27e40%[email protected]>> Content-Type: text/plain; charset="us-ascii" Hi Don, We are getting the same error here at KUMC. Are you using data step views? I am currently testing whether a small change to our data_step_view_prep.sas will fix this. Best, Michael From: Gpc-dev <[email protected]<mailto:[email protected]><mailto:[email protected]><mailto:[email protected]%3e>> on behalf of Steger Donald A <[email protected]<mailto:[email protected]><mailto:[email protected]><mailto:[email protected]%3e>> Date: Tuesday, July 11, 2017 at 7:41 AM To: "[email protected]<mailto:[email protected]><mailto:[email protected]><mailto:[email protected]%3e>" <[email protected]<mailto:[email protected]><mailto:[email protected]><mailto:[email protected]%3e>> Cc: Mish Thomas F <[email protected]<mailto:[email protected]><mailto:[email protected]><mailto:[email protected]%3e>> Subject: Question on CDM v3.1 Run Hello: When running CDM 3.1, the EDC is reporting an error: Required Numeric field is character: LAB_RESULT_CM RESULT_NUM However, LAB_RESULT_CM.RESULT_NUM is already defined as numeric(15,8) Is this a possible error in the EDC Report? How can we fix this error? Thanks, Don Don Steger Senior Data Management Developer Enterprise Analytics (EA) UWHealth (608) 720-6612 [email protected]<mailto:[email protected]><mailto:[email protected]> _______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
