proc sql where clause

[milts]

Hi,

Is threre a difference in performance between the two usage of where clause below? If yes which is more efficient?

select a.*,b.* from table_a a() left join table_b on..


select a.*,b.* from table_a left join table_b on ...

Thanks!
Milton

[Ksharp]

the first is more efficient. Because it filter the data before the dataset loaded into PDV.


Ksharp