Hello,

I would like to create a table with the correlation between public investment and public debt for each country in my sample, so I get a table like this:
Country Unconditional correlation Public debt ≥ 75th percentile Public debt ≥ 90th percentile Public debt ≥ 95th percentile
AT 0.26 -0.20 -0.89 1
BE 0.31 -0.62 0.52 1
BG -0.58 -0.91 -1 -
CY -0.72 -0.97 -0.69 1
CZ 0.005 -0.78 -0.54 -1

I cannot seem to figure out how to use the
Code:
pwcorr
command to create such a table. If I use
Code:
bys cid: pwcorr ipub debt_pub, sig star(.05)
, I simply get 28 different correlation tables..

Thank you for your help,

Willem