SUPPORT / SAMPLES & SAS NOTES
Problem Note 44385: SAS® Clinical Data Integration 2.3 - CDISC-SDTM compliance and CDISC-SDTM to CRT-DDS transformations fail using external terms
 |  |  |  |  |
Problem:
After running a Job containing either the CDISC-SDTM Compliance or CDISC-SDTM to CRT-DDS transformations for a study that references an external controlled terminology such as MEDDRA, the transformation code will not execute properly, and results table contains warning and error messages including:
ERROR: SASreferences lookup returned no records
WARNING: Reference terminology data set meddra not found
Workaround:
| 1 | Open the Job in SAS Data Integration Studio. Open the properties of the affected transformation, and go to the “Source” tab. Change the affected transformation’s source setting to “User-Written Body”. |
| 2 | In the transformation source, find the “proc sql” invocation that begins with “INSERT INTO work.sasreferences”. |
| 3a | If the transformation is a CDISC-SDTM to CRT-DDS transformation, modify the source of any VALUES clauses that reference any values other than CDISC-CRTDDS 1.0 or CST-FRAMEWORK to read: |
| VALUES ("%nrbquote(CDISC-CRTDDS)", "%nrbquote(1.0)", to replace entries that specifically reference the name of your external terminology. | |
| 3b | If the transformation is a CDISC-SDTM Compliance transformation, modify the source of any VALUES clauses that reference any values other than CDISC-SDTM (3.1.1 or 3.1.2) or CST-FRAMEWORK to read: |
| VALUES ("%nrbquote(CDISC-SDTM)", "%nrbquote(3.1.2)", to replace entries that specifically reference the name of your external terminology. | |
| The second entry can be either 3.1.1 or 3.1.2, depending on the version of CDISC-SDTM in use. | |
| 4 | Save and run the job. The external terminology table should be used properly. The affected transformation’s results table contains a message like: |
| INFO: Reference terminology data set meddra was set to meddra_1.meddra (where the library and table name vary according to the actual external terminology table being referenced). |
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Clinical Data Integration | Microsoft® Windows® for x64 | ||
| Microsoft Windows 95/98 | ||||
| Microsoft Windows 2000 Advanced Server | ||||
| Microsoft Windows 2000 Datacenter Server | ||||
| Microsoft Windows 2000 Server | ||||
| Microsoft Windows 2000 Professional | ||||
| Microsoft Windows NT Workstation | ||||
| Microsoft Windows Server 2003 Datacenter Edition | ||||
| Microsoft Windows Server 2003 Enterprise Edition | ||||
| Microsoft Windows Server 2003 Standard Edition | ||||
| Microsoft Windows Server 2003 for x64 | ||||
| Microsoft Windows Server 2008 | ||||
| Microsoft Windows Server 2008 for x64 | ||||
| Microsoft Windows XP Professional | ||||
| Windows 7 Enterprise 32 bit | ||||
| Windows 7 Enterprise x64 | ||||
| Windows 7 Home Premium 32 bit | ||||
| Windows 7 Home Premium x64 | ||||
| Windows 7 Professional 32 bit | ||||
| Windows 7 Professional x64 | ||||
| Windows 7 Ultimate 32 bit | ||||
| Windows 7 Ultimate x64 | ||||
| Windows Millennium Edition (Me) | ||||
| Windows Vista | ||||
| Windows Vista for x64 | ||||