In SAS PROC SQL (as opposed to perhaps other implementations of SQL), there is no such function. Please explain what you are trying to do so that we may advise further. Most likely a data step could get the job done.
i can see some example in google but when tried to apply same it resulted in syntax error????
We don't know what this means. You have to show us your code and the SASLOG.
--
Paige Miller