Translating Oracle SQL code into SAS Proc SQL

[Solly7]

Hi, I need help in translating the below code from Oracle SQL code into SAS Proc SQL

nvl(a.gl_batch_no,0) <> 0

[Kurt_Bremser]

Replace the "<>" with the SAS mnemonic "ne" (not equals).

[Solly7]

Hi, thanks for your prompt reply and assistance... I need to ask about the "nvl" function at the beginning of the code, which SAS function should I replace it with?

[Kurt_Bremser · Accepted solution]

And replace the Oracle NVL function with COALESCE in SAS.

[Solly7]

Thank you