Create a Web Ready Stored Process. More...
Go to the source code of this file.
This macro creates a Type 2 Stored Process with the Boemska h54s adapter (development / file upload version) included as pre-code.
The adapter code is loaded direct from github, so internet access is a currently a dependency (feel free to submit a PR to provide a fileref based approach).
Usage:
compile macros ;
filename mc url "https://raw.githubusercontent.com/Boemska/macrocore/master/macrocore.sas"; inc mc;
parmcards lets us write to a text file from open code ; filename ft15f001 "%sysfunc(pathname(work))/somefile.sas"; parmcards4; enter stored process code below ; proc sql; create table outdataset as select * from sashelp.class;
output macros for every dataset to send back ; bafheader() bafoutdataset(forJS,work,outdataset) baffooter() ;;;;
create the stored process ; mm_createwebservice(service=MyNewSTP ,role=common ,project=/User Folders/sasdemo/myapp ,source=sysfunc(pathname(work))/somefile.sas )
project= | The metadata project directory root |
role= | The name of the role (subfolder) within the project |
service= | Stored Process name. Avoid spaces - testing has shown that the check to avoid creating multiple STPs in the same folder with the same name does not work when the name contains spaces. |
desc= | Service description (optional) |
source= | /the/full/path/name.ext of the sas program to load |
precode= | /the/full/path/name.ext of any precode to insert. |
adapter= | omit this parameter to use the Boemska h54s adapter macros (assumes internet access) else provide the path to a local copy |
server= | The server which will run the STP. Server name or uri is fine. |
mDebug= | set to 1 to show debug messages in the log |
Definition in file mm_createwebservice.sas.