This is a nice trick, but it is not going to be very efficient for very large datasets with lots of character data. I wish SAS supported null for missing character data in JSON. ... View more

Thanks, Chris, I get that. SAS OnDemand is really a vanilla SAS environment to get 'a taste of SAS'. I appreciate your detailed response. ... View more

Thanks, @ChrisHemedinger .   After some recent exposure to FHIR,  I feel the reference to FHIR data as JSON might be a little confusing.  An access mechanism for FHIR data (the Bulk API, which is suited for large analytical datasets) provides data in NDJSON format and the proper parsing of such data is an operation that some teams are paying attention to.  Just a thought. ... View more

Great idea, great work, should be on the SAS ballot. Gerry ... View more

There are also a number of presentations that have been given over the years about the Clinical Standards Toolkit. Go to https://www.lexjansen.com/cgi-bin/saspapers_query.php  and search for: TITLE contains: clinical + standards + toolkit This will give 34 results. ... View more

Thanks Chris That will be a great asset as a companion to the presentation. And I am sure you are a step ahead - but a link from the EXPLORE presentation video to that location would mean easy to find. ... View more

Might be, but 'tarheel13' was not on your badge 😉 ... View more

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 ... View more