SAS Support Communities

lexjansen · ‎08-12-2024

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

lexjansen · ‎08-12-2024

My original use-case was being able to delete a folder structure cloned from GitHub. I was not able to do this, because the folder structure contained hidden files like .gitkeep and .gitignore. It turns out that the GIT_DELETE_REPO function does exactly what I was looking for. The GIT_DELETE_REPO function deletes a specified local Git repository and all of the contents inside that repository. And actually, the function does not seem to care whether the folder is a Git folder. It will just delete any folder structure. data _null_; RC = GIT_DELETE_REPO('/home/lexjansen/dataset-json-sas'); put RC=; run;

lexjansen · ‎07-18-2024

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.

lexjansen · ‎07-16-2024

Thanks, Kurt!

lexjansen · ‎07-15-2024

Hi Bart, Did you ever find a solution to this? I'm trying to delete a folder structure cloned from GitHub, that contains .gitignore and .gitkeep files. I'm running into the same issue. Thanks, Lex

lexjansen · ‎06-26-2024

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.

lexjansen · ‎11-10-2023

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

lexjansen · ‎11-10-2023

I know I can connect SAS on Demand with SASPy. But I like to to test SAS code that uses Python functions created with PROC FCMP at SAS on Demand. It looks like MAS_PYPATH is not set in SAS on Demand. Is there a way to do this? Thanks, Lex ERROR: masPublish encountered a failure. ERROR: Foreign Language Compilation messages: ERROR: Python compile: ERROR: MAS_PYPATH environment variable is undefined. ERROR: Python compile: ERROR: tkmaspyPublish encountered a failure in tkmaspyConnect, rc=0x803FC26A. ERROR: Unable to publish program for foreign language execution. ERROR: Error reported in function 'python:PUBLISH' in statement number 6 at line 21 column 6.

lexjansen · ‎01-27-2023

Thanks for the link, @ChrisHemedinger

lexjansen · ‎01-27-2023

Another approach for reading JSON into SAS datasets is using PROC LUA. https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2019/3113-2019.pdf https://www.lexjansen.com/cgi-bin/xsl_transform.php?x=phuse2021#phuse2021.ad06 https://www.lexjansen.com/pharmasug/2021/AD/PharmaSUG-2021-AD-168.pdf Another use case of working with JSON in SAS is Dataset-JSON. Dataset-JSON is a new proposed format to replace the antiquated SAS v5 XPT files for submission of clinical data to regulatory agencies: https://www.lexjansen.com/cgi-bin/xsl_transform.php?x=pharmasug2022#pharmasug2022.ad150

lexjansen · ‎08-09-2022

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.

lexjansen · ‎07-07-2022

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

lexjansen · ‎07-07-2022

CDISC moved from BitBucket to GitHub: https://github.com/cdisc-org/sdtm-adam-pilot-project

lexjansen · ‎05-27-2022

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

lexjansen · ‎05-27-2022

Great idea!

Online Status	Offline
Date Last Visited	‎03-06-2025 01:32 PM

SAS Support Communities

Re: rendering define.xml

Re: convince SAS to "see" hidden files

Re: rendering define.xml

Re: convince SAS to "see" hidden files

Re: convince SAS to "see" hidden files

Re: Export SAS dataset to JSON with missing string variable as null

Re: Running Python on SAS on Demand

Running Python on SAS on Demand

Re: How to read JSON data in SAS

Re: How to read JSON data in SAS

Re: Please end the chaos

Make "hidden" files accessible

Re: convince SAS to "see" hidden files

PROC FCMP: Add support for optional parameters (without using arrays)

Re: Fun w/SAS ODS Graphics: Total Ellipse of the Heart

Re: Add SAS Packages Framework to the SAS Base/Viya

Re: rendering define.xml

Re: convince SAS to "see" hidden files

Re: Export SAS dataset to JSON with missing string variable as null

Re: Is there any future for Clinical Standards Toolkit?

Re: rendering define.xml

Re: convince SAS to "see" hidden files

Re: rendering define.xml

Re: convince SAS to "see" hidden files

Re: convince SAS to "see" hidden files

Re: Export SAS dataset to JSON with missing string variable as null

Re: Running Python on SAS on Demand

Running Python on SAS on Demand

Re: How to read JSON data in SAS

Re: How to read JSON data in SAS

Re: Is there any future for Clinical Standards Toolkit?

Re: CDISC pilot data

Re: CDISC pilot data

Re: rendering define.xml

Re: Add SAS Packages Framework to the SAS Base/Viya

SAS Analytics Explorers

SAS Inner Circle Panel

Follow Us

What is...