Hi @GuiVtzl, First I 'd like to congratulate your success of solving your own problem, while I can't repeat your luck using "_%" with "=" operator in STP (Stored Process). Are your sure you used "=" instead of 'LIKE" as suggested? One way going this around if your code is in the format of : WHERE PERFORMING_FLAG = "&PERFORMING_FLAG" is to use query builder and check "All possible values" selection. Unfortunately it does not work on STP out of box, you need to get it to work through query builder, then convert it to STP, so it may not as flexible as something working straightly on the SAS code in STP, although in your case, query builder seems to be adequate. OK, now is the fun part. If going back to your original code: FROM TRAVAIL.Q113_INPUTS_1 t1 &PERFORMING_FLAG; It came to me that STP has some 'hidden' rules in term of Macro quoting. Notice the code you have for Prompt: where PERFORMING_FLAG = "Yes" And the error message translated into English : (BTW, I didn't do the translation, rather, I tried to repeat your problem in a hypothetical setting) ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, (, *, +, -, ALL, ANY, BTRIM, CALCULATED, CASE, INPUT, PUT, SELECT, SOME, SUBSTRING, TRANSLATE, USER. ERROR 200-322: The symbol is not recognized and will be ignored. The SAS code is correct in plain SAS code or in the SAS code wrapped with Macro definition, however it does not work in STP, and the reason is hinted in the error message: expecting one of the following: a name, a quoted string. WTH? SAS is complaining the lack of a quoted string while We do have one "Yes"!!! So there is something fishy here, but we have to play along. SAS complaining lack of a quoted string doesn't there isn't one, it could mean it has been quoted out, so SAS doesn't see it. So I tried this: FROM TRAVAIL.Q113_INPUTS_1 t1 %unquote(&PERFORMING_FLAG); And guess what, It worked! Here is the definition of my prompt: Please notice that the third one: where 1, which means always true, but I have to put it out there as it does not take blanks. I am in the process of learning STP, so I am really glad you have raised this question, it helped me deepen my understanding how STP works. Haikuo
... View more