Will execute a SASjs web service on SAS 9, Viya or SASjs Server. More...

Detailed Description

Prepares the input files and retrieves the resulting datasets from the response JSON.

Note - the _webout fileref should NOT be assigned prior to running this macro.

Parameters

[in] program The _PROGRAM endpoint to test

[in] inputfiles=(0) A list of space seperated fileref:filename pairs as follows: inputfiles=inref:filename inref2:filename2

[in] inputdatasets= (0) All datasets in this space seperated list are converted into SASJS-formatted CSVs (see mp_ds2csv.sas) files and added to the list of inputfiles for ingestion. The dataset will be sent with the same name (no need for a colon modifier).

[in]

inputparams=(0)

A dataset containing name/value pairs in the following format:

name:$32	value:$1000
stpmacname	some value
mustbevalidname	can be anything, oops, abort!!

[in] debug= (131) Provide the _debug value.

[in] mdebug= (0) Set to 1 to provide macro debugging

[in] viyaresult= (WEBOUT_JSON) The Viya result type to return. For more info, see mv_getjobresult.sas

[in] viyacontext= (SAS Job Execution compute context) The Viya compute context on which to run the service

[out] outlib= (0) Output libref to contain the final tables. Set to 0 if the service output is not in JSON format.

[out] outref= (0) Output fileref to create, to contain the full _webout response.

[out] outlogds= (null) Name of a dataset to receive the child's log (one column, line). Populated on Viya, from the job log mv_jobflow collects, and on SASjs Server, from the log the server appends to the response - ms_testservice discards that log unless this is set. Not populated on SAS 9, where proc stp returns no child log. On SASjs Server it is only populated when debug is 131 or above: the server appends the log to the response in debug mode, so a lower value returns an empty dataset.

[out] outstatus= (0) Name of a dataset to receive the outcome of each child run - one row per program, with columns STATE, URI, ERRMSG and PLATFORM. ERRMSG is only populated on SASjs Server, from the abort block; the Viya job flow carries a state but no message, and SAS 9 gives neither.

SAS Macros

Related Programs

mx_execute.test.sas

Version: 9.4

Author: Allan Bowe

@sasjslint {"maxLineLength": 95}

Definition in file mx_execute.sas.