Sql conditions to merge datasets

[JPARK]

Hi,

I want to have two different conditions to merge two datasets.

one with the same ticker and particular period.

or second one with the same id and particular period.

Would below codes work?

sql;
create table abc as

select I.*,N.MEDEST, N.FPEDATS

from rs_gvkey_1 as I left join CFF_1 as N

on I.ticker=N.OFTIC and I.disdate <= N.FPEDATS < intnx('month',I.disdate,+3,'same')

or I.cusip=N.cusip and I.disdate <= N.FPEDATS < intnx('month',I.disdate,+3,'same');

run;

[PGStats]

It should work. I would prefer to write it as:

proc sql;
create table abc as

select I.*, N.MEDEST, N.FPEDATS

from rs_gvkey_1 as I left join CFF_1 as N

on (I.disdate <= N.FPEDATS < intnx('month', I.disdate, +3, 'same')) and

   (I.ticker=N.OFTIC or I.cusip=N.cusip);

quit;

(untested)

PG