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?
Here is one way that will work in SAS SQL:
where cats(C1, C2, C3) contains 'Yellow'
Another SAS/SQL way:
where whichc("Yellow", c1, c2, c3);
Another SQL way:
where sum(c1='Yellow',c2='Yellow',c3='Yellow') ;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.