sas sql 如何按照某规则创建table

最近在处理数据需要用sql从数据集中按某规则筛选数据，遇到的问题如下：
我有20个规则（筛选条件），但有的数据集只能满足其中几个，sql会在这时报错停止，但对每个数据集来定规则太费时间，想请教不知道有没有办法在满足某规则时执行，而不满足则跳过该规则，继续下个规则呢？

code如下，

1. proc sql noprint;
   
2. create table total_lu50 as select 行标签 as id,'30304'n as PORT , '50101'n as IND1,'50102'n as IND2,'50201'n as HDRES,'50203'n as LDRES1,'50204'n as LDRES2,'70102'n as URB1,'70201'n as URB2,'90801'n as TB from LU;
   
3. run;

复制代码

感谢帮忙！

use COALESCE() Function.

create table total_lu50 as select COALESCE(行标签, ' ') as id, COALESCE('30304'n, ' ') as PORT , COALESCE('50101'n, ' ')as IND1,....

Hope this helps.

lira12 发表于 2018-3-28 03:01
use COALESCE() Function.

create table total_lu50 as select COALESCE(行标签, ' ') as id, COALESCE ...

感谢您的回复，但在按您的建议修改code后若某规则在某数据集中没有的话，还是会出错停止运行