Am I doing something wrong?
I have this code:
proc sql _method;
create table test as
from detail.t_account_2006_12 as a
detail.t_account_loan_details as b
on a.branch_no = b.branch_no
and a.account_no = b.account_no
and a.account_open_date = b.account_open_date
where (b.year_num = 2006 or b.year_num is null)
and (b.month_num = 12 or b.year_num is null)
My aim of course is to generate a table that has every record from the
T_ACCOUNT_2006_12 table and match it to any record from the
T_ACCOUNT_LOAN_DETAILS table where the loan year is 2006 and loan
month is 12.
When I run this I get the wrong number of records: it's running as if
it's an equi-join and the record count is too low.
Am I missing something?
Using SAS 9.1.3 SP4 on Sun Solaris 10. All tables are SPDS tables.
Thanks in advance.
15. I am going nuts!