Help using Base SAS procedures

proc sql where clause

Reply
Super Contributor
Posts: 326

proc sql where clause

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
Super User
Posts: 10,035

Re: proc sql where clause

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


Ksharp
Ask a Question
Discussion stats
  • 1 reply
  • 134 views
  • 0 likes
  • 2 in conversation