Matrix in STATA

[Khati Zolfaghari]

hello dear all,
I have panel data,
I am trying to create a matrix in my dataset. based on the specific formula.

phi(ij,t)= -|[Y( i,t) - Y( i,t-1)]-[Y( j,t) - Y( j,t-1)]|

I used this code"

foreach i of varlist country {

foreach j of varlist country{
if "`i'" !="`j'" {
gen phi_ij = abs(d.almp[`i'] - d.almp[`j'])
replace phi_ij = -phi_ij if country !="`i'" & country !="`j'"
display "phi_ij" per la coppia `i' e `j' : phi_ij


}


}


}

this is a part of my data.

----------------------- copy starting from the next line -----------------------

* Example generated by -dataex-. For more info, type help dataex
clear
input str4 Country float ifscode double(year almp)
"AUT" 122 1980   .
"AUT" 122 1981   .
"AUT" 122 1982   .
"AUT" 122 1983   .
"AUT" 122 1984   .
"AUT" 122 1985 .28
"AUT" 122 1986 .33
"AUT" 122 1987 .36
"AUT" 122 1988 .26
"AUT" 122 1989 .28
"AUT" 122 1990 .32
"AUT" 122 1991 .36
"AUT" 122 1992  .3
"AUT" 122 1993 .34
"AUT" 122 1994 .37
"AUT" 122 1995 .38
"AUT" 122 1996 .41
"AUT" 122 1997 .45
"AUT" 122 1998 .46
"AUT" 122 1999 .54
"AUT" 122 2000 .52
"AUT" 122 2001 .57
"AUT" 122 2002 .55
"AUT" 122 2003 .62
"AUT" 122 2004  .6
"AUT" 122 2005 .62
"AUT" 122 2006 .71
"AUT" 122 2007 .67
"AUT" 122 2008 .67
"AUT" 122 2009 .84
"AUT" 122 2010 .84
"AUT" 122 2011 .75
"AUT" 122 2012   .
"AUT" 122 2013   .
"AUT" 122 2014   .
"AUT" 122 2015   .
"AUT" 122 2016   .
"AUT" 122 2017   .
"AUT" 122 2018   .
"AUT" 122 2019   .
"AUT" 122 2020   .
"AUT" 122 1980   .
"AUT" 122 1981   .
"AUT" 122 1982   .
"AUT" 122 1983   .
"AUT" 122 1984   .
"AUT" 122 1985 .28
"AUT" 122 1986 .33
"AUT" 122 1987 .36
"AUT" 122 1988 .26
"AUT" 122 1989 .28
"AUT" 122 1990 .32
"AUT" 122 1991 .36
"AUT" 122 1992  .3
"AUT" 122 1993 .34
"AUT" 122 1994 .37
"AUT" 122 1995 .38
"AUT" 122 1996 .41
"AUT" 122 1997 .45
"AUT" 122 1998 .46
"AUT" 122 1999 .54
"AUT" 122 2000 .52
"AUT" 122 2001 .57
"AUT" 122 2002 .55
"AUT" 122 2003 .62
"AUT" 122 2004  .6
"AUT" 122 2005 .62
"AUT" 122 2006 .71
"AUT" 122 2007 .67
"AUT" 122 2008 .67
"AUT" 122 2009 .84
"AUT" 122 2010 .84
"AUT" 122 2011 .75
"AUT" 122 2012   .
"AUT" 122 2013   .
"AUT" 122 2014   .
"AUT" 122 2015   .
"AUT" 122 2016   .
"AUT" 122 2017   .
"AUT" 122 2018   .
"AUT" 122 2019   .
"AUT" 122 2020   .
"AUT" 122 1980   .
"AUT" 122 1981   .
"AUT" 122 1982   .
"AUT" 122 1983   .
"AUT" 122 1984   .
"AUT" 122 1985 .28
"AUT" 122 1986 .33
"AUT" 122 1987 .36
"AUT" 122 1988 .26
"AUT" 122 1989 .28
"AUT" 122 1990 .32
"AUT" 122 1991 .36
"AUT" 122 1992  .3
"AUT" 122 1993 .34
"AUT" 122 1994 .37
"AUT" 122 1995 .38
"AUT" 122 1996 .41
"AUT" 122 1997 .45
end

------------------ copy up to and including the previous line ------------------

Listed 100 out of 5521 observations
Use the count() option to list more



I appreciate recieving your comments and assistance.
best regards,

[Khati Zolfaghari]

I hope I receive your advice.