topic Re: Translating Oracle SQL code into SAS Proc SQL in SAS Programming

Translating Oracle SQL code into SAS Proc SQL

Solly7 — Wed, 19 May 2021 06:15:18 GMT

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

nvl(a.gl_batch_no,0) <> 0

Re: Translating Oracle SQL code into SAS Proc SQL

Kurt_Bremser — Wed, 19 May 2021 06:17:34 GMT

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

Re: Translating Oracle SQL code into SAS Proc SQL

Solly7 — Wed, 19 May 2021 06:20:32 GMT

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?

Re: Translating Oracle SQL code into SAS Proc SQL

Kurt_Bremser — Wed, 19 May 2021 06:21:27 GMT

And replace the Oracle NVL function with COALESCE in SAS.

Re: Translating Oracle SQL code into SAS Proc SQL

Solly7 — Wed, 19 May 2021 06:24:46 GMT

Thank you