Sql conditions to merge datasets

JPARK — Tue, 11 Nov 2014 00:12:57 GMT

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;

Re: Sql conditions to merge datasets

PGStats — Tue, 11 Nov 2014 03:25:44 GMT

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)