Sql conditions to merge datasets

Reply
Contributor
Posts: 23

Sql conditions to merge datasets

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;

Respected Advisor
Posts: 4,641

Re: Sql conditions to merge datasets

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

PG
Ask a Question
Discussion stats
  • 1 reply
  • 136 views
  • 4 likes
  • 2 in conversation