I get the reason, cusip are not the same. I should have substr  cusip in m_fegg to 6 digit. I had done it before, but after I revised my code, I forgot it.  It's not the matter of your codes. Thank you, thank you all. You make me learn a lot, I really appreciate. ... View more

HI, just like I posted above. data m_fegg; set ibes.m_fegg; yymm=input(put(yymm,6.),yymmn6.); format yymm yymmn6.; run; data sdc_final; set sdc.sdc_final; yymm_a=input(put(yymm_a,6.),yymmn6.); yymm_e=input(put(yymm_e,6.),yymmn6.); format yymm_a yymm_e yymmn6.; run; proc sql; create table m_i_s1 as select b.*,a.yymm_a from sdc_final as a, m_fegg as b where intnx('month',a.yymm_a, -36,'same')<=b.yymm<=a.yymm_a & a.acq_cusip=b.cusip; quit; ... View more

Maybe here is better. name has been changed but data unchanged. thks data WORK.SDC_FINAL1; infile datalines dsd truncover; input yymm_a:32. y_a:32. yymm_e:32. y_e:32. acq_cusip:$30. Acquiror_Name:$60. acq_sic:32. target_sic:32. cash_p:$18.; label Acquiror_Name="Acquiror Name"; datalines4; 200204,2002,200204,2002,00013L,APS Healthcare Bethsda,8099,8099,0 199312,1993,199401,1994,00026R,A-OK(GB-Inno-BM SA),5251,5251,0 200607,2006,200609,2006,00030F,AMI Semiconductor Inc,3674,3674,1 199106,1991,199106,1991,000352,AAI Corp,3812,3699,1 199201,1992,199201,1992,000352,AAI Corp,3812,3829,0 200611,2006,200611,2006,000352,AAI Corp,3812,3679,0 200802,2008,200803,2008,000361,AAR Corp,3724,4581,0 201003,2010,201004,2010,000361,AAR Corp,3724,4522,0 199710,1997,199711,1997,00074C,American Builders,5033,5033,0 199504,1995,199505,1995,000752,ABC Rail Products Corp,3469,4789,1 199704,1997,199707,1997,00075X,ABC Radio Networks,4832,4832,1 199805,1998,199805,1998,00077R,ABR Information Services Inc,7374,7389,0 199411,1994,199503,1995,000781,ABS Industries Inc,5085,3714,0 199401,1994,199403,1994,000872,ACS Enterprises Inc,4841,4841,1 199808,1998,199808,1998,00087X,ACSYS Inc,7363,7361,0 199603,1996,199603,1996,000886,ADC Telecommunications Inc,3669,1731,0 199801,1998,199801,1998,000886,ADC Telecommunications Inc,3669,5731,0 199905,1999,199906,1999,000886,ADC Telecommunications Inc,3669,3674,0 200403,2004,200405,2004,000886,ADC Telecommunications Inc,3669,3663,0 200710,2007,200712,2007,000886,ADC Telecommunications Inc,3669,4812,0 ;;;; data WORK.M_FEGG1; infile datalines dsd truncover; input OFTIC:$6. CUSIP:$8. CNAME:$16. MEANEST:32. yymm:32. g:32. g_indavg:32.; label OFTIC="Official Ticker Symbol" CUSIP="CUSIP/SEDOL" CNAME="Company Name" MEANEST="fe_t+1" g="g"; datalines4; SODA,00020910,A & W BRANDS,0.45,198803,20,20 AAON,00036020,AAON,0.05,199512,17,14.239545455 ABB,00037520,ABB,1.25,201406,11.6,12.135 ABCB,00040010,ABC BANCORP,0.64,199806,12,13.100625 ABCR,00075210,ABC RAIL PRODUCT,1.98,199512,16,22.154761905 ABCR,00075210,ABC RAIL PRODUCT,1.19,199809,15.11,15.11 ABCR,00075210,ABC-NACO INC,0.81,199903,13.5,19.5625 ABCR,00075210,ABC-NACO INC,1.71,199909,13.5,15.5 ABCR,00075210,ABC-NACO INC,0.01,200009,12.67,14.444 ABRX,00077R10,ABR INFO SVCS,0.18,199512,30.5,23.764805195 ABTC,00078210,ABT BUILDING PDT,1.44,199512,15.67,14.239545455 ACCC,00079410,ACC CORPORATION,0.01,199512,30,27.656538462 ACCI,00079H10,ACC CONSUMER FIN,0.44,199606,25,19.11 ACAH,00083310,ACA CAPITAL HLDG,69500,200712,10,15.6675 ACMR,00086T10,AC MOORE ARTS,0.45,199803,30,20.548504673 TACX,00088110,A CONSULT TEAM,4.3,199709,30,34 ADCT,00088610,ADC TELECOM,0.85,199512,24.71,27.656538462 ADCT,00088610,ADC TELECOM,2.33,199812,25.29,30.22 ADCT,00088610,ADC TELECOM,3,199912,25.14,36.782142857 ADCT,00088610,ADC TELECOM,4.86,200012,29.46,35.653333333 ;;;; ... View more

sdc_final is benchmark and m_fegg is event. ... View more

No, it don't work. even if I use new variable. ... View more

Thanks ,but I don't have variable yymm in sdc_final. ... View more

Ok, here is my data. I wana pick the data from' event' as the date of 'benchmark'. data WORK.BENCHMARK; infile datalines dsd truncover; input yymm_a:32. y_a:32. yymm_e:32. y_e:32. acq_cusip:$30. Acquiror_Name:$60. acq_sic:32. target_sic:32. cash_p:$18.; label Acquiror_Name="Acquiror Name"; datalines4; 200204,2002,200204,2002,00013L,APS Healthcare Bethsda,8099,8099,0 199312,1993,199401,1994,00026R,A-OK(GB-Inno-BM SA),5251,5251,0 200607,2006,200609,2006,00030F,AMI Semiconductor Inc,3674,3674,1 199106,1991,199106,1991,000352,AAI Corp,3812,3699,1 199201,1992,199201,1992,000352,AAI Corp,3812,3829,0 200611,2006,200611,2006,000352,AAI Corp,3812,3679,0 200802,2008,200803,2008,000361,AAR Corp,3724,4581,0 201003,2010,201004,2010,000361,AAR Corp,3724,4522,0 199710,1997,199711,1997,00074C,American Builders,5033,5033,0 199504,1995,199505,1995,000752,ABC Rail Products Corp,3469,4789,1 199704,1997,199707,1997,00075X,ABC Radio Networks,4832,4832,1 199805,1998,199805,1998,00077R,ABR Information Services Inc,7374,7389,0 199411,1994,199503,1995,000781,ABS Industries Inc,5085,3714,0 199401,1994,199403,1994,000872,ACS Enterprises Inc,4841,4841,1 199808,1998,199808,1998,00087X,ACSYS Inc,7363,7361,0 199603,1996,199603,1996,000886,ADC Telecommunications Inc,3669,1731,0 199801,1998,199801,1998,000886,ADC Telecommunications Inc,3669,5731,0 199905,1999,199906,1999,000886,ADC Telecommunications Inc,3669,3674,0 200403,2004,200405,2004,000886,ADC Telecommunications Inc,3669,3663,0 200710,2007,200712,2007,000886,ADC Telecommunications Inc,3669,4812,0 ;;;; data WORK.EVENT; infile datalines dsd truncover; input OFTIC:$6. CUSIP:$8. CNAME:$16. MEANEST:32. yymm:32. g:32. g_indavg:32.; label OFTIC="Official Ticker Symbol" CUSIP="CUSIP/SEDOL" CNAME="Company Name" MEANEST="fe_t+1" g="g"; datalines4; SODA,00020910,A & W BRANDS,0.45,198803,20,20 AAON,00036020,AAON,0.05,199512,17,14.239545455 ABB,00037520,ABB,1.25,201406,11.6,12.135 ABCB,00040010,ABC BANCORP,0.64,199806,12,13.100625 ABCR,00075210,ABC RAIL PRODUCT,1.98,199512,16,22.154761905 ABCR,00075210,ABC RAIL PRODUCT,1.19,199809,15.11,15.11 ABCR,00075210,ABC-NACO INC,0.81,199903,13.5,19.5625 ABCR,00075210,ABC-NACO INC,1.71,199909,13.5,15.5 ABCR,00075210,ABC-NACO INC,0.01,200009,12.67,14.444 ABRX,00077R10,ABR INFO SVCS,0.18,199512,30.5,23.764805195 ABTC,00078210,ABT BUILDING PDT,1.44,199512,15.67,14.239545455 ACCC,00079410,ACC CORPORATION,0.01,199512,30,27.656538462 ACCI,00079H10,ACC CONSUMER FIN,0.44,199606,25,19.11 ACAH,00083310,ACA CAPITAL HLDG,69500,200712,10,15.6675 ACMR,00086T10,AC MOORE ARTS,0.45,199803,30,20.548504673 TACX,00088110,A CONSULT TEAM,4.3,199709,30,34 ADCT,00088610,ADC TELECOM,0.85,199512,24.71,27.656538462 ADCT,00088610,ADC TELECOM,2.33,199812,25.29,30.22 ADCT,00088610,ADC TELECOM,3,199912,25.14,36.782142857 ADCT,00088610,ADC TELECOM,4.86,200012,29.46,35.653333333 ;;;; ... View more

Sorry , but I have problems. first, where is myfolds or any fold that can find the downloaded code? second, I can't find anywhere I can edit autoexec file. I use sas9.4.  ... View more

I had used Astounding's code directly, and I could get  about 2300 observations. (a.yymm - 300) <= b.yymm <= a.yymm ... View more

Right, I think I do understand what you said , and I revise my code, but the result is no observation. I check my code and find no mistake.  data m_fegg; set ibes.m_fegg; yymm=input(put(yymm,6.),yymmn6.); format yymm yymmn6.; run; data sdc_final; set sdc.sdc_final; yymm_a=input(put(yymm_a,6.),yymmn6.); yymm_e=input(put(yymm_e,6.),yymmn6.); format yymm_a yymm_e yymmn6.; run; proc sql; create table m_i_s1 as select b.*,a.yymm_a from sdc_final as a, m_fegg as b where intnx('month',a.yymm_a, -36,'same')<=b.yymm<=a.yymm_a & a.acq_cusip=b.cusip; quit; ... View more

Yes , I tried the right informat first, but I added a comma before !!, so it showed diffterent information. Thank you very much for your patience.  date_correct = input(put(yymm,6.) !! '01',yymmn6.); format date_correct yymmn6.; ... View more

 Hi tom, you explain it very clearly. But I am puzzled with ||. just because of put(yymm,6.), did you ad！！? If I want ouput yymm, can I change the code like this? But it didn't work. Sorry ,because I am a new user. Also, where can I find the date format like yymmn6 etc.? Thank you  date_correct = input(put(yymm,6.) '01',yymm6.); format date_correct date6.; ... View more

Hi,   why can't I just input(yymm, yymmdd8.)?  and what the meaning of !! and '01' in input function? Thanks ... View more