mv_webout.sas File Reference

Send data to/from the SAS Viya Job Execution Service. More...

Go to the source code of this file.

Detailed Description

This macro should be added to the start of each Job Execution Service, immediately followed by a call to:

  %mv_webout(FETCH)

This will read all the input data and create same-named SAS datasets in the WORK library. You can then insert your code, and send data back using the following syntax:

data some datasets; * make some data ;
  retain some columns;
run;

%mv_webout(OPEN)
%mv_webout(ARR,some)  * Array format, fast, suitable for large tables ;
%mv_webout(OBJ,datasets) * Object format, easier to work with ;
%mv_webout(CLOSE)

Parameters

action	Either OPEN, ARR, OBJ or CLOSE
ds	The dataset to send back to the frontend
_webout=	fileref for returning the json
fref=(_mvwtemp)	Temp fileref to which to write the output
dslabel=	value to use instead of the real name for sending to JSON
fmt=(Y)	change to N to strip formats from output
stream=(Y)	Change to N if not streaming to _webout

SAS Macros

• mp_jsonout.sas
• mf_getuser.sas

Version

Viya 3.3

Author

Allan Bowe, source: https://github.com/sasjs/core

Definition in file mv_webout.sas.