Values of Coefficient and Power of Test in Data Editor

[Sagnik Bagchi]

Hello,

I am using the following command "bysort var: reg y x". In doing so, I get many results.

For each of the set of regression results, I want to have the values of both "Coef. of x" and "P>|t|" pasted in the data editor corresponding to each set of var. After the analysis my data editor should look like the following (an example)

var	y	x	Coef.	P>|t|
1	0.8	2005	2.03	0.000
1	0.9	2006	2.03	0.000
1	1.5	2007	2.03	0.000
1	0.78	2008	2.03	0.000
2	5.23	2011	-0.73	0.98
2	6.56	2012	-0.73	0.98
2	4.33	2013	-0.73	0.98

Is there any way I go about this in STATA?

Many thanks,
Sagnik