topic Re: Merging data with full outer join in SAS Enterprise Guide

Merging data with full outer join

boey — Wed, 18 Mar 2015 04:06:52 GMT

I have two set of data which are policy (table 1) and claim (table 2) data. Multiple claims have been subtotal by policy no. I have merged these data by policy no. level yet there are blank cell in between when I pull only policy no. from table 1 and vice versa. How do I merge policy no. from table 1 and table 2 into one column other than doing formulae by adding new column?

Re: Merging data with full outer join

Jaheuk — Wed, 18 Mar 2015 10:01:51 GMT

see SAS HELP

Retrieving Data from Multiple Tables : Combining Queries with Set Operators

Re: Merging data with full outer join

Kurt_Bremser — Wed, 18 Mar 2015 10:15:08 GMT

Use

select coalesce(a.policy_no,b.policy_no) as policy_no

from policy a full join claim b on a.policy_no = b.policy_no;

Re: Merging data with full outer join

boey — Thu, 19 Mar 2015 02:30:37 GMT

It works. thanks Kurt!