Data Controller for SAS® works on Base SAS!

Thanks to #SASjs Server - an open source REST API for SAS - you can run on desktop or your SAS Foundation server.

#DataController is actually lightning quick in this mode!

Do you run Foundation #SAS ? Looking to improve your #DataGovernance ?

Data Controller is free for 5 users. Also available on SAS EBI (Stored Processes) and #Viya (3.5 or 4).

PM for details

https://vid.4gl.io/w/auvPGmR5A3pgJVqFSF7iYA

If you are a #SAS App developer making the foray into Web Development, this article will be of interest.

It explores the process of cloning / building / deploying an app with the bare minimum of dependencies - just @sasjs/adapter and @sasjs/core.

You will need a local instance of NPM and optionally, @sasjs/cli to build and deploy. The example is on #Viya, but could just as easily be SAS 9 EBI, or even Foundation SAS running @sasjs/server.

#sasjs #javascript #js

https://medium.com/swlh/building-an-html5-javascript-css-app-with-sasjs-4cdbdb7c466f

Data Controller for SAS® was deployed at Allianz to enable controlled ingestion of spreadsheet data for a bitemporal reporting system in the actuarial team.

By using #DataController, the actuarial team at Allianz were able to upload data from multiple sources, directly into their browser - and have it merged into their #SAS reporting database (after 4-eyes approval) as part of an automatic and fully auditable business process.

#viya #datagovernance #sassoftware

https://datacontroller.io/allianz-insurance-data-controller-sas/

#Datascientists: Check out this new IoT analytics blog to learn about an efficient & innovative nonlinear principal components method, SAS Fast-KPCA. #datascience #iotanalytics #innovation #viya #IoT #wearesas

http://2.sas.com/6018MLfVm

Your data is in #Excel, and you need it in #SAS 🚀

You google 🔎 and discover 5000 different upload mechanisms.

Which to choose? 🤷🏼

We compare and contrast 5 zero-code approaches to this perennial problem!

#viya #datacontroller #endusercomputing

https://datacontroller.io/5-zero-code-ways-to-import-excel-into-sas/

Have you ever wondered if a file has been modified in a directory?

One approach for change detection is to implement a git repo, but this requires the git tool, and the creation of a .git folder.

A more fundamental approach would be to hash every file and store the results.

The latest macro to hit the core library (mp_hashdirectory) does exactly that - recursively hashing every file in a directory and producing an output table with the results.

#sas #viya #sasjs

https://core.sasjs.io/mp__hashdirectory_8sas.html

If you're a power user of the SASjs Command Line Interface, you'll be pleased to know we've added two new options to the `sasjs run` command (which lets you run an arbitrary local .sas program on a remote SAS server)

* --log: Specify a specific output location for the log
* --source: Specify a series of macro variables in a JSON file. Helpful for running the same SAS program with different settings.

Docs: https://cli.sasjs.io/run

To upgrade, run `npm i -g @sasjs/cli@latest`

#sas #devops #viya

Features and Capabilities of SASjs:

💪 Structured Projects (maintain velocity as codebase grows)
💪 Self Documenting Jobs & Services (easier maintenance)
💪 Opinionated development approach (faster on-boarding)
💪 GIT-Native DevOps (parallel feature development)
💪 Self-contained apps (easy to deploy & migrate)
💪 '00s of SAS AppDev Macros (faster delivery)
💪 Automated Deployments (faster iterations)
💪 Quick-Start templates (faster sprint 0)
💪 Built-in Testing (avoid regressions)

#sas #sasjs #viya

The next SASjs training event is on Tues 27th Sep with 10 places available

Learn how to use SASjs to Compile, Build, Deploy, Test, and Document your SAS projects.

After the previous session we are making the following improvements:

* Time increased to 1hr 45 mins
* Includes 15 minute Mibo social
* A co-presenter for assistance

Entry is FREE for open source SAS developers, or anyone who donates (any amount) to the SASjs project. PM for details

#sas #sasjs #viya

https://www.eventbrite.com/e/using-sasjs-to-compile-build-deploy-test-and-document-sas-macros-tickets-416392309607

In many (non-SAS) languages it is common to pre-compile a "build" for deployment to a server.

The build has all dependencies such that it is fully self-contained and easy to deploy.

Subsequent changes are never made in the deployed code - rather they are applied in source (pull request), re-compiled, pushed for testing, then committed, merged, and re-packaged for deployment.

As a #SAS developer, if the above sounds familiar, you will ❤️ #SASjs.

https://cli.sasjs.io/cbd

#devops #viya #dataops