https://communities.sas.com/t5/SAS-Programming/How-do-I-calculate-years-between-transactions/m-p/455794#M115358 <P>Look at the DIF function</P> Fri, 20 Apr 2018 00:45:20 GMT Reeza 2018-04-20T00:45:20Z https://communities.sas.com/t5/SAS-Programming/How-do-I-calculate-years-between-transactions/m-p/455781#M115357 <P>Hi,&nbsp;</P><P>&nbsp;</P><P>I have firm data with IPO. It looks like&nbsp;</P><P>&nbsp;</P><P>year firmid IPO</P><P>1990 abc 1</P><P>1995 abc 1</P><P>1997 def 1</P><P>2000 def 1</P><P>2000 ghi 1</P><P>2002 jkl 1</P><P>&nbsp;</P><P>I want to calculate the years between IPOs if a firm has more than 1 IPO.&nbsp;</P><P>For example,&nbsp;</P><P>year firmid IPO duration</P><P>1990 abc 1 0</P><P>1995 abc 1 5 (1995-1990)</P><P>1997 def 1 0</P><P>2000 def 1 3 (2000-1997)</P><P>2000 ghi 1 0</P><P>2002 jkl 1 0</P><P>&nbsp;</P><P>Thank you for your help in advance.&nbsp;</P> Fri, 20 Apr 2018 00:26:49 GMT https://communities.sas.com/t5/SAS-Programming/How-do-I-calculate-years-between-transactions/m-p/455781#M115357 kelSAS 2018-04-20T00:26:49Z https://communities.sas.com/t5/SAS-Programming/How-do-I-calculate-years-between-transactions/m-p/455794#M115358 <P>Look at the DIF function</P> Fri, 20 Apr 2018 00:45:20 GMT https://communities.sas.com/t5/SAS-Programming/How-do-I-calculate-years-between-transactions/m-p/455794#M115358 Reeza 2018-04-20T00:45:20Z