Thanks @Tom - much appreciated! This is exactly why it is so good to share code. Others can help find the holes in it 🙂 I've fixed the bug, also written a test case to cover it, and refreshed the documentation. The PR is here: https://github.com/sasjs/core/pull/290 ... View more

The updated link (I can't edit my old post): https://core.sasjs.io/mp__cleancsv_8sas.html ... View more

Just "fyi", an alternative approach is to keep the source for your jobs in a GIT repository (subject to all the regular development workflows like branches, linting, and pipelines) and just PUSH the jobs to the relevant SAS environment for processing.   No need to export then.  Your source of truth is the GIT repo.   A writeup of this approach is available here:  https://communities.sas.com/t5/SAS-Global-Forum-Proceedings/Scaffolding-SAS-Projects-With-NPM-and-SASjs/ta-p/726347 ... View more

Glad it can be of service! ... View more

If your goal is to have an Analytics server without metadata, and Viya isn't an option either, you could try SASjs Server - https://github.com/sasjs/server   It's an open source middleware over the Foundation SAS executable.  It's very lightweight, and will even run in a $6 cloud VPS.  Docs are here: https://server.sasjs.io   Today I wrote an installation guide for a fresh cloud machine:  https://sasapps.io/sasjs-server-on-vps ... View more

This macro will create a BASE engine library - I'm sure it could be extended to support other engine types: https://core.sasjs.io/mm__createlibrary_8sas.html If you manage it, feel free to raise a PR! By the way we also have a free metadata exploration tool, if you'd like a copy just send a PM. ... View more

It happens sometimes.  Actually, quite frequently.  It's not necessarily a Viya issue, could be networking / system related.    SASjs is MIT open source, there are no usage restrictions.  You can compile it directly from github:  https://github.com/sasjs/cli   Alternatively, you can build your own tool to poll the status and perform X number of retries for a non-200 response. ... View more

Hi @willi_m ,   We also observed shaky behaviour in long-running jobs in Viya 3.5 - and so we implemented a 'retries' feature in the SASjs CLI, which ultimately fixed the issue (the customer was running many long-running jobs, so was tested quite heavily)   You can find the docs here:  https://cli.sasjs.io/job/   Best, Allan ... View more

I see you're running tests - have you considered using sasjs test?  This approach pushes all your tests as stored processes, executing them from a local CLI.  The approach will also work on Viya, and Base SAS, simply by updating your connection details.   Back to your question - normally you can include your stored process using `proc stp`.  However, if you are just interested in grabbing the source code, you can also use this macro:  https://core.sasjs.io/mm__getstpcode_8sas.html   If you are looking for an environment-agnostic macro, there is also this one:  https://core.sasjs.io/mx__getcode_8sas.html   The test for the above is here!  https://core.sasjs.io/mx__getcode_8sas.html         ... View more

Thanks @SASKiwi for the tag.   Indeed there IS a migration path for AF / SCL and it is - SAS Powered Web Apps.  Whilst @AlanC is right, it's not worth it if you can just create some parameterised jobs, I would put forward that it's really not that hard - especially if you use a framework, such as the one my team have built, namely SASjs.   Using this (open source) approach you can build a web app using traditional Base SAS and deploy it to both SAS 9 EBI (with Stored Processes) and SAS Viya (Jobs) with next-to-zero additional effort.   To re-iterate that once again - you can build an app with SASjs and have it run on ANY platform, be that traditional Base SAS, SAS 9, or SAS Viya.   I'd be happy to provide free advice, we have a bunch of seed apps to speed this process up:  https://github.com/search?q=topic%3Asasjs-app+org%3Asasjs+fork%3Atrue You can also engage our team to just fix it for you:  https://sasapps.io. We're damned fast when it comes to building web apps on SAS because that is literally, all we do!  Right now we're just wrapping up a major AF/SCL modernisation for a government customer.   ... View more

Actually, it can be problematic to gracefully break out of a %include - we often face this problem when building SAS-Powered Web Applications, where it's a common requirement to stop processing and show a message to a user WITHOUT a non-zero return code.   The mechanism we use in SASjs development is to "wrap" the %include using this macro:  https://core.sasjs.io/mp__include_8sas.html   And then afterwards, call the following to pick up any aborts:   %mp_abort(mode=INCLUDE) Source for the above:  https://core.sasjs.io/mp__abort_8sas.html ... View more

You could do this without PIPE or XCMD, in a platform agnostic way - see:  https://core.sasjs.io/mp__dirlist_8sas.html ... View more

For info, this macro will query the dictionary table and return details of the attributes of all the formats in a table (including path):  https://core.sasjs.io/mp__getformats_8sas.html ... View more

We recommend Doxygen.  To make setup easier, the SASjs framework auto-generates the doxyfile according to the sasjsconfig.json project setup.   The docs are here:  https://cli.sasjs.io/doc/   Doxygen also allows you to draw GRAPHS in doxy headers, as well as standard markdown tables, here's an example:  https://core.sasjs.io/mp__stackdiffs_8sas.html   With the SASjs doxygen wrapper, you can also define inputs and outputs to generate a DATA LINEAGE graph.  It does depend on manual config, but at least this way you can draw meaningful graphs.  Here's an overview:   Whilst Doxygen is great for code documentation, it's not so user friendly for user guides / admin guides etc.  For these, we are now standardising on docsify.  Here is our template repo (which we embed directly into the public folder of customer SAS web apps before customisation):  https://github.com/sasjs/docs   In the past we have used mkdocs, which powers the following sites:   * https://docs.datacontroller.io * https://cli.sasjs.io * https://sasjs.io         ... View more