Hi Reeza, Thanks for your reply. With only one variable, it is easy to transpose.The code would look something like that: proc sort data=data; by company_name;run; proc transpose data=data out=data2; by company_name; run; data data3; set data2 (rename=(col1=Interest_paid)); year=substr(_NAME_,5); drop _name_ ; run; However, I have more than 100 variables, such as Interest paid, Dividend, etc., which have the form of Interest paid 2015, Interest paid 2014.......Interest paid 2005, Dividend 2015......Dividend 2005, etc. So, what I want to do is create a Year Variable and then have one Variable for Interest paid, Dividend, etc. Is there any way to do that? I steel cannot upload any data but this is what I want: HAVE: Company name Country Region BvD ID number ISIN number Date of incorporation Accounting practice 2013 Accounting practice 2012 Accounting practice 2011 Accounting practice 2010 Operating revenue (Turnover) th GBP 2013 Operating revenue (Turnover) th GBP 2012 Operating revenue (Turnover) th GBP 2011 Operating revenue (Turnover) th GBP 2010 P/L before tax th GBP 2013 P/L before tax th GBP 2012 P/L before tax th GBP 2011 P/L before tax th GBP 2010 1 BP P.L.C. UNITED KINGDOM London SW1Y GB00102498 GB0007980591 14/04/1909 IFRS IFRS IFRS IFRS 239,218,000 238,871,000 248,673,000 197,310,000 18,246,000 11,571,000 24,988,000 -3,082,000 2 VOLKSWAGEN AKTIENGESELLSCHAFT GERMANY Wolfsburg DE2070000543 DE0007664039 28/05/1937 IFRS IFRS IFRS IFRS 173,320,402 169,866,478 141,486,262 114,920,054 10,408,570 21,311,069 15,838,789 7,683,377 WANT: Company name Country Region BvD ID number ISIN number Date of incorporation YEAR Accounting practice Operating revenue (Turnover) th GBP P/L before tax th GBP 1 BP P.L.C. UNITED KINGDOM London SW1Y GB00102498 GB0007980591 14/04/1909 2010 IFRS 197,310,000 -3,082,000 1 BP P.L.C. UNITED KINGDOM London SW1Y GB00102498 GB0007980591 14/04/1909 2011 IFRS 248,673,000 24,988,000 1 BP P.L.C. UNITED KINGDOM London SW1Y GB00102498 GB0007980591 14/04/1909 2012 IFRS 238,871,000 11,571,000 1 BP P.L.C. UNITED KINGDOM London SW1Y GB00102498 GB0007980591 14/04/1909 2013 IFRS 239,218,000 18,246,000 2 VOLKSWAGEN AKTIENGESELLSCHAFT GERMANY Wolfsburg DE2070000543 DE0007664039 28/05/1937 2010 IFRS 114,920,054 7,683,377 2 VOLKSWAGEN AKTIENGESELLSCHAFT GERMANY Wolfsburg DE2070000543 DE0007664039 28/05/1937 2011 IFRS 141,486,262 15,838,789 2 VOLKSWAGEN AKTIENGESELLSCHAFT GERMANY Wolfsburg DE2070000543 DE0007664039 28/05/1937 2012 IFRS 169,866,478 21,311,069 2 VOLKSWAGEN AKTIENGESELLSCHAF GERMANY Wolfsburg DE2070000543 DE0007664039 28/05/1937 2013 IFRS 173,320,402 10,408,570
... View more
