BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
michellexu
Calcite | Level 5

Hi, 

 

when using xmltype=CDISCODM FormatActive=YES FormatNoReplace=NO FormatLibrary="WORK" option, for some reason format has been truncated for start, end and label columns.  Has anyone come across this problem before? 

 

thanks 

Michelle 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Jagadishkatam
Amethyst | Level 16
I believe we will have the length in xml file for the variables start and end, could you please check the length assigned to them, you need to increase the length values for these variables as required.
Thanks,
Jag

View solution in original post

6 REPLIES 6
Jagadishkatam
Amethyst | Level 16

Could you please check the column attributes in the xml file for the respective variables.

 

since you are trying to create the SAS dataset from the xml file, I believe there could be an issue with the data in xml file.

 

Is the name= where we assign the label, is it complete. If you could share the xml data for that portion it will help us.

Thanks,
Jag
michellexu
Calcite | Level 5

hi, 

 

Please see attached pictures.  

 

thanks 


format truncation.PNGxml.PNG
michellexu
Calcite | Level 5

Hi, 

we used the code below.  As the format start and end length for AE is only $16, so the rest of the dataset format has been truncated to 16 characters. However I am not so sure the solution to this problem: 

 

libname out "\\xxx\Sandbox\MX";
filename odm0 '\\xxx\\AU2DATA.xml';
libname odm0 xml xmltype=CDISCODM FormatActive=YES FormatNoReplace=NO FormatLibrary="WORK";
%MACRO dsconv(dsname);

data out.&dsname;
set odm0.&dsname;
run;
proc contents data=out.&dsname VARNUM noprint out = &dsname;
run;
%mend;
%dsconv(AE);

Jagadishkatam
Amethyst | Level 16
I believe we will have the length in xml file for the variables start and end, could you please check the length assigned to them, you need to increase the length values for these variables as required.
Thanks,
Jag
michellexu
Calcite | Level 5

Hi Jag, 

 

problem is solved.  We  are using the most up to date version of the openclinica(3.11), which gives us xml file, mapper and sas_format.sas file.  The sas_format. sas file includes all the formats as well as all the datasets in the XML file. 

 

thank you very much for your suggestions. 

 

If any one intersted: 

https://docs.openclinica.com/3.1/openclinica-user-guide/export-datasets/formats-dataset-files

 

regards

Michelle 

Jagadishkatam
Amethyst | Level 16
Thank you for your response
Thanks,
Jag

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 1040 views
  • 0 likes
  • 2 in conversation