Hi, Anybody using SPDS with 9.4 M6 who have had problems with IP=YES? When we run the following simple example proc sql; create table SPDSWORK.out1 as select table2.value length=50 from SPDSWORK.in1 table1, SPDSWORK.in2 table2 where table2.value_id = table1.value_id ; quit; The query that is passed down to SPDS is NOTE: Implicit SQL: select table2.value from IN1 table1, IN2 table2 where table2.value = table1.value_id I.e. the variable table2.value_id is replaced with table2.value in the join condition. It seems like it can not handle variables named value and value_id in the same query. When we run the same example from SAS 9.4 M5 it works as expected.
... View more