Hi,

I am trying to export a descriptive statistics of panel data from STATA to excel by using the following code,

Code:
univar Y X1 X2 X3
I got the result like below
Code:
                                        -------------- Quantiles --------------
Variable       n     Mean     S.D.      Min      .25      Mdn      .75      Max
-------------------------------------------------------------------------------
  LN_PAT   79447     1.12     1.43     0.00     0.00     0.69     1.79     9.06
 LN_CITE   79447     0.70     1.26     0.00     0.00     0.00     1.10     8.97
LN_GENERAL   79447     0.34     0.78     0.00     0.00     0.00     0.41     7.02
LN_ORIGINAL   79447     0.33     0.77     0.00     0.00     0.00     0.40     6.83
  IE_PAT   50553     2.29    12.49     0.00     0.00     0.18     0.82   792.34
 IE_CITE   50553     1.37     8.87     0.00     0.00     0.00     0.37   513.86
Liquidity   76721     7.60     3.14   -21.25     5.26     7.66     9.94    20.58
  Spread   38900     0.02     0.08    -0.48     0.00     0.01     0.02     1.92
LN_Total_Assets   70930    12.79     2.19    -2.00    11.38    12.68    14.14    22.09
   PPETA   69088     0.76    48.64     0.00     0.28     0.50     0.79 12778.00
     LEV   70904     2.31   526.79     0.00     0.04     0.18     0.33  1.4e+05
 CAPEXTA   66332     0.05     0.05    -0.28     0.02     0.04     0.07     1.93
    RDTA   52485     0.09     0.49    -0.00     0.01     0.03     0.08    79.05
       Q   70018    35.43  8150.82 -1215.39     1.04     1.38     2.17  2.2e+06
  LN_AGE   79447     2.40     0.80     0.69     1.79     2.48     3.04     3.87
Short_Liq   70233     2.90    12.61     0.00     1.25     1.80     2.94  2984.44
    Cash   50299     0.12     0.14    -0.44     0.03     0.08     0.16     1.00
     ROA   68467   -12.62  2379.64 -5.3e+05     0.00     0.04     0.08   189.06
   LN_MV   78545     5.46     2.28   -28.64     4.04     5.38     6.89    13.19
Sale_growth   67772     0.79    58.48   -20.70    -0.03     0.06     0.20 11879.50
-------------------------------------------------------------------------------
However, when I am trying to export it to excel with fix format. the result looks like below
Code:
 set matsize 10000

. outreg2 using statistics_firm, replace
matrix e(b) not found; run/post a regression, or specify varlist for non-regression outputs
r(111);

end of do-file

r(111);
Do you know why? What should I do? Could you please give me some suggestions about this?
Besides,
1) I am a fresher of STATA, if you have some webpage to introduce a complete process to create descriptive statistics and correlation of a panel data, could you please share it to me?
2) when creating statistics and correlation of panel data, will there be any difference between it and other kinds of data? or Is there anything I need to pay special attention to？

I am trying to create tables like below,
(Thanks in advance)
Array
Array