Hi, I have the following proc sql statement where I will be joining two tables. I would like to see if hash objects would speed up the process. Is there a way to do the following proc sql using hashing. I am having trouble with the "case when" statements when merging the tables. proc sql; drop table new; create table new as select a.case1, a.case2, a.case3, case when a.flag ne "X" then a.code else b.code end as code, case when a.flag ne "X" then a.df else b.df end as df, case when (a.flag = "X" and b.case1 ne "") then "O" else a.flag end as flag from new as a left join old as b on a.case1 = b.case1 and a.case2 = b.case2 ; quit;
... View more