SASjs Server

About 4GL Apps

Delivery, Enablement, & Support

Stop me if I go too fast!

Company Overview

• UK Ltd, 9 years
• SAS UK Subcontractor
• 7 developers - 5 JavaScript, 2 SAS

Focus: SAS Solutions

Products

• Data Controller for SAS® - for regulated industries
• Sasensei - quiz game with 5000 SAS geeks
• SASjs - DevOps Framework

Why Build an Open Source SAS server?

• Deliver apps to traditional Base SAS Users
• Significantly lower running costs
• Build & test SAS apps locally (deploy globally)

SASjs Server Features

• App Stream
• Full REST API
• Stored Programs
• Multiple runtimes (SAS, JS)
• Users & Groups (server mode)

SASjs Server Capabilities

• Integrate Base SAS with third party systems using REST API
• Build & Distribute SAS Apps to ANY and ALL SAS customers
• Execute Test Suites with sasjs test

Integrations

• sasjs/cli - run CLI commands including sasjs deploy and sasjs test
• sasjs/vscode-extension - execute Base SAS from VS Code
• sasjs/adapter - connect to Base SAS using JavaScript
• sasjs/core - macro library preconfigured

Demo - Basic Deploy on http

SASjs server can be manually downloaded from github releases page.

Or, programmatically:

curl -L https://github.com/sasjs/server/releases/latest/download/linux.zip > linux.zip
unzip linux.zip
./api-linux

Demo - SASjs Studio, SASjs API & SAS Drive

• Studio returns LOG and WEBOUT (no output)
• Every session is a new session
• Use APIs (and Studio) to load Drive

Demo - https deploy (with certificates)

To avoid prompts, provide variables in a .env file as follows:

SAS_PATH=/opt/sas
PROTOCOL=https
CERT_CHAIN=fullchain.pem
PRIVATE_KEY=privkey.pem
PORT=443

Demo - Server Mode

SASjs uses Mongo DB. Can be set up locally, but we'll use a connection string for a cloud instance. Required configs:

MODE=server
DB_CONNECT=mongodb+srv://user:pass@cluster0.gblpw.mongodb.net/?retryWrites=true&w=majority

Demo - APIs

Server mode brings additional capabilities:

• Authentication
• User Management
• Group Management

Demo - create user / group, add a user to group

Demo - App Stream

• Sonic
• Minimal Seed App
• Data Controller

Running tests

SASjs Server can also be used as a test runner. To illustrate, using SASjs Core:

1. Open https://gitpod.io/github.com/sasjs/core
2. Authenticate: sasjs auth -t server
3. Deploy: sasjs cbd -t server
4. Run test: sasjs test ms -t server

Mocking Services

By default, SASjs Server runs only SAS. A (node) JS runtime can also be selected as a primary or secondary runtime. Config:

NODE_PATH=/usr/bin/node
RUN_TIMES=js,sas

Demo - running JS in Studio, running minimal seed app with JS services

Roadmap

• Permissions
• Okta / LDAP integration
• Python & R runtimes

or, whatever our projects or sponsors request..

Resources

• https://github.com/sasjs/server
• https://datacontroller.io
• https://server.sasjs.io
• https://sasapps.io