rendering define.xml

[Peter_Y]

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

[ballardw]

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.

[Ksharp]

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/7204...

[lexjansen]

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