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 & Special Economic Zone Ltd.,1998
Aditya Birla Fashion & 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;
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
Not sure how you want to deal with those negative values, but you can easily subset it.
... View more
