Proc sql in function

[shawn123]

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]

This is the link
https://www.toptal.com/sql/interview-questions

[SASKiwi]

Here is one way that will work in SAS SQL:

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

[PGStats]

Another SAS/SQL way:

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

[Ksharp]

Another SQL way:

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