WHERE是否使用不当？

shiyiming

Proc iml;
Use sashelp.class;   
Show datasets;
Show contents;
List all;
list point 5;
list point {2 3 4} var{age height weight} where(sex='M')
where(name=*{"JON","JAN"})
where (name=:"J")
where (name?"AL")
read all var _num_ into x;

提交上述语句后不能正常执行，加入；后也不行，请问是什么原因？谢谢了

shiyiming

Proc iml;
Use sashelp.class;
Show datasets;
Show contents;
List all;
list point 5;
list point {2 3 4} var{age height weight} where(sex='M')
where(name=*{"JON","JAN"})
where (name=:"J")
where (name?"AL") ;
read all var _num_ into x;
run;

shiyiming

楼上的好像什么也没做啊!

我试了一下,不是输不出来,是观察2,3,4一个也不满足你的where条件,

所以不会输出观测!

试试下面的:
Proc iml;
Use sashelp.class;
Show datasets;
Show contents;
List all;
list point 5;
list point {2 3 4} var{age height weight}
where(sex='F')
where(name=*{"JON","JAN"})
where (name=:"J")
where (name?"Al") ;
read all var _num_ into x;
run;
quit;