SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

PostgreSQL code translate into FEDSQL or SAS

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

PostgreSQL code translate into FEDSQL or SAS

Hi. Can anyone help me with this below postgreSQL code?

 ...similar to '%(cpap mask|bipap mask)%'...

I would like to change it to FEDSQL---I am not sure about mask function here. Thank you.

 


Accepted Solutions
Solution
‎10-20-2017 10:36 AM
PROC Star
Posts: 503

Re: PostgreSQL code translate into FEDSQL or SAS

[ Edited ]

| here means or and % is  for like statement . it can be  translated to

column like '%cpap mask%' or  column like  '%bipap mask% should work in fedsql

View solution in original post


All Replies
Solution
‎10-20-2017 10:36 AM
PROC Star
Posts: 503

Re: PostgreSQL code translate into FEDSQL or SAS

[ Edited ]

| here means or and % is  for like statement . it can be  translated to

column like '%cpap mask%' or  column like  '%bipap mask% should work in fedsql

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 154 views
  • 0 likes
  • 2 in conversation