We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Data Extraction/ SAS

Hi All,

We are trying to extract data for SAS and we are getting the following issues:

1. for PDATE fields (Partial Date) it says the field does not have a length attribute and we cannot extract data
2. It says the fields have "no ItemDef element". What is this ItemDef element and how can we correct it?

We really appreciate any comments or suggestions.



Thanks
Saeed.

Comments

  • Hi All,

    We are trying to extract data for SAS and we are getting the following issues:

    1. for PDATE fields (Partial Date) it says the field does not have a length attribute and we cannot extract data
    2. It says the fields have "no ItemDef element". What is this ItemDef element and how can we correct it?

    We really appreciate any comments or suggestions.



    Thanks
    Saeed.
  • Dear Saeed,

    I created a page on SAS here, covering the issue with partial dates and mentioning ItemDef elements (not sure if it covers your issue):
    http://en.wikibooks.org/wiki/OpenClinica_User_Manual/SAS

    “CDISC ODM 1.3 includes a specification for a data type called partial date, which SAS can't import (it throws an error when you try to read the file). You may choose to not have partial dates in your study and use a text field instead, validated by a regular expression. Alternatively you can modify the XML export before it is imported to change partial dates to text fields (see below).”

    Let me know if you are seeing any other issues (and if so, which version of OC are you using?).

    Yours,

    Michael
    Sent: 23 July 2012 15:40
    To: [email protected]
    Cc: [email protected]
    Subject: [Users] Data Extraction/ SAS

    Hi All,

    We are trying to extract data for SAS and we are getting the following issues:

    1. for PDATE fields (Partial Date) it says the field does not have a length attribute and we cannot extract data
    2. It says the fields have "no ItemDef element". What is this ItemDef element and how can we correct it?

    We really appreciate any comments or suggestions.



    Thanks
    Saeed.

    The University of Dundee is a registered Scottish Charity, No: SC015096
  • mvirtosumvirtosu Posts: 276 ✭✭
    Saeed,

    To answer your 2nd question, ItemDef are elements that describe each variable/question on your CRFs. If you have questions on your CRFs, you should have a bunch of these elements in your ODM files. Here is an example:




    Current





    Hope this helps,

    Mihai
    Sent: Monday, July 23, 2012 8:40 AM
    To: [email protected]
    Cc: [email protected]
    Subject: [Users] Data Extraction/ SAS

    Hi All,

    We are trying to extract data for SAS and we are getting the following issues:

    1. for PDATE fields (Partial Date) it says the field does not have a length attribute and we cannot extract data
    2. It says the fields have "no ItemDef element". What is this ItemDef element and how can we correct it?

    We really appreciate any comments or suggestions.



    Thanks
    Saeed.
This discussion has been closed.