Announcement

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

  • esttab shows _missing_ for row labels

    When I generate an output table using this sequence of commands:
    eststo clear
    eststo: estpost tab farmerestimate
    esttab, cells ("b (fmt(a2)) pct (fmt( %9.1f))") ///
    label nomti nonum ///
    collabels ("Number" "Percent") ///
    title(Table: Farmer Estimate of Plot Sizes)

    The rows are labeled _missing_5, 1_missing_0, etc. instead of .5 and 1.0 as they are when you view the results using the regular tab command (tab farmerestimate). As a newbie, I really don't have a clue how to trouble shoot this. Ideas?

  • #2
    Might this just be about the value labels attached to the variable you are tabulating? see -help label-.

    An example

    Code:
    sysuse auto, clear
    
    eststo clear
    eststo: estpost tab foreign
    esttab, cells ("b (fmt(a2)) pct (fmt( %9.1f))") ///
    label nomti nonum ///
    collabels ("Number" "Percent") ///
    title(Table: Farmer Estimate of Plot Sizes)
    
    ** Change the value labels
    la define faklbl 1"_missing_5" 0"_missing_0"
    la val foreign faklbl
    
    eststo clear
    eststo: estpost tab foreign
    esttab, cells ("b (fmt(a2)) pct (fmt( %9.1f))") ///
    label nomti nonum ///
    collabels ("Number" "Percent") ///
    title(Table: Farmer Estimate of Plot Sizes)
    010100100110111101101110011011100110100101100101

    Comment

    Working...
    X