https://communities.sas.com/t5/SAS-Data-Management/PostgreSQL-code-translate-into-FEDSQL-or-SAS/m-p/405945#M12386 <P>Hi. Can anyone help me with this below postgreSQL code?</P><P>&nbsp;...similar to '%(cpap mask|bipap mask)%'...</P><DIV><DIV><DIV><DIV class="container new-discussion-timeline experiment-repo-nav"><DIV class="repository-content"><DIV class="file"><DIV class="blob-wrapper data type-sql">I would like to change it to FEDSQL---I am not sure about mask function here. Thank you.</DIV></DIV></DIV></DIV></DIV></DIV></DIV><P>&nbsp;</P> Fri, 20 Oct 2017 13:34:00 GMT Zula 2017-10-20T13:34:00Z https://communities.sas.com/t5/SAS-Data-Management/PostgreSQL-code-translate-into-FEDSQL-or-SAS/m-p/405945#M12386 <P>Hi. Can anyone help me with this below postgreSQL code?</P><P>&nbsp;...similar to '%(cpap mask|bipap mask)%'...</P><DIV><DIV><DIV><DIV class="container new-discussion-timeline experiment-repo-nav"><DIV class="repository-content"><DIV class="file"><DIV class="blob-wrapper data type-sql">I would like to change it to FEDSQL---I am not sure about mask function here. Thank you.</DIV></DIV></DIV></DIV></DIV></DIV></DIV><P>&nbsp;</P> Fri, 20 Oct 2017 13:34:00 GMT https://communities.sas.com/t5/SAS-Data-Management/PostgreSQL-code-translate-into-FEDSQL-or-SAS/m-p/405945#M12386 Zula 2017-10-20T13:34:00Z https://communities.sas.com/t5/SAS-Data-Management/PostgreSQL-code-translate-into-FEDSQL-or-SAS/m-p/405951#M12387 <P>| here means or and % is&nbsp; for like statement . it can be&nbsp; translated to</P> <P>column like '%cpap mask%' or&nbsp; column like&nbsp; '%bipap mask% should work in fedsql</P> Fri, 20 Oct 2017 13:53:35 GMT https://communities.sas.com/t5/SAS-Data-Management/PostgreSQL-code-translate-into-FEDSQL-or-SAS/m-p/405951#M12387 kiranv_ 2017-10-20T13:53:35Z