About AllanBowe

AllanBowe · ‎03-25-2022

Hi Andres, This macro can be used to take a hash of all the values. It will work with high precision decimals, special missings, and very wide character variables. It's the same algorithm we use to diff uploads in Data Controller for SAS. The ID will have a length of $32. https://core.sasjs.io/mp__md5_8sas.html Best, Allan

AllanBowe · ‎03-25-2022

I didn't realise the OP was referring to Viya But if so, there are some ready made macros in SASjs for client registration, authentication & refresh: * https://core.sasjs.io/mv__registerclient_8sas.html * https://core.sasjs.io/mv__tokenauth_8sas.html * https://core.sasjs.io/mv__tokenrefresh_8sas.html

AllanBowe · ‎03-19-2022

As @SASKiwi mentions, we've built a plugin for VS Code that currently allows you to highlight and run, or run an entire program in Viya. We plan to extend support to SAS 9 EBI and Base SAS soon. In the meantime you have two further options for running code: 1. Use the SASjs CLI in terminal - https://cli.sasjs.io/run/ 2. Use the editor in SASjs Server (a REST API and Studio editor over Foundation SAS) - https://github.com/sasjs/server If you need help setting up, feel free to send a private message.

AllanBowe · ‎03-15-2022

@Residentx10 - I'm with you. Did you know that Microsoft have started 'switching off' windows laptops in Belarus and Russia? Users are literally being logged out due to "expired licences". I'm totally against the war but having a machine shut itself down on the basis of a registration address just goes to show that individuals and companies may be better off with operating systems / server environments that are truly within their control. On that note, we also support SASjs on VS Codium, which is essentially VS Code but without the microsoft (telemetry). See: https://open-vsx.org/extension/sasjs/sasjs-for-vscode

AllanBowe · ‎03-15-2022

Our (strong) recommendation, for professional SAS developers, is - VS Code Using plugins such as SASjs and tools such as the SASjs CLI you have (almost) everything you need in an IDE: * Terminal access * Ability to compile / build / deploy SAS code to all server types (Foundation SAS, SAS 9 EBI, SAS Viya) * Ability to run tests and query the test results * Ability to generate HTML documentation for SAS code * Ability to execute Jobs and Flows * Folder management * SAS linting * Scaffolding for 'quick start' of SAS projects * Local web server for debugging frontends * Syntax highlighting * Vast array of useful marketplace extensions such as git lens I could go on and on! VS Code is great! Thanks to cloud providers like gitpod, you can open ANY github repository in a cloud instance of VS Code by simply adding "gitpod.io/#" at the beginning of the url. Check this out: https://gitpod.io/#github.com/sasjs/template_jobs

AllanBowe · ‎03-15-2022

It doesn't solve the table access requirement, but the following could be a helpful 'shot gun' approach to STP logging: https://rawsas.com/event-logging-of-stored-process-server-sessions/ If you'd like to track and control (manual) changes to tables in SAS, our team also produces this product, which is free for 5 users: https://datacontroller.io

AllanBowe · ‎03-13-2022

Tests are an ESSENTIAL part of any non-trivial SAS project. In this video we explore the SASjs approach to writing, compiling, deploying and executing tests. Tests can be written for SAS Jobs, Services and Macros. Each Job/Service/Macro may have one or more tests associated (using name.test.sas or name.test.[integer].sas notation). Test coverage is shown during the _compilation_ of the SAS project. Test results are shown after deploying and executing the tests. SASjs Test works on Viya, SAS 9, and Foundation SAS. Self-contained tests are deployed as content to the SAS Logical folder (SAS Drive, SAS Metadata, or SASjs Drive). For more info on SASjs test, see documentation: https://cli.sasjs.io/test

AllanBowe · ‎03-11-2022

Is this the macro (function) you are looking for? https://core.sasjs.io/mf__existvar_8sas.html

AllanBowe · ‎03-10-2022

does this macro give you what you need? https://core.sasjs.io/mm__getdirectories_8sas.html

AllanBowe · ‎03-10-2022

We created a linter, which can enforce a series of best practices on SAS code. There's an article on it here: https://communities.sas.com/t5/SAS-Hacker-s-Hub/Hacker-tip-5-Linting-SAS-Code/m-p/801098#M125 Over time, with the help of the community (or as our organisation grows, through projects and sales of Data Controller), we will enhance and improve this library.

AllanBowe · ‎03-09-2022

SASjs Lint can quality-check SAS code before it is deployed or committed to a GIT repository. You can use it from the SASjs VS Code Extension, or from commandline with the SASjs CLI. Links: SASjs CLI Docs: https://cli.sasjs.io/lint/ VS Code Extension: https://github.com/sasjs/vscode-extension Underlying library: https://github.com/sasjs/lint

AllanBowe · ‎03-08-2022

In this tip we we show two ways to create & deploy jobs on Viya 4 - first, using a SASjs Core macro, and second, using the SASjs CLI. Macro docs: https://core.sasjs.io CLI docs: https://cli.sasjs.io Template repo: https://github.com/sasjs/template_jobs

AllanBowe · ‎03-07-2022

Many developers prefer to keep their GIT repository as the 'ultimate source' of their project, and deploy regularly to Viya for code execution. For this, it can be necessary to create the necessary folder tree in SAS drive programmatically. This video demonstrates two approaches for doing this - the first, using SAS code, the second, using the SASjs CLI. The relevant macros if you plan to use SAS code are: mv_createfolder mv_deleteviyafolder The relevant commands for doing this with the SASjs CLI are: sasjs folder create sasjs folder delete

AllanBowe · ‎03-07-2022

If you're looking for a framework to unit test SAS Macros, web Services and Jobs - you can check out the SASjs CLI: https://cli.sasjs.io/test It works identically across Viya, SAS 9, and Foundation SAS. So you can build your unit tests on both sides and compare the results (in JSON, XML, CSV, and LCOV formats)

AllanBowe · ‎03-06-2022

You could simply create a hash of each dataset, and compare the hashes in one go. Here's a macro that would help: https://core.sasjs.io/mp__md5_8sas.html To clarify - this macro hashes the VALUES, not the metadata. So things like creation date, labels etc are ignored. EDIT: I shared the wrong macro. The above WILL hash values, but this macro will be much easier to use as it will accumulate the hash across every row: https://core.sasjs.io/mp__hashdataset_8sas.html