Hello everyone,
I am currently facing some troubles setting up my data.
I have the format like this at the moment:
Company, Variable(containts ESG, Marketcap f.i.), Currency and then daily dates so, 21 jun2001 22 jun2001

However, I would like to have it likes this
Date Company ESG Marketcap Currency
21 jun2001 Adecco 60 20,000 $
22 jun 2002

Note that nothing is named as variables either as stata is not able to handle this amount of variables as I am using 20 years of daily data.

Thanks in advance!