stata 检测缺失值的方法
//检测缺失值方法: //用.表示缺失值,将缺失值定义为无穷大 //方法一:检测当前行有几个变量是缺失值,Stata执行描述性统计命令时,会自动忽略变量的缺失值;执行回归命令时,如果其中某个变量包含缺失值,Stata忽略这个变量所属观测值上所有变量取值 egen miss=rowmiss(_all) //方法二:检测当前行以pidhaizi开头的变量有几个是缺失值 egen miss=rowmiss(pidhaizi*) //方法三:分别统计每个变量分别有几个缺失值 //安装 ssc install nmissing // checking nmissing consistency and verifying not already installed... // installing into C:\Users\admin\ado\plus\... // installation complete. . nmissing // // age 51476 // pidhaizi 42208 // pidhaizia 42964 // pidhaizib 85696 // pidhaizic 88235 // pidhaizid 88662 // pidhaizie 88771 // pidhaizif 88808 // pidhaizig 88828 //方法四: . codebook age // // --------------------------------------------------------------------------- // age 年龄 // --------------------------------------------------------------------------- // // Type: Numeric (double) // Label: age, but 93 nonmissing values are not labeled // // Range: [-8,102] Units: 1 // Unique values: 94 Missing .: 51,476/88,830 // // Examples: 44 // 76 //方法五: ssc install mdesc mdesc // Variable | Missing Total Percent Missing // ----------------+----------------------------------------------- // pid | 0 88,830 0.00 // fid18 | 0 88,830 0.00 // age | 51,476 88,830 57.95 // pidhaizi | 42,208 88,830 47.52 // pidhaizia | 42,964 88,830 48.37 // pidhaizib | 85,696 88,830 96.47 // pidhaizic | 88,235 88,830 99.33 // pidhaizid | 88,662 88,830 99.81 // pidhaizie | 88,771 88,830 99.93 // pidhaizif | 88,808 88,830 99.98 // pidhaizig | 88,828 88,830 100.00 // miss | 0 88,830 0.00 // conta | 0 88,830 0.00 // ----------------+-----------------------------------------------