Merging data with full outer join

[boey]

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?

[Jaheuk]

see SAS HELP

Retrieving Data from Multiple Tables : Combining Queries with Set Operators

H.

[Kurt_Bremser]

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;

[boey]

It works. thanks Kurt!