where clause

[BrahmanandaRao]

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;

[Kurt_Bremser · Accepted solution]

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?

Spoiler

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