topic Re: rendering define.xml in SAS Health and Life Sciences

rendering define.xml

Peter_Y — Fri, 27 May 2022 01:03:07 GMT

Hello all:

I am now reading the book "Implementing CDISC Using SAS" by Holland and Shostak to learn CDISC implementation. Chapter 2 showed an example of creating define.xml from excel spreadsheet in base SAS. The authors provided SAS code/output & stylesheet on the book site

https://support.sas.com/en/books/authors/chris-holland.html

The sample directory for chapter 2 includes define.xml and define2-0-0.xsl. However, the main output define.xml cannot be properly rendered. Microsoft edge and Chrome displayed an empty page. Firefox displayed contents in define.xml without the proper format.

Interestingly, it was properly shown in internet explorer, which retires soon.

So I suppose something in the define.xml is not supported by modern browser? Does anyone know what the problem is and how to fix it?

This makes me worry about learning CDISC implementation in SAS with this book. Are there any other good (and more recent) references/resources?

Thanks,

Peter

Re: rendering define.xml

ballardw — Fri, 27 May 2022 09:06:43 GMT

How about first showing the LOG of the code that you submitted that created the output with all the notes and messages generated. Copy the text from the LOG and paste into a text box opened on the forum with the </>. That way we have a chance of knowing what you did.

XML not rendering in Excel can be a setting issue as I had to spend a moderate amount of time getting Excel to show XML as data after our "upgrade" to Office 365 as Excel did not want want to use XML files as data by default.

Re: rendering define.xml

Ksharp — Fri, 27 May 2022 12:51:32 GMT

I got the same problem as yours . I think it is not problem from code of book, it is about browser Microsoft edge or Chrome themselves.

The best way to create define.xml is using the software Pinnacle 21 . It is totall free or You can buy SAS software to generate define.xml
https://www.pinnacle21.com/downloads

And here is my data step code for define.xml
https://communities.sas.com/t5/SAS-Communities-Library/Create-Define-xml-file-by-data-step/ta-p/720439

Re: rendering define.xml

lexjansen — Fri, 27 May 2022 22:17:32 GMT

It is not a problem with the XML. The fact that Chrome and Edge do not render the Define-XML file is because of security issues. No modern browser allows the rendition of XML by applying an XSL file within the browser. Internet Explorer was the only browser that still allowed it. But, as you mention, IE has long been abandoned by Microsoft, and soon will be end-of-life. You can use PROC XSL in SAS to create an HTML file from the XML and the stylesheet that can be opened by any browser. PROC XSL can be limited, so here is another solution to create HTML: https://swhume.github.io/blog-2022-generate-html-from-xml.html

Re: rendering define.xml

kevinkk — Wed, 17 Jul 2024 03:04:51 GMT

"PROC XSL can be limited"

Could you explain some details about the limitations? What should we pay attention to if we want to use PROC XSL?

Re: rendering define.xml

lexjansen — Thu, 18 Jul 2024 20:25:40 GMT

One thing that I ran into is that PROC XSL does not work well, when your stylesheet imports other stylesheets. If I remember well, it had issues resolving relative paths that were used for including other stylesheets.

Re: rendering define.xml

kevinkk — Fri, 19 Jul 2024 03:30:38 GMT

Hi Lex,
Thanks for your explanation and will note this in daily work; Currently our project would merely use the official released stylesheet and it workd well, likes below:

proc xsl
	in="&define_sdtm_root.define_SDTM.xml"
	xsl="&define_sdtm_root.define2-1-0.xsl"
	out="&define_sdtm_root.define_SDTM.html";
run;

I understand that in some cases, we may need to modify the stylesheet, but I'm not sure about the situation you mentioned, "stylesheet imports other stylesheets".

Are you referring including another stylesheet inside the current stylesheet? I don't quite understand why this is done. Could you introduce a bit about it, or are there any papers that introduce this work.

Thank you!

Re: rendering define.xml

lexjansen — Mon, 12 Aug 2024 19:15:58 GMT

When you want to create a modular design, it is quite common to import stylesheets (xsl:import). PROC XSL does not support that.

An extended example of this is how the SAS Clinical Standards Toolkit implemented transformations:

https://github.com/sassoftware/clinical-standards-toolkit/tree/main/standards/cstdefinexml21/source/xsl-repository/DEFINE-XML/2.1/import

Re: rendering define.xml

kevinkk — Tue, 13 Aug 2024 06:09:31 GMT

Thank you Lex, it's truly enlightening, I will explore more details in this area.