topic To decide if a prompt has been selected or not in Developers

To decide if a prompt has been selected or not

VD — Tue, 19 May 2015 10:50:20 GMT

I have a prompt in a stored process which returns an integer value. The prompt allows users to select from a dynamic list. Selecting the prompt is optional. I want to check whether the prompt was selected or not. The selected value doesn't matter - I only want to check if the prompt was selected or not. Is there a way of doing it programatically?

I tried in these two ways by check if the prompt returned a missing value but that didn't work:

/*First*/

%if %eval(&Prompt1 ne .) %then %let Var1=1;

%else %let Var1=0;

/*Second*/

%if %sysfunc(missing(&Prompt1))=0 %then %let Var1=1;

%else %let Var1=0;

Any suggestions?

Thanks.

Re: To decide if a prompt has been selected or not

LinusH — Tue, 19 May 2015 11:35:51 GMT

The obvious (?) way to go: %put your prompt value when it's not selected.

%eval is not needed when doing comparisons, use it with calculations.

Re: To decide if a prompt has been selected or not

VD — Tue, 19 May 2015 16:38:53 GMT

Thank you, Linus.

I ended up using %length to check if the parameter returned any value or not. It worked.

Re: To decide if a prompt has been selected or not

BrunoSilva — Wed, 20 May 2015 20:47:22 GMT

There's many ways to do it.

Here is a good paper that cover that subject:

IS THIS MACRO PARAMETER BLANK?

http://support.sas.com/resources/papers/proceedings09/022-2009.pdf

Best regards

Re: To decide if a prompt has been selected or not

VD — Thu, 21 May 2015 07:09:03 GMT

Thanks.