sasjs test

https://slides.sasjs.io/test

Why use SASjs?

• Open Source (MIT) & Actively Developed
• Work locally with your preferred tools
• Faster iterations / time to value

Why Write Tests?

• Reduce Manual Testing
• Avoid Regression
• Documentation

Why use SASjs for Tests?

• Run each test in isolated session
• Easily rerun tests in debug mode
• Test Setup / Teardown routines
• Integration with sasjs doc
• Test Coverage reports

What is SASjs?

1. An Opinionated Approach for SAS Solution Delivery
2. A Collection of Tools
   • @sasjs/cli - CI/CD and Automated Deployment
   • @sasjs/core - Macro library
   • @sasjs/vscode-extension - Battery Pack for VS Code
   • @sasjs/server - Build Apps on Base SAS

What is a SASjs Test?

A SAS program that performs one or more assertions

Filename pattern: [filename].test<.integer>.sas

some_service.test.sas
some_job.test.0.sas
some_job.test.1.sas

The test integer is optional. If provided, tests execute accordingly - eg some_job.test.0.sas before some_job.test.1.sas.

Creating Tests

Test Body

An example of a test that provides a result:

data work.test_results;
  test_description="some description";
  test_result="PASS";
  test_comments="We did this & that happened";
  output;
run;
%webout(OPEN)
%webout(OBJ, test_results)
%webout(CLOSE)

Assertion Macros

A number of ready made assertion macros are available in the SASjs Core library:

• mp_assert - generic assertion
• mp_assertcols - Asserts the existence (or not) of certain columns
• mp_assertcolvals - Asserts the existence (or not) of particular column values
• mp_assertdsobs - Asserts the existence (or not) of dataset observations
• mp_assertscope - Compares before/after to detect scope leakage in a SAS Macro

Examples of SASjs Tests

• https://core.sasjs.io/dir_59425e443f801f1f2fd8bbe4959a3ccf.html
• https://code.datacontroller.io/dir_14faff0c6f3b22df226aa27946e1ad45.html

Test Coverage

A SAS Service, Job or Macro is covered if there is a test with the same filename, eg:

├── some_service.sas
├── some_service.test.sas
├── some_job.sas
└── some_macro.test.0.sas

In this example, some_service.sas is covered, some_job.sas is not covered, and some_macro.test.0.sas is a standalone test.

Coverage is file level. We have plans for line level - just need a sponsor!

Deploying Tests

SASjs Developer Workflow

CLI Pre-Requisites

Required	Recommended	Recommended

To install the CLI: npm i -g @sasjs/cli

SASjs Primary Artefacts

Services & Tests are compiled with %webout() macros, for generating JSON in SASjs format. See also: https://cli.sasjs.io/artefacts/

SASjs Secondary Artefacts

These items are bundled into each Primary Artefact when listed in the program header

• SAS Macros
• SAS Includes
• Binary Files
• initProgram
• termProgram

SASjs Config File

Every SASjs Project has a sasjs/sasjsconfig.json file, for configuration of:

• Location of Artefacts (+ Dependencies & Init/Term programs)
• Macro Variables
• Target attributes / connection settings

SASjs Target

A location on a SAS server

Core attributes:

• name > Alias for SASjs commands, eg: sasjs deploy -t dev3
• serverUrl > Protocol + Host + Port
• serverType > either SASVIYA, SAS9 or SASJS
• appLoc > Root deployment folder in SAS Drive or Metadata

sasjs cbd Syntax

• sasjs compile: Self-contained Jobs, Services, Tests
• sasjs build: Deployment pack (JSON / SAS Program)
• sasjs deploy: Send to target

Compile/Build/Deploy project to myTarget: sasjs cbd -t mytarget

Running Tests

sasjs test Syntax

Execute all tests (default target): sasjs test

Execute tests in "macros" folder: sasjs test /macros/

Prevent pipeline fail: sasjs test --ignoreFail

Execute all tests starting with "mv_" and save the output in 'myresults' folder

sasjs test mv_ --outDirectory /somedir/myresults

Resources

• https://sasjs.io/resources
• https://datacontroller.io
• https://github.com/sasjs
• https://cli.sasjs.io
• https://sasapps.io