我想列出每个编号在每一天对应的姓名、以及每个编号在每一天对应的人数。
我的数据有起始日期和终止日期,但是我想列出的是每一天的情况。小白一头雾水。
期待各位大神不吝赐教,万分感激!
- * Example generated by -dataex-. To install: ssc install dataex
- clear
- input str11 code str15 manager long(begin end)
- "000001.OF" "许利明" 20150901 20170328
- "000001.OF" "王亚伟" 20011218 20050412
- "000003.OF" "彭海平" 20180912 20200210
- "000003.OF" "江小震" 20140321 20180912
- "000003.OF" "周其源" 20130320 20140430
- "000004.OF" "彭海平" 20180912 20200210
- "000004.OF" "江小震" 20140321 20180912
- "000004.OF" "周其源" 20130320 20140430
- "000005.OF" "刘宁" 20130308 20200210
- "000006.OF" "盛丰衍" 20190319 20200210
- "000007.OF" "刘涛" 20160527 20180807
- "000007.OF" "刘建岩" 20130308 20160527
- "000008.OF" "何如" 20160105 20200210
- "000008.OF" "陈正宪" 20160105 20200210
- "000008.OF" "杨宇" 20130322 20160105
- "000009.OF" "刘朝阳" 20160329 20200210
- "000009.OF" "石大怿" 20130304 20200210
- "000010.OF" "刘朝阳" 20160329 20200210
- "000010.OF" "石大怿" 20130304 20200210
- "000011.OF" "任竞辉" 20140718 20151015
- "000011.OF" "佟巍" 20150227 20170502
- end