Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to Combine Regression Results in two columns and multiple rows

    I have a set of regressions - say they are stores as model_11 and model_12 going up to model_n1 and model_n2 and I want to report the results in two columns and n rows.
    How do I do this?
    Here is some example code.

    input id y race gender education training
    1 100000 0 0 16 0
    2 125000 0 0 18 1
    3 90000 0 1 16 1
    4 115000 0 1 18 1
    5 80000 1 0 16 0
    6 105000 1 1 18 1
    end

    regress y education
    est sto model_11
    regress y education training
    est sto model_12

    regress y education race
    est sto model_21
    regress y education race training
    est sto model_22

    esttab model_11 model_12, b(3) se(3) ///
    nomtitle label ///
    keep(education) ///
    mlabels("No" "Training") ///
    mgroups("Regression Results", pattern(1 0)) ///
    coeflabels(education "Model 1")

    esttab model_21 model_22, append b(3) se(3) ///
    nomtitle label ///
    keep(education) ///
    mlabels("No" "Training" "No" "Training") ///
    mgroups("Regression Results", pattern(1 1 0 0)) ///
    coeflabels(education "Model 2")

  • #2
    I guess "append" option would work. But you need to specify a filename.

    Code:
    esttab model_11 model_12 using myfile.csv , b(3) se(3) ///
    nomtitle label ///
    keep(education) ///
    mlabels("No" "Training") ///
    mgroups("Regression Results", pattern(1 0)) ///
    coeflabels(education "Model 1")
    Code:
    esttab model_21 model_22 using myfile.csv, append b(3) se(3) ///
    nomtitle label ///
    keep(education) ///
    mlabels("No" "Training" "No" "Training") ///
    mgroups("Regression Results", pattern(1 1 0 0)) ///
    coeflabels(education "Model 2")

    Comment

    Working...
    X