WHERE 语句的使用

       

DATA MYCLASS;
	SET SASHELP.CLASS;
	WHERE SUBSTR(NAME,1,2)='罗' AND (AGE=11 OR AGE=12);
RUN;

PROC PRINT;
RUN;

 

DATA test;
	SET sashelp.class;
	/*或 name ? 'a' */
	WHERE name contains '斯'; 
RUN;

PROC PRINT;RUN;

 

DATA test;
SET sashelp.class;
/* 也可以简写为12<Age<16 */
WHERE Age>12 and Age<16;
RUN;

PROC PRINT;RUN;