Hi   I am trying to find all instances when two words are present in a text field. In MS SQL  I can use CONTAINS(t1.NOTES, 'NEAR((Apples, Red),3)'), meaning the words Apples and Red are located near each other. When I try this in SAS EG 71. I get ERROR: Function CONTAINS could not be located. I also tried prxmatch("!(Apples|Red)!i", t1.NOTES)> 0, however either word shows up in the results. So if we have  1 - Apple Granny Green 2 - Apple Spartan Red 3 - Apple Jazz Red 4 - Apple Yellow Delicious #2 and #3 are valid   I am doing this in Proc SQL.   Thanks    ... View more

I am trying to convert decimal (seconds) to minutes seconds, so 123 decimal (seconds) would be 2:03 (2 minutes 3 seconds) or 0 hours 2 minutes 3 seconds) I am using SAS EG 7.12 and need to do this in PROC SQL not a data step. I have this working in MS SQL using convert and DATEADD, somehow everything I try in SAS fails,  The duration is field is numeric.   Thank you ... View more