topic how to compute age of the company from the date of its incorporation? in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-compute-age-of-the-company-from-the-date-of-its/m-p/778745#M247924 <P>dear all&nbsp;</P><P>i have the data of 163 companies with their incorporate year&nbsp; in the following format.</P><TABLE><TBODY><TR><TD>Company_Name</TD><TD>Incorporation&nbsp;</TD></TR><TR><TD>A C C Ltd.</TD><TD>1936</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>1991</TD></TR><TR><TD>Adani Enterprises Ltd.</TD><TD>1993</TD></TR><TR><TD>Adani Green Energy Ltd.</TD><TD>2015</TD></TR><TR><TD>Adani Ports &amp; Special Economic Zone Ltd.</TD><TD>1998</TD></TR><TR><TD>Aditya Birla Fashion &amp; Retail Ltd.</TD><TD>2007</TD></TR><TR><TD>Ambuja Cements Ltd.</TD><TD>1981</TD></TR><TR><TD>Apollo Hospitals Enterprise Ltd.</TD><TD>1979</TD></TR><TR><TD>Apollo Tyres Ltd.</TD><TD>1972</TD></TR><TR><TD>Ashok Leyland Ltd.</TD><TD>1948</TD></TR><TR><TD>Asian Paints Ltd.</TD><TD>1945</TD></TR><TR><TD>Aurobindo Pharma Ltd.</TD><TD>1986</TD></TR><TR><TD>Avenue Supermarts Ltd.</TD><TD>2000</TD></TR><TR><TD>Axis Bank Ltd.</TD><TD>1993</TD></TR><TR><TD>Bajaj Auto Ltd.</TD><TD>2007</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>i have to compute the age of each company in the following format from 2010 to 2021. it is to be computed as the number of years from the year of incorporation to the current year.</P><P>i&nbsp; need it in the following format</P><TABLE><TBODY><TR><TD>Company_Name</TD><TD>year</TD><TD>age</TD></TR><TR><TD>A C C Ltd.</TD><TD>2010</TD><TD>74</TD></TR><TR><TD>A C C Ltd.</TD><TD>2011</TD><TD>75</TD></TR><TR><TD>A C C Ltd.</TD><TD>2012</TD><TD>76</TD></TR><TR><TD>A C C Ltd.</TD><TD>2013</TD><TD>77</TD></TR><TR><TD>A C C Ltd.</TD><TD>2014</TD><TD>78</TD></TR><TR><TD>A C C Ltd.</TD><TD>2015</TD><TD>79</TD></TR><TR><TD>A C C Ltd.</TD><TD>2016</TD><TD>80</TD></TR><TR><TD>A C C Ltd.</TD><TD>2017</TD><TD>81</TD></TR><TR><TD>A C C Ltd.</TD><TD>2018</TD><TD>82</TD></TR><TR><TD>A C C Ltd.</TD><TD>2019</TD><TD>83</TD></TR><TR><TD>A C C Ltd.</TD><TD>2020</TD><TD>84</TD></TR><TR><TD>A C C Ltd.</TD><TD>2021</TD><TD>85</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2010</TD><TD>19</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2011</TD><TD>20</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2012</TD><TD>21</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2013</TD><TD>22</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2014</TD><TD>23</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2015</TD><TD>24</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2016</TD><TD>25</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2017</TD><TD>26</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2018</TD><TD>27</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2019</TD><TD>28</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2020</TD><TD>29</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2021</TD><TD>30</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>please suggest me a suitable SAS code \</P><P>thanks in advance&nbsp;</P><P>&nbsp;</P> Fri, 05 Nov 2021 13:12:07 GMT srikanthyadav44 2021-11-05T13:12:07Z how to compute age of the company from the date of its incorporation? https://communities.sas.com/t5/SAS-Programming/how-to-compute-age-of-the-company-from-the-date-of-its/m-p/778745#M247924 <P>dear all&nbsp;</P><P>i have the data of 163 companies with their incorporate year&nbsp; in the following format.</P><TABLE><TBODY><TR><TD>Company_Name</TD><TD>Incorporation&nbsp;</TD></TR><TR><TD>A C C Ltd.</TD><TD>1936</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>1991</TD></TR><TR><TD>Adani Enterprises Ltd.</TD><TD>1993</TD></TR><TR><TD>Adani Green Energy Ltd.</TD><TD>2015</TD></TR><TR><TD>Adani Ports &amp; Special Economic Zone Ltd.</TD><TD>1998</TD></TR><TR><TD>Aditya Birla Fashion &amp; Retail Ltd.</TD><TD>2007</TD></TR><TR><TD>Ambuja Cements Ltd.</TD><TD>1981</TD></TR><TR><TD>Apollo Hospitals Enterprise Ltd.</TD><TD>1979</TD></TR><TR><TD>Apollo Tyres Ltd.</TD><TD>1972</TD></TR><TR><TD>Ashok Leyland Ltd.</TD><TD>1948</TD></TR><TR><TD>Asian Paints Ltd.</TD><TD>1945</TD></TR><TR><TD>Aurobindo Pharma Ltd.</TD><TD>1986</TD></TR><TR><TD>Avenue Supermarts Ltd.</TD><TD>2000</TD></TR><TR><TD>Axis Bank Ltd.</TD><TD>1993</TD></TR><TR><TD>Bajaj Auto Ltd.</TD><TD>2007</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>i have to compute the age of each company in the following format from 2010 to 2021. it is to be computed as the number of years from the year of incorporation to the current year.</P><P>i&nbsp; need it in the following format</P><TABLE><TBODY><TR><TD>Company_Name</TD><TD>year</TD><TD>age</TD></TR><TR><TD>A C C Ltd.</TD><TD>2010</TD><TD>74</TD></TR><TR><TD>A C C Ltd.</TD><TD>2011</TD><TD>75</TD></TR><TR><TD>A C C Ltd.</TD><TD>2012</TD><TD>76</TD></TR><TR><TD>A C C Ltd.</TD><TD>2013</TD><TD>77</TD></TR><TR><TD>A C C Ltd.</TD><TD>2014</TD><TD>78</TD></TR><TR><TD>A C C Ltd.</TD><TD>2015</TD><TD>79</TD></TR><TR><TD>A C C Ltd.</TD><TD>2016</TD><TD>80</TD></TR><TR><TD>A C C Ltd.</TD><TD>2017</TD><TD>81</TD></TR><TR><TD>A C C Ltd.</TD><TD>2018</TD><TD>82</TD></TR><TR><TD>A C C Ltd.</TD><TD>2019</TD><TD>83</TD></TR><TR><TD>A C C Ltd.</TD><TD>2020</TD><TD>84</TD></TR><TR><TD>A C C Ltd.</TD><TD>2021</TD><TD>85</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2010</TD><TD>19</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2011</TD><TD>20</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2012</TD><TD>21</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2013</TD><TD>22</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2014</TD><TD>23</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2015</TD><TD>24</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2016</TD><TD>25</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2017</TD><TD>26</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2018</TD><TD>27</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2019</TD><TD>28</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2020</TD><TD>29</TD></TR><TR><TD>A I A Engineering Ltd.</TD><TD>2021</TD><TD>30</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>please suggest me a suitable SAS code \</P><P>thanks in advance&nbsp;</P><P>&nbsp;</P> Fri, 05 Nov 2021 13:12:07 GMT https://communities.sas.com/t5/SAS-Programming/how-to-compute-age-of-the-company-from-the-date-of-its/m-p/778745#M247924 srikanthyadav44 2021-11-05T13:12:07Z Re: how to compute age of the company from the date of its incorporation? https://communities.sas.com/t5/SAS-Programming/how-to-compute-age-of-the-company-from-the-date-of-its/m-p/778748#M247926 <P>So&nbsp;<SPAN>A C C Ltd. should be computed from 1936 to 2021 right?</SPAN></P> Fri, 05 Nov 2021 13:16:08 GMT https://communities.sas.com/t5/SAS-Programming/how-to-compute-age-of-the-company-from-the-date-of-its/m-p/778748#M247926 PeterClemmensen 2021-11-05T13:16:08Z Re: how to compute age of the company from the date of its incorporation? https://communities.sas.com/t5/SAS-Programming/how-to-compute-age-of-the-company-from-the-date-of-its/m-p/778767#M247933 <PRE><CODE class=" language-sas">data have; infile datalines delimiter = ","; input company_name :$50. incorporation 4.; datalines; A C C Ltd.,1936 A I A Engineering Ltd.,1991 Adani Enterprises Ltd.,1993 Adani Green Energy Ltd.,2015 Adani Ports &amp; Special Economic Zone Ltd.,1998 Aditya Birla Fashion &amp; Retail Ltd.,2007 Ambuja Cements Ltd.,1981 Apollo Hospitals Enterprise Ltd.,1979 Apollo Tyres Ltd.,1972 Ashok Leyland Ltd.,1948 Asian Paints Ltd.,1945 Aurobindo Pharma Ltd.,1986 Avenue Supermarts Ltd.,2000 Axis Bank Ltd.,1993 Bajaj Auto Ltd.,2007 ; run; data want (drop = incorporation); set have; do year = 2010 to 2021; age = year - incorporation; output; end; run;</CODE></PRE> <PRE>company_name year age A C C Ltd. 2010 74 A C C Ltd. 2011 75 A C C Ltd. 2012 76 A C C Ltd. 2013 77 A C C Ltd. 2014 78 A C C Ltd. 2015 79 A C C Ltd. 2016 80 A C C Ltd. 2017 81 A C C Ltd. 2018 82 A C C Ltd. 2019 83 A C C Ltd. 2020 84 A C C Ltd. 2021 85 A I A Engineering Ltd. 2010 19 A I A Engineering Ltd. 2011 20 A I A Engineering Ltd. 2012 21</PRE> <P>&nbsp;Not sure how you want to deal with those negative values, but you can easily subset it.</P> Fri, 05 Nov 2021 13:40:08 GMT https://communities.sas.com/t5/SAS-Programming/how-to-compute-age-of-the-company-from-the-date-of-its/m-p/778767#M247933 maguiremq 2021-11-05T13:40:08Z