topic Re: Converting oracle sql to sas proc sql in SAS Programming

Converting oracle sql to sas proc sql

Solly7 — Mon, 10 May 2021 08:44:24 GMT

Hi,

I need help in converting the below line of oracle code into sas proc sql... your help will be highly appreciated..please note that n01 is column name

decode(nvl(n01,-99),-99,'V0','V01') as "tax code"

Re: Converting oracle sql to sas proc sql

Kurt_Bremser — Mon, 10 May 2021 10:38:02 GMT

This should do it:

case
  when coalesce(n01,-99) = -99
  then 'V0'
  else 'V01'
end as tax_code

Re: Converting oracle sql to sas proc sql

Solly7 — Mon, 10 May 2021 11:46:59 GMT

Thanks a lot Kurt..its working perfectly fine!