请问如何在case when中添加两个条件？

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

/*计算各公司高管任现职务的平均年龄，存放于dup_mean*/
/*方法一*/
proc sql;create table dup_mean as
select *,
mean(case substr(id_zhiwu,3,2) when'30' and index(zhiwu,"副") when 0 then age else . end) as age_sm_ceo
from c1
where stkcd ne .
group by stkcd,year;
quit;


/*方法二*/
proc sql;create table dup_mean as
select *,
mean(case substr(id_zhiwu,3,2) when'30' and index(zhiwu,"副")<0 then age else . end) as age_sm_ceo
from c1
where stkcd ne .
group by stkcd,year;
quit;

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：Case when whe CAS proc sql

1. /* try this */
   
2. proc sql;create table dup_mean as
   
3. select *,
   
4. mean(case when (substr(id_zhiwu,3,2) = '30'  and
   
5.                    index(zhiwu,"副") = 0   ) then age else . end) as age_sm_ceo
   
6. from c1
   
7. where stkcd ne .
   
8. group by stkcd,year;
   
9. quit;

复制代码

试一试：

proc sql;
create table dup_mean as
select *,
mean(case  
when substr(id_zhiwu,3,2)='30' and index(zhiwu,"副")=0 then age
else . end) as age_sm_ceo
from c1
where stkcd ne .
group by stkcd, year;
quit;

yongyitian 发表于 2014-11-30 10:31

感谢您的帮助！

teqel 发表于 2014-11-30 10:32
试一试：

proc sql;

感谢teqel的帮助！

teqel 发表于 2014-11-30 10:32
试一试：

proc sql;

感谢teqel的帮助！