Transforming panel data variables (from Excel/Stata) to multiple matrices in Matlab

2 次查看（过去 30 天）
Martin Pott
Martin Pott 2014-7-2
评论： Shuichi Obuchi 2022-1-21
I would like to know if it is possible to go from my Excel/Stata dataset to variables in matrix form.
My problem is as follows: I have been working on my thesis in Stata, and therefore my data is formatted as can be seen in the image attached. However, I will use a Matlab code that will need a number of variables of interest (e.g. return) to be formatted as a matrix with t*n dimensions.
This means, for variable 'return', that I would like the variable return to look like this: [ret_n1_t1 ret_n2_t1 ret_nN_t1; ret_n1_t2 ret_n2_t2 ret_nN_t2; ret_n1_tT ret_n2_tT ret_nN_tT]
Where n is the observation, N is the number of observations, t is period and T is number of periods.
I apologize if this question is already asked before, but I am not sure what to search for in order to find it.
Thanks in advance.
EDIT: gvkey is my firm identifying variable and time is the time-variable.

请先登录，再回答此问题。

采纳的回答

Martin Pott
Martin Pott 2014-7-3
I have managed to edit the data to from 'long' to 'wide' in Stata and afterwards import it into Matlab, so the problem is fixed.
  1 个评论
Shuichi Obuchi
Shuichi Obuchi 2022-1-21
Matlab did not have long to wide funciton such like stata did it. I was looking for such fuction in Matlab. Your comment help me stop searching funciton.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by