proc sql; create table match1 as select nong1.dx_name, jbfz._col0,jbfz._col1 from nong1,jbfz
case when nong1.dx_name=jbfz._col0 then dx_nong1=jbfz._col1;
quit;
就是想创建一个match1的表,从nong1和jbfz中找出select nong1.dx_name, jbfz._col0,jbfz._col1变量,如果nong1中dx_name 一列的字符和jbfz中_col0完全一致,则把jbfz数据集中的—col1列中的字符赋值到nong1数据集中新建的dx_nong1列中;
为什么一运行CASE总是报错,LOG显示如下:
59 case when nong1.dx_name=jbfz._col0 then dx_nong1=jbfz._col1;
----
22
76
ERROR 22-322: 语法错误,期望下列之一: ;, ',', ANSIMISS, CROSS, EXCEPT, FULL, GROUP, HAVING,
INNER, INTERSECT, JOIN, LEFT, NATURAL, NOMISS, ORDER, OUTER, RIGHT, UNION,
WHERE.
ERROR 76-322: 语法错误,语句将被忽略。
恳请各位高手解答~~~~谢谢了·~~~·在线等~~~~