Production Ready Macros for SAS Application Developers File Reference

Creates a JobExecution web service if it doesn't already exist. More...

Go to the source code of this file.

Detailed Description

Code is passed in as one or more filerefs.

%* Step 1 - compile macros ;
filename mc url "";
%inc mc;

%* Step 2 - Create some code and add it to a web service;
filename ft15f001 temp;
    %webout(FETCH) %* fetch any tables sent from frontend;
    %* do some sas, any inputs are now already WORK tables;
    data example1 example2;
      set sashelp.class;
    %* send data back;
    %webout(ARR,example1) * Array format, fast, suitable for large tables ;
    %webout(OBJ,example2) * Object format, easier to work with ;

Notes: To minimise postgres requests, output json is stored in a temporary file and then sent to _webout in one go at the end.

SAS Macros

path=The full path (on SAS Drive) where the service will be created
name=The name of the service
desc=The description of the service
precode=Space separated list of filerefs, pointing to the code that needs to be attached to the beginning of the service
code=Fileref(s) of the actual code to be added
access_token_var=The global macro variable to contain the access token
grant_type=valid values are "password" or "authorization_code" (unquoted). The default is authorization_code.
replace=select NO to avoid replacing any existing service in that location
adapter=the macro uses the sasjs adapter by default. To use another adapter, add a (different) fileref here.
contextname=Choose a specific context on which to run the Job. Leave blank to use the default context. From Viya 3.5 it is possible to configure a shared context - see
VIYA V.03.04
Allan Bowe, source:

Definition in file