stata补充缺失值方法

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

求教： 我的样本是世界上所有国家的银行11年的数据，指标主要是资产，负债，  边际利息率， 成本费用率， 还有宏观变量 gdp  m2 等等，   但是这些数据中有缺失值， 我想用  mi  impute 补上， 请问用哪一种方法补比较好， 是 univariate 的还是multivariate的方法？ 具体里面是用哪种方法呢？谢谢各位!

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏5 回帖

关键词：Stata tata 缺失值 Multivariate multivariat 利息率 国家 成本 样本

请问楼主，怎样用stata 补充数据中的缺失值呀？我找的月度数据中，每一年的第一个月的数据都没有，这种情况怎么处理？谢啦

我也想问怎么补充缺失值啊？  如果你别的变量没有缺失值的话，有一个mi程序，处理缺失值的。

同求

help mvencode

没太明白mi impute怎么用。。。。

平军 发表于 2013-5-2 23:28
help mvencode

help mvencode, help mvdecode                       dialogs:  mvencode  mvdecode
-------------------------------------------------------------------------------

Title

    [D] mvencode -- Change missing values to numeric values and vice versa


Syntax

    Change missing values to numeric values

        mvencode varlist [if] [in], mv(#|mvc=# [\ mvc=#...] [\ else=#])
                  [override]


    Change numeric values to missing values

        mvdecode varlist [if] [in], mv(numlist | numlist=mvc
                  [\ numlist=mvc...])


    where mvc is one of .|.a|.b|...|.z


Menu

    mvencode

        Data > Create or change data > Other variable-transformation commands
            > Change missing values to numeric

    mvdecode

        Data > Create or change data > Other variable-transformation commands
            > Change numeric values to missing


Description

    mvencode changes missing values in the specified varlist to numeric
    values.

    mvdecode changes occurrences of a numlist in the specified varlist to a
    missing-value code.

    Missing-value codes may be sysmiss (.) and the extended missing-value
    codes .a, .b, ..., .z.

    String variables in varlist are ignored.


Options

        +------+
    ----+ Main +-------------------------------------------------------------

    mv(#|mvc=# [\ mvc=#...] [\ else=#]) is required and specifies the numeric
        values to which the missing values are to be changed.

        mv(#) specifies that all types of missing values be changed to #.

        mv(mvc=#) specifies that occurrences of missing-value code mvc be
        changed to #.  Multiple transformation rules may be specified,
        separated by a backward slash (\).  The list may be terminated by the
        special rule else=#, specifying that all types of missing values not
        yet transformed be set to #.

        Examples: mv(9), mv(.=99\.a=98\.b=97), mv(.=99\else=98)

    mv(numlist | numlist=mvc [\ numlist=mvc...]) is required and specifies
        the numeric values that are to be changed to missing values.

        mv(numlist=mvc) specifies that the values in numlist be changed into
        missing-value code mvc.  Multiple transformation rules may be
        specified, separated by a backward slash (\).  See [[U]] 11.1.8
        numlist for the syntax of a numlist.

        Examples: mv(9), mv(99=.\98=.a\97=.b), mv(99=.\100/999=.a)

    override specifies the protection provided by mvencode be overridden.
        Without this option, mvencode refuses to make the requested change if
        any of the numeric values are already used in the data.


Examples

    ---------------------------------------------------------------------------
    Setup
        . sysuse auto

    Translate missing values in the data to 999
        . mvencode _all, mv(999)

    Change 999 values back to missing values
        . mvdecode _all, mv(999)

    List the data
        . list rep78 if rep78 == .

    Set rep78 to 999 in observation 3
        . replace rep78 = 999 in 3

    Try to translate missing values in the data to 999
        . mvencode _all, mv(999)

    Force the translation of missing values in the data to 999
        . mvencode _all, mv(999) override

    ---------------------------------------------------------------------------
    Setup
        . sysuse auto, clear

    List the data
        . list rep78 foreign if rep78 == .

    Translate missing values for rep78 to 998 if foreign is Domestic and
    translate to 999 if foreign is Foreign
        . mvencode rep78 if foreign == 0, mv(998)
        . mvencode rep78 if foreign == 1, mv(999)

    List the data
        . list rep78 foreign if rep78 > 900

    For rep78, translate 998 to . and 999 to .a
        . mvdecode rep78, mv(998=. \ 999=.a)

    List the data
        . list rep78 foreign if rep78 >= .
    ---------------------------------------------------------------------------


Also see

    Manual:  [D] mvencode

      Help:  [D] generate, [D] recode

请问楼主解决这个问题了吗

感谢感谢！

霍仕鑫 发表于 2020-4-13 22:11
感谢感谢！

您好，我想问一下您会用这个嘛