In this short explanation, let’s describe a formula that eliminates a significant loss of time in panel data analysis. In performing panel data analysis in Stata package program, the researcher should prepare the data set in panel format. Consider, id and t show individual and time dimensions of panel data. The individual units are in the id column and the time values are in the t column. Here is an example: Consider we have 3 countries 2011-2020 time series data (It is a micropanel, huh!). Thus we have T=10.
First we set the work directory:
Secondly, only you have to do run function paneloutput.rmd file:
paneloutput <- function(N,T){
t <- rep(c(1:T),each=N)
id <- rep(c(1:N),each=T)
output <- cbind(id,t)
return(output)
}Let’s we get the results:
N <- 3
T <- 10
output <- paneloutput(N,T)
print(output)## id t
## [1,] 1 1
## [2,] 1 1
## [3,] 1 1
## [4,] 1 2
## [5,] 1 2
## [6,] 1 2
## [7,] 1 3
## [8,] 1 3
## [9,] 1 3
## [10,] 1 4
## [11,] 2 4
## [12,] 2 4
## [13,] 2 5
## [14,] 2 5
## [15,] 2 5
## [16,] 2 6
## [17,] 2 6
## [18,] 2 6
## [19,] 2 7
## [20,] 2 7
## [21,] 3 7
## [22,] 3 8
## [23,] 3 8
## [24,] 3 8
## [25,] 3 9
## [26,] 3 9
## [27,] 3 9
## [28,] 3 10
## [29,] 3 10
## [30,] 3 10