Can I put an if/then statement in a -SET variable?

I want to do:

-SET &ABCD = IF &RUNTIMEPROMPT EQ 'MD' THEN 'MARYLAND' ELSE '';

The resulting value of &ABCD would then be used in the WHERE clause of my query.

Is something like this possible in the -SET statement? Do I have the syntax wrong? Should I gather the variable in the -SET variable, then do the if/then translation as part of a DEFINE later in the code?

Any help would be appreciated.

This message has been edited. Last edited by: <Kathryn Henning>,

Yes, You can put IF/THEN statement in -SET clause. and use that variable in where clause.

If your input is from variable it sounds good, if the INPUT value is from another field in the table then DEFINE will work.

With -SET shown when the value of &RUNTIMEPROMPT is not MD the where predicate would become

WHERE EQ

which will thrown an error. Better to code

-SET &ABCD = IF &RUNTIMEPROMPT EQ 'MD' THEN 'WHERE EQ ''MARYLAND''' ELSE '';

quote:

-SET &ABCD = IF &RUNTIMEPROMPT EQ 'MD' THEN 'WHERE EQ ''MARYLAND''' ELSE '';

Thank you Jim. This is awesome, and is working perfectly for what I am trying to do