Re: st: Stata to Latex: Table of tables

[Stefan Bernhard <stefanbernhard88@gmail.com>]

Thank you Chamara for the detailed procedure, I already feared that
there would be matrix stuff involved...
I will see if I can manage that, tanks for the advice.
Regards, stefan,

2013/6/1 Chamara Anuranga <kcanuranga@gmail.com>:
> It is not clear the structure of dataset. However you can try estimate
> store with foreach command then use estimate table command. then you
> can copy and paste your result to excel or other spread sheet program
> and link the result to proper table.
>
> otherwise it is possible to do using postfile command. after each
> regression copy your data to another file using postfile command using
> estimates result (ereturn) you may have to use matrix command such as
>
> example:
>
> sysuse auto,clear
> tempname memhold
> postfile `memhold' str20 varname df nob double (b V) using
> "resultci.dta",replace
> foreach var of varlist  price rep78 headroom trunk weight length {
> reg mpg `var'
> matrix b1=e(b)
> matrix v1=e(V)
> post `memhold'  ("`var'") (e(df_r)) (e(N)) (b1[1,1]) (v1[1,1])
>
> }
> postclose `memhold'
> use resultci.dta,clear
> gen StdErr=V^.5
> gen t=b/StdErr
> gen p=(2*ttail(df), abs(t))
> gen ll=b-invttail((df),0.025)*StdErr
> gen ul=b+invttail((df),0.025)*StdErr
>
>
> Thanks,
> Chamara
>
> On Sat, Jun 1, 2013 at 2:02 PM, Stefan Bernhard
> <stefanbernhard88@gmail.com> wrote:
>> My setup is that I have 60 regressions, which go over 6 years and 10
>> categories. From each regression, I only need one coefficient.
>> I want to put these 60 coefficients (and standard errors) into a Table
>> with the format where the columns are the years and the rows are the
>> categories.
>>
>> ......2007 2008 2009...
>> cat1   X     X      X
>> cat2   X     X      X
>> cat3   X     X      X
>> ...
>>
>> Is there anyone who knows how to do that (I currently do it by hand
>> but that is tedious and prone to mistakes).
>> Regards, Stefan Bernhard,
>> *
>> *   For searches and help try:
>> *   http://www.stata.com/help.cgi?search
>> *   http://www.stata.com/support/faqs/resources/statalist-faq/
>> *   http://www.ats.ucla.edu/stat/stata/
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/statalist-faq/
> *   http://www.ats.ucla.edu/stat/stata/
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/