Next up on the reading list #CurrentlyReading #Bookworm #Bibliophile #SAS #WhoDaresWins

⚡️At the request of the #EU and #Ukraine, the Government of Norway extended the agreement with the #SAS airline company on the medical evacuation of Ukrainian patients to hospitals in Europe from May 1 to August 31.

Since the start of the medical evacuation, #Norway has provided… https://nitter.lacontrevoie.fr/i/web/status/1637896027037376513

Original tweet : https://twitter.com/RubrykaEng/status/1637896027037376513

5/x Inhaltswarnung: Das Video zeigt die Ermordung eines unbewaffneten Zivilisten in #Afghanistan. Der Ex-#SAS Veteran wurde nun von der australischen Bundespolizei festgenommen und steht heute zur Anklageerhebung vor Gericht.

#Queanbeyan #Australien: Anklage gegen Ex #SAS Veteran wegen #Kriegsverbrechen. Dem Veteran (Australian Defence Force #ADF) wird die Ermordung einer Person in #Afghanistan vorgeworfen. Der Fall könnte einen internationalen Präzedenzfall schaffen. https://www.abc.net.au/news/2023-03-20/former-sas-soldier-arrested-over-afghanistan-killing/102119554

Six #postcards from Scandinavian Airlines System showing interior of a SAS DC6 "Cloudmaster" that I sold on ebay a while ago.
2 of 2

#aviation #DC6 #SAS #Cloudmaster #postcard

Six #postcards from Scandinavian Airlines System showing interior of a SAS DC6 "Cloudmaster" that I sold on ebay a while ago. When pipe smoking on board was a thing!
1 of 2

#aviation #DC6 #SAS #Cloudmaster #postcard

Develop on one #SAS flavour - deploy to three!

1. #SASViya
2. SAS 9 EBI
3. SASjs Server

#SASjs is mostly TypeScript but there is one SAS Language library - @sasjs/core.

Each macro has a prefix - eg:

- Viya: `mv_*`
- SAS 9: `mm_*`
- Base: `mf_*` & `mp_*`

Cross Platform macros are prefixed `mx_*`:

* mx_createwebservice -> create web ready Job / STP
* mx_getcode -> fetch source code from Job / STP
* mx_testservice -> test a web service from a SAS session

Docs below.

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

As a #SASViya developer, how do you get your local files onto a remote SAS server?

🗄️ - Right click / upload to Studio is a manual approach
🗄️ - SSH is ideal if your admin / firewall allow it
🗄️ - Bouncing files via GIT is a gross misuse, but it works

For everyone else - there's #SASjs

Using EITHER the CLI or VS Code Extension you can synchronise one or more local directories with a remote #SAS filesystem

Works on all flavours of SAS, and 100% MIT open source

https://www.youtube.com/watch?v=bEX7QjHeON0

This past spring, I booked from the US to Italy on #SAS. The flight was rescheduled over and over again and then just cancelled. The only afordable option left was #TurkishAirlines. I'm not doing that a second time.

I don't trust #SAS.

4 ways to generate #datalineage in #SAS

1. DI Studio in SAS 9 EBI
2. Data Studio in Viya
3. Log Scanners
4. #SASjs Doc

There are many firms working on option 3 (ourselves included) however option 4 is a great solution if you'd like quick and TIDY results!

To implement - just set the relevant program headers and run `sasjs doc` or click the "docs" button in the SASjs VS Code Extension.

No SAS required - it works purely on SAS program logic!

https://www.youtube.com/watch?v=Sb1DqTLgVyQ

The #SAS Information Delivery Portal has been a mainstay of BI reporting for well over a decade

The interface is based on "portlets", containing dashboards, reports, static HTML, Stored Process output etc

Being heavily integrated with metadata it's now going the way of AF/SCL and SAS/Intrnet - ie, no longer supported

We can help you migrate to a new portal on your EXISTING platform that can be migrated to #SASViya at a later date - ie, to fit with YOUR timelines

https://4gl.io/about

In Data Controller for SAS® all changes to target tables are tracked in an audit table.

This makes it easy to see what changes happened where, by whom, and when.

Are you a #sasprogrammer making manual changes to data in #SAS? Loading Excel into #SASViya?

You NEED this tool.

Free for 5 users!

#datacapture #datagovernance

https://youtu.be/EUeIlr6KJK8

With #SASjs your client terminal can execute #SAS code:

-> On Viya, EBI, or Foundation Server
-> Without local SAS
-> Without SSH

The command is `sasjs run` and the article below shows how you can use it on a Viya 4 instance!

#sasviya #sashackathon #sasadmin

https://communities.sas.com/t5/SAS-Hacker-s-Hub/Hacker-tip-2-running-SAS-code-from-terminal/m-p/800130

Do you receive password-protected Excel?

How do you load them in #SAS?

With Data Controller for SAS®, you upload directly!

Just drag it in, enter the password, and submit.

Zero code, zero ETL, full governance & quality control.

Data Controller works on ALL flavours of SAS (Viya, EBI, Base) and is free for up to 5 users

https://4gl.io/dcb

#sasapps #sasviya #datagovernance

https://www.youtube.com/watch?v=b2lfBCkdvBI

BREAKING CHANGE!

`noTabIndentation` would previously flag a WARNING when a #SAS program contained indentation using the TAB character ('09'x).

We now check for the existence of ANY tab characters in a SAS program, and changed the setting to `noTabs`.

If your SAS logic requires the use of a tab character, you are strongly encouraged to use the hex literal '09'x instead - which is far more explicit and less likely to be caught by 'tab-to-space' settings in various IDEs.

https://github.com/sasjs/lint

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

Our main product helps #SAS customers onboard ad-hoc data 99% faster, whilst significantly improving data security and governance. We do this by simply eliminating the need to build/deploy jobs, using "schema on write", with a browser based workflow. It works completely within SAS, and is free for up to 5 users.

https://datacontroller.io

We also open-sourced the underlying devOps framework to help SAS programmers work natively with GIT.

https://github.com/sasjs

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/

Not going to do this very often, but this by the author of The Phoney Major is an astonishingly good thread. @worldwarshistory #sas @militaryhistory https://twitter.com/PhoneyMajor/status/1599656127993901057