topic Re: Merging Compustat and CRSP( my CRSP date changed..) in SAS Programming

Merging Compustat and CRSP( my CRSP date changed..)

JKCho — Tue, 09 Jul 2019 23:12:26 GMT

data CRSP_new;
set CRSP1;
year = YEAR(date);
run;

proc sql;
create table crspcomp as
select a.* , b.*
from cstatcusip1 a
inner join CRSP_new b
on a.cusip8 = b.cusip and a.fyear= b.year;
quit;

I used this code. It worked well! awesome!

Well... now I noticed that the Date on original CRSP file changed to the same dates of Compustat file(To be more specific, they become like certain-patterned numbers. and I changed these by resetting formats to YYMMDDN8.) Since Compustat dates are mostly year-end, I have many duplicated 12/31 days. For example 2011/10/13 -> 2011/12/31.

It looks that because of this code; year = YEAR(date);

I thought the year converted only used for matching and original CRSP dates should remain.

Also, I saw a warning sign when clicking 'submit' that there is already 'date' variables in crspcomp(newly created one by merge).

I thought that is as there is only one 'date' variable in two sets so there will be only one 'date' variable after merge too. I already check my Compustat file where the name of the date variable is 'datadate' so no two 'date' variables.

Please share your ideas and wisdom how I keep CRSP date after merging.

I truly sincerely appreciate all help from all of you!!!

Jerry

Re: Merging Compustat and CRSP( my CRSP date changed..)

JKCho — Tue, 09 Jul 2019 23:18:39 GMT

Oh... I cannot remove this post. NEVER MIND. I found what was an issue. Sorry all of you

Re: Merging Compustat and CRSP( my CRSP date changed..)

Reeza — Wed, 10 Jul 2019 01:28:24 GMT

I would recommend posting the solution and then marking it as the answer?

Re: Merging Compustat and CRSP( my CRSP date changed..)

JKCho — Wed, 10 Jul 2019 17:36:43 GMT

Agree and I did!

Re: Merging Compustat and CRSP( my CRSP date changed..)

JKCho — Wed, 10 Jul 2019 17:37:40 GMT

Hello,

the code itself is fine!!!

BUT REMEMBER there is no same variable NAME in your files. That was my silly mistakes!