- gen year = substr(endate,1,4)
- gen month = substr(endate,6,2)
- gen day = substr(endate,9,2)
- destring year month day, replace
- gen date = mdy(month,day,year) //将日期转换为数值型
- format date %td
- gen ins_first = substr(institutionname,1,3)
- gen ins_last =substr(institutionname,-3,.)
- drop if strmatch(ins_first,"第") & strmatch(ins_last,"名") //剔除机构名第一个中文字符为“第”且最后一个中文字符为“名”