topic Proc sql in function in SAS Programming

Proc sql in function

shawn123 — Wed, 01 Jul 2020 01:22:31 GMT

Hi guys, I find a question online, the question is shown below

So the answer is not based on SAS SQL, and the answer cannot work in proc SQL, is there any way to write in proc SQL?

shawn123 — Wed, 01 Jul 2020 01:24:11 GMT

SASKiwi — Wed, 01 Jul 2020 01:31:50 GMT

Here is one way that will work in SAS SQL:

where cats(C1, C2, C3) contains 'Yellow'

PGStats — Wed, 01 Jul 2020 03:37:01 GMT

Another SAS/SQL way:

where whichc("Yellow", c1, c2, c3);

Ksharp — Thu, 02 Jul 2020 12:17:08 GMT

Another SQL way:

where sum(c1='Yellow',c2='Yellow',c3='Yellow') ;