generate a line include several variables

Hi, I am thinking how to generate ESG_Disclosure which include all years of ESG_disclosure score? so it will be: cusip year ESG_Disclosure_Score?
Thank you

Code:

* Example generated by -dataex-. To install: ssc install dataex
clear
input str25 cusip int year str21 esg_disclosure_2010 str8(esg_disclosure_2011 esg_disclosure_2012 esg_disclosure_2013 esg_disclosure_2014 esg_disclosure_2015 esg_disclosure_2016 esg_disclosure_2017) float(esg_disclosure_2019 esg_2020)
"#N/A Field Not Applicable" 2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2011 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2012 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2013 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2014 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2015 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2016 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2017 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2019 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2019 ""                      "" "" "" "" "" "" "" . .
"#N/A Field Not Applicable" 2020 ""                      "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Review"           "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
"#N/A Invalid Security"     2010 "#N/A Invalid Security" "" "" "" "" "" "" "" . .
end

------------------ copy up to and including the previous line ------------------

Share on FacebookPlus on Google+