Hi,

This is my first time here on statalist, I am trying to do a portfolio analysis in Stata and ran into some problems. I am hoping one of you could help me.

1) I have a dataset with data for about 1500 companies and monthly return data, however this monthly return data is all in different variables. So a variable for January 2000, one for February 2000 etc until June 2018. However i want to forecast this data and therefore set it as panel data, however for this to work i would need to have one variable that has all returns as observations to use xtset. So my question is how can i combine the different variables into one such that i have for all companies 222 (18,5 years * 12 months) observations of return?

2) In the same data set i have other scores (environmental, social and governmental) for the companies, however these are yearly. I would also like to forecast these. I think that I would need to split these before declaring them as panel data because of the difference in time periods (monthly vs yearly), is that correct? Or is there someway to work around this?

Thanks in advance!

Kind regards,