Production Ready Macros for SAS Application Developers
mm_createwebservice.sas File Reference

Create a Web Ready Stored Process. More...

Go to the source code of this file.

Detailed Description

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 )

Dependencies

Parameters
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
Version
9.2
Author
Allan Bowe

Definition in file mm_createwebservice.sas.