请问这样的excel算法在stata里如何实现？

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

大于或等于B列且小于等于C列  则返回对应的A列的值到F列
这是一个类似等级税收的表  要从上往下搜索
如果找不到对应 就把F列置为12
关键是从上往下怎么循环

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：EXCEL Stata 如何实现 tata exce excel 如何

not sure which column you want to compare to columns B and C.  If the columns are named as A B C and E in stata, you can do, if compare by observation

gen long F=A*(E<=C & E>=B)+12*(!(E<=C & E>=B))

if you need to do loop, not sure how you want to output since each obs can have more than 1 output.

jjjj6666 发表于 2014-1-30 06:33
not sure which column you want to compare to columns B and C.  If the columns are named as A B C and ...

using column E to compare with B and C. You're a nice guy.

thanks, hope it works.  Happy new year!