Resolution of Text Fields in Stored Processes

0

So you modified the SAS EG character formatted constraints to resolve automatically with surrounding single-quotes. (Seen below from Stored Process Wizard and Management Console screens.)

 

 

 

 

 

 

 

 

Of course, the pain now is trying to pass dynamic parameters through the %stpbegin & %stpend statements. To resolve the single-quotes, use the code: %SYSCALL STPSRV_UNQUOTE2(severity);

Of course, since this parameter is multiple choice, you need to run the %SYSCALL step on each instance:

         %if %SYMGLOBL(severity) > 0 %then %do;
         %if %SYMGLOBL(severity0) EQ 0 %then %do;
                %SYSCALL STPSRV_UNQUOTE2(severity);
         %end;
         %else %do i=1 %to &severity0;
                %SYSCALL STPSRV_UNQUOTE2(severity&i;);
         %end;
         %end;

Share

About Author

Angela Hall

Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

Comments are closed.

Back to Top