NEED to Change below code in to sql

[Raj_SasUser]

Could you please some one help me how to convert below SAS code in to SQL code

data crmsaimler_f;

  merge ipexcl_f(keep=claimno in=abc) crmsaimall_f(in=def);

  by claimno;

  if def and not abc;

run;

[PGStats]

Try this:

proc sql;

create table crmsaimler_f as

select *

from crmsaimall

where claimno not in (select claimno from ipexcl);

quit;

PG

[Fugue]

I assume by SQL code you mean PROC SQL code?

A couple of different ways you could accomplish this via PROC SQL:

Method 1:

PROC SQL;

     create table crmsaimler_f as

     select def.claimno

     from crmsaimall_f as def

     WHERE NOT EXISTS

          ( select 1

          from ipexcl_f as abc

          where abc.claimno = def.claimno)

     order by 1

;

quit;

Method 2:

PROC SQL;

     create table crmsaimler_f as

     select def.claimno

     from crmsaimall_f as def

     WHERE def.claimno NOT IN

          ( select distinct abc.claimno

          from ipexcl_f as abc )

     order by 1

;

quit;