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
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 | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
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. The resulting table contains warning and error messages.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2012-03-15 15:40:38 |
Date Created: | 2011-09-22 16:25:25 |