topic Re: change default ods style for stored processes called through stored process web application in Developers

change default ods style for stored processes called through stored process web application

bheinsius — Tue, 18 Dec 2012 16:37:12 GMT

hi,

is it possible to set a default ods style for all stored processes that i execute through the SAS Stored Process Web Application?

currently, if I don't specify one I get the gray default style and have to specify a hidden prompt for _odsstyle on every stored process to change it.

thanks Bart

Re: change default ods style for stored processes called through stored process web application

bheinsius — Mon, 15 Apr 2013 20:00:38 GMT

bump

Re: change default ods style for stored processes called through stored process web application

DonH — Wed, 17 Apr 2013 13:56:29 GMT

You could use the request init facility that runs the code in the specified file before every stored process and just add something like this to the program:

%global _odsStyle;

%let _odsStyle = %sysfunc(&_odsStyle,sasweb);

which will leave any provided value alone, but if none is provided it will set it to (in this case) sasweb. Just change sasweb to whatever your desired style is.

Re: change default ods style for stored processes called through stored process web application

bheinsius — Wed, 17 Apr 2013 14:08:31 GMT

i was hoping there would be a general option, looks like there is not.

your work-around may be the best option, thanks Don.

Re: change default ods style for stored processes called through stored process web application

bheinsius — Wed, 17 Apr 2013 14:16:32 GMT

btw your code is syntactically incorrect:

15 %global _odsstyle;

16 %let _odsStyle = %sysfunc(&_odsStyle,sasweb);

ERROR: Function name missing in %SYSFUNC or %QSYSFUNC macro function reference.

Re: change default ods style for stored processes called through stored process web application

DonH — Wed, 17 Apr 2013 14:51:04 GMT

Sorry, left out the coalescec function (which returns the first non-blank/non-missing argument):

%global _odsStyle;

%let _odsStyle = %sysfunc(coalescec(&_odsStyle,sasweb));

Re: change default ods style for stored processes called through stored process web application

Vince_SAS — Thu, 18 Apr 2013 17:21:33 GMT

Information on the request init/term program:

Usage Note 39250: SAS® 9.2 Stored Process Server enhancements: Request Init and Term programs, Session Init and Term programs

http://support.sas.com/kb/39/250.html

Vince DelGobbo

SAS R&D