Hi,
I am currently working on my Master Thesis and I have obtained data from datastream. Unfortunately, a time series request in Datastream loads the relevant variables horizontally in one column and the years vertically. I am trying to reshape the data in Stata but so far I haven't been able to succeed. Company identifiers such as name (Name) and datastream code (Dscode) are already in long format, I would like to have the annual data (columns Y2002-2014) in long format as well and the variables which are currently in one column (Code) in wide format. The are 37 variables represented in the Code column which are at this point all included 248 times in the column (=N).
Does anyone have any suggestions for me?
Thanks in advance!
I am currently working on my Master Thesis and I have obtained data from datastream. Unfortunately, a time series request in Datastream loads the relevant variables horizontally in one column and the years vertically. I am trying to reshape the data in Stata but so far I haven't been able to succeed. Company identifiers such as name (Name) and datastream code (Dscode) are already in long format, I would like to have the annual data (columns Y2002-2014) in long format as well and the variables which are currently in one column (Code) in wide format. The are 37 variables represented in the Code column which are at this point all included 248 times in the column (=N).
Does anyone have any suggestions for me?
Thanks in advance!
Comment