SPDS IP=YES from SAS 9.4 M6 (or later)

[jansson02]

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.

[LinusH]

I think this could be directed to SAS tech support.

If so, please return with the outcome!