The splitter transformation is using a data step, and IF statements, hence WHERE specific syntax is not available.
See this link on how to mimic LIKE and CONTAINS in an IF statement.
Please provide an example, or clear text on what your issue is. Are you saying that you are used to the SQL syntax like? If so this post might help.
http://support.sas.com/kb/43/303.html
If not, please clarify.
The splitter transformation is using a data step, and IF statements, hence WHERE specific syntax is not available.
See this link on how to mimic LIKE and CONTAINS in an IF statement.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.