Why? ... View more

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; ... View more

I only do when it's for free, if I'm being paid then it's fine Hire a SAS/SQL consultant to do the work. But I'm pretty sure someone else will answer the question as well. ... View more

It's sounds like you need help to get a job to done. I suggest you take the necessary training and/or get in contact with a SAS professional agency, or SAS Professional Services. ... View more