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

RE: OpenClinica - import to SAS

Length attributes will be available in OpenClinica-2.2 for
datatype="text" and datatype="integer".

Yufang Wang
Akaza Research
400 One Kendall Square
Cambridge, MA 02139
tel: 617.621.8585 x.26
www.akazaresearch.com
www.openclinica.org
Open Source Platform for Clinical Research
~ OpenClinica Enterprise ~ Ask me about professional training, support,
and services for OpenClinica

-----Original Message-----
Sent: 22.November.2007 14:20
To: [email protected]
Cc: Jeff Halperin; Yufang Wang
Subject: OpenClinica - import to SAS
Hi all,
I tried to import an OpenClinica 2.0.1 data in ODM (XML) format to the
SAS
and I got the the following error:
ERROR: ItemDef OID='IT.Initials.2' has no Length attribute.
where "Initials" is one of the CRF items :-(
I changed the imported XML file by hand - I add the texts Length="255"
for
DataType="text" and Length="16" for DataType="integer".
After this modication was the import to SAS successful.
Please - do you know any way how to import data to SAS without this post
editation ?
Thanks for help.
Karel Beber
A-Pharma
Czech Republic
SAS code version 1:
FILENAME XMLINP 'c:\ ... \Export_002_odm.xml';
PROC CDISC MODEL=ODM READ=XMLINP formatActive=YES formatNoReplace=NO;
ODM ODMVersion = "1.2" ODMminimumKeyset=NO;
CLINICALDATA OUT = Test SASDATASETNAME = "DE";
RUN;
FILENAME XMLINP ;
SAS code version 2:
filename odm 'c:\ ... \Export_002_odm.xml';
libname odm xml xmltype=CDISCODM FormatActive=YES FormatNoReplace=NO
FormatLibrary="Work";
data xxx;
set odm.DE;
run;
XLM file:
...


Patients Initials.


...
changed to


Patients Initials.

This discussion has been closed.