dear ChrisNZ thanks for responding to my query the code suggested by you is not working.    the variables along with their type is as follows    Num 8 COMMA15.2   ESG2000 ESG2001 Num 8 COMMA15.2   ESG2001 ESG2002 Num 8 COMMA15.2   ESG2002 ESG2003 Num 8 COMMA15.2   ESG2003 ESG2004 Num 8 COMMA15.2   ESG2004 ESG2005 Num 8 COMMA15.2   ESG2005 ESG2006 Num 8 COMMA15.2   ESG2006 ESG2007 Num 8 COMMA15.2   ESG2007 ESG2008 Num 8 COMMA15.2   ESG2008 ESG2009 Num 8 COMMA15.2   ESG2009 ESG2010 Num 8 COMMA15.2   ESG2010 ESG2011 Num 8 COMMA15.2   ESG2011 ESG2012 Num 8 COMMA15.2   ESG2012 ESG2013 Num 8 COMMA15.2   ESG2013 ESG2014 Num 8 COMMA15.2   ESG2014 ESG2015 Char 1 $1. $1. ESG2015 ESG2016 Char 1 $1. $1. ESG2016 ESG2017 Char 1 $1. $1. ESG2017 ESG2018 Char 1 $1. $1. ESG2018 ESG2019 Char 1 $1. $1. ESG2019 ESG2020 Char 1 $1. $1. ESG2020 Environment2000 Num 8 COMMA15.2   Environment2000 Environment2001 Num 8 COMMA15.2   Environment2001 Environment2002 Num 8 COMMA15.2   Environment2002 Environment2003 Num 8 COMMA15.2   Environment2003 Environment2004 Num 8 COMMA15.2   Environment2004 Environment2005 Num 8 COMMA15.2   Environment2005 Environment2006 Num 8 COMMA15.2   Environment2006 Environment2007 Num 8 COMMA15.2   Environment2007 Environment2008 Num 8 COMMA15.2   Environment2008 Environment2009 Num 8 COMMA15.2   Environment2009 Environment2010 Num 8 COMMA15.2   Environment2010 Environment2011 Num 8 COMMA15.2   Environment2011 Environment2012 Num 8 COMMA15.2   Environment2012 Environment2013 Num 8 COMMA15.2   Environment2013 Environment2014 Num 8 COMMA15.2   Environment2014 Environment2015 Char 1 $1. $1. Environment2015 Environment2016 Char 1 $1. $1. Environment2016 Environment2017 Char 1 $1. $1. Environment2017 Environment2018 Char 1 $1. $1. Environment2018 Environment2019 Char 1 $1. $1. Environment2019 Environment2020 Char 1 $1. $1. Environment2020 Governance2000 Num 8 COMMA15.2   Governance2000 Governance2001 Num 8 COMMA15.2   Governance2001 Governance2002 Num 8 COMMA15.2   Governance2002 Governance2003 Num 8 COMMA15.2   Governance2003 Governance2004 Num 8 COMMA15.2   Governance2004 Governance2005 Num 8 COMMA15.2   Governance2005 Governance2006 Num 8 COMMA15.2   Governance2006 Governance2007 Num 8 COMMA15.2   Governance2007 Governance2008 Num 8 COMMA15.2   Governance2008 Governance2009 Num 8 COMMA15.2   Governance2009 Governance2010 Num 8 COMMA15.2   Governance2010 Governance2011 Num 8 COMMA15.2   Governance2011 Governance2012 Num 8 COMMA15.2   Governance2012 Governance2013 Num 8 COMMA15.2   Governance2013 Governance2014 Num 8 COMMA15.2   Governance2014 Governance2015 Char 1 $1. $1. Governance2015 Governance2016 Char 1 $1. $1. Governance2016 Governance2017 Char 1 $1. $1. Governance2017 Governance2018 Char 1 $1. $1. Governance2018 Governance2019 Char 1 $1. $1. Governance2019 Governance2020 Char 1 $1. $1. Governance2020 Social2000 Num 8 COMMA15.2   Social2000 Social2001 Num 8 COMMA15.2   Social2001 Social2002 Num 8 COMMA15.2   Social2002 Social2003 Num 8 COMMA15.2   Social2003 Social2004 Num 8 COMMA15.2   Social2004 Social2005 Num 8 COMMA15.2   Social2005 Social2006 Num 8 COMMA15.2   Social2006 Social2007 Num 8 COMMA15.2   Social2007 Social2008 Num 8 COMMA15.2   Social2008 Social2009 Num 8 COMMA15.2   Social2009 Social2010 Num 8 COMMA15.2   Social2010 Social2011 Num 8 COMMA15.2   Social2011 Social2012 Num 8 COMMA15.2   Social2012 Social2013 Num 8 COMMA15.2   Social2013 Social2014 Num 8 COMMA15.2   Social2014 Social2015 Char 1 $1. $1. Social2015 Social2016 Char 1 $1. $1. Social2016 Social2017 Char 1 $1. $1. Social2017 Social2018 Char 1 $1. $1. Social2018 Social2019 Char 1 $1. $1. Social2019 Social2020 Char 1 $1. $1. Social2020 company_name Char 107 $107. $107. company_name     i need all the variables, except company_name in numeric format   please suggest me an appropriate SAS code thanks in advance       ... View more