Writing a Stored Process |
Category: | Character |
Syntax | |
Arguments | |
Details | |
Example |
Syntax |
STPSRV_UNQUOTE2(paramname) |
is the character string name of the parameter.
Details |
The STPSRV_UNQUOTE2 CALL routine takes the name of an input parameter (or any global macro variable) and unmasks matched pairs of single or double quotation marks. The CALL routine does not return a value; instead it modifies the specified macro variable. This CALL routine can be used to selectively remove quotation marks from stored process input parameters so that they can be used in statements that require quotation marks.
Example |
This CALL routine is typically called with %SYSCALL in open macro code, as follows:
/* MYGOPTIONS is an input parameter and might contain quotation marks, for example: dashline='c000000000000000'x */ %SYSCALL STPSRV_UNQUOTE2(MYGOPTIONS); /* Quote characters are now interpreted as expected */ goptions &MYGOPTIONS; ...
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.