topic where clause in SAS Programming

where clause

BrahmanandaRao — Sat, 29 May 2021 08:27:36 GMT

Hi Guys

Here difference output with Where Clause

proc sql;
select * from sashelp.class
where name like 'Alfred %' ;
quit;

proc sql;
select * from sashelp.class;
where Name ='Alfred';
quit;

Re: where clause

Kurt_Bremser — Sat, 29 May 2021 08:36:01 GMT

Maxim 2: Read the Log.

 74         proc sql;
 75         select * from sashelp.class;
 76         where Name ='Alfred';
 WARNING: This SAS global statement is not supported in PROC SQL. It has been ignored.
 77         quit;

What does it tell you?

The semicolon after SASHELP.CLASS terminates the SELECT, causing WHERE to become a separate statement.