# Re: st: Re: Create a table with signs of estimated coefficients

 From "Austin Nichols" To statalist@hsphsun2.harvard.edu Subject Re: st: Re: Create a table with signs of estimated coefficients Date Thu, 8 Mar 2007 10:54:26 -0500

```Nikos--
read -help macro- and -help matrix- and linked help files, then check
automate your tables.  Here is an example of what you might want:

clear
sysuse auto
reg pr mpg wei for
mat b1=e(b)
mat v1=e(V)
local df1=e(df_r)
sysuse cancer
reg died age
mat b2=e(b)
mat v2=e(V)
local df2=e(df_r)

local order "age mpg weight foreign _cons"
file close _all
file open t using /t.txt, write replace
file write t _tab "auto" _tab "cancer"
file write t _n _tab "(price)" _tab "(died)"
foreach v of local order {
file write t _n "`v'"
forv i=1/2 {
file write t _tab
local b=b`i'[1,colnumb(b`i',"`v'")]
local plus=cond(`b'>0,"+","-")
if `b'<. file write t "`plus'"
local s=sqrt(v`i'[colnumb(b`i',"`v'"),colnumb(b`i',"`v'")])
local t= b`i'[1,colnumb(b`i',"`v'")]/`s'
local p=ttail(`t',`df`i'')
if `b'<. &(`t'==. | `p'<.05) file write t "`plus'"
}
}
file close _all
type /t.txt

```
```Method 1 involves headacke, and is not readily automated
Method 2 requires some more programming effort but simultaneously gives you
full control.
Method 3:
1) wait for other suggestions...

----- Original Message -----
From: "Nikolaos Kanellopoulos" <nkkanel@yahoo.gr>
> Dear all,
>
> I am estimating the same model in different datasets (the names of the
> variables used are the same in all datasets).
>
> I want to create a table with the sign of estimated coefficients and if
> possible have a double sign if the coefficient is significant.
```
```*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```