Transforming panel data variables (from Excel/Stata) to multiple matrices in Matlab
조회 수: 1 (최근 30일)
이전 댓글 표시
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.
댓글 수: 0
채택된 답변
Martin Pott
2014년 7월 3일
댓글 수: 1
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에서 Data Import from MATLAB에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!