stata命令汇总_13个Stata数据管理基本命令汇总

         *========================================          *      高级计量经济学及stata应用          *========================================          *        计量经济学服务中心*                            *        参考资料：*        《初级计量经济学及Stata应用：Stata从入门到进阶；》             *        《高级计量经济学及Stata应用：Stata回归分析与应用》                      *----------------------------------------------------- ----------- ----------- -        *---------------------------*->  1、  系统设置问题*---------------------------      sysdir  pwd   personal  personal dir     help sysdir      sysdir set PLUS      "E:\stata\ado\plus"      // 外部    sysdir set PERSONAL  "E:\stata\ado\personal"  // 个人           adopath + "D:\mypaper\my_ado"      // 增加    adopath - "D:\mypaper\my_ado"      // 取消    set obs 200  set memory 40m  set more on  set more off     set matsize 3000       // 设定矩阵的最大维度  set_defaults memory    // 仅恢复 memory 项   set_defaults _all      // 全部恢复  set type double  set memory 50m  set matsize 2000  set scrollbufsize 50000   // 设定屏幕的最大显示行数  set more off,perma*2、打开auto美国1978年汽车行业横截面数据sysuse "auto.dta", clear*3、数据导入和导出cd E:\stata\results  sysuse use auto.dtaexport excel auto, firstrow(variables)import excel auto.xls, firstrow cleardescribe*4、编辑查看数据editdescbrowse*5、数据类型转换destring  字符转数值destring [varlist],[generate (newvarlist)|replace] [options]tostring  数值转字符tostring [varlist],[generate (newvarlist)|replace] [options]*字符转数值encode varname [if] [in] , generate(newvar) [label(name) noextend]*数值转字符decode varname [if] [in] , generate(newvar) [maxlength(#)]use hbp2describe sexencode sex, generate(gender)list sex gender in 1/4list sex gender in 1/4, nolabellabel list genderuse hbp3, cleardescribe femalelabel list sexlbldecode female, generate(sex)describe sexlist female sex in 1/4list female sex in 1/4, nolabel*6、数据标签label data "  "              //表示将该组stata数据起标签为label var y "  "             //表示将变量y起标签为*为观测值加标签Define value labellabel define lblname # "label" [# "label" ...] [, add modify replace nofix]*7、升序降序sort varlist [in] [, stable]*案例sysuse autokeep make mpg weightsort mpghelp gsortgsort [+|-] varname [[+|-] varname ...] [, generate(newvar) mfirst]sysuse auto#in ascending order of price升序gsort pricegsort +price*降序*in descending order of price降序gsort -price*8、数据合并*数据合并merge*1:1合并merge 1:1 varlist using filename [, options]*m:1合并Many-to-one merge on specified key variablesmerge m:1 varlist using filename [, options]*1:m合并One-to-many merge on specified key variablesmerge 1:m varlist using filename [, options]*m:m合并Many-to-many merge on specified key variablesmerge m:m varlist using filename [, options]*9、数据追加append using filename [filename ...] [, options]*10、压缩数据compress [varlist] [, nocoalesce]webuse compxmp2compress*11、拆分数据*删除变量drop varlist*删除观测值drop if exp*删除某一个范围观测值drop in range [if exp]keep varlistkeep if expkeep in range [if exp]*12、重复样本*汇报重复样本duplicates report [varlist] [if] [in]*列出重复样本duplicatesduplicates examples [varlist] [if] [in] [, options]duplicates list [varlist] [if] [in] [, options]*删除重复的样本duplicates drop [if] [in]duplicates drop varlist [if] [in] , force*13、长宽转换*wide to long reshape long stubnames, i(varlist) [options]*long  to widereshape wide stubnames, i(varlist) [options]*14、egen — Extensions to generate        *1、Without the by prefixuse egenxmplegen avg = mean(chol)generate deviation = chol - avg  *2、With the by prefix  use egenxmpl2, clearby dcode, sort: egen medstay = median(los)generate deltalos = los - medstay    *----------------------------------------------------- ----------- ----------- -

◆◆◆◆

精彩回顾

点击上图查看：

《初级计量经济学及Stata应用：Stata从入门到进阶》

点击上图查看：

《高级计量经济学及Stata应用：Stata回归分析与应用》