Filters on SELECT

[sarahzhou]

The line in the selection 

where MEMBER_ID = %str(&USER_NAME.) OR EMAIL_ID = %str(&USER_EMAIL.) OR (OTH_ID = %str(&OTHER_ID.) &USER_BIRTHDAY.

What is &USER_BIRTHDAY. doing? Because here I didn't see it comparing with anything.

Kindly help.

Thank you.

[SASKiwi]

Until we know what &USER_BIRTHDAY. resolves to we would have no idea.

Try this to find out:

%put USER_BIRTHDAY = &USER_BIRTHDAY.;