Hi everyone, I'm using SAS EG 9.4 and currently trying out the proc ds2. What I am trying to do is to use the value from a variable as a table name in the set statement and not specifying the table name explicitly. proc ds2; data differences (overwrite=yes); dcl double count_diff; method compareTables(char(255) inBaseTable, char(255) inCompareTable); set {select * from (select * from inBaseTable) as base_data except select * from (select * from inCompareTable) as compare_data}; end; The table names are passed to the method compareTables, when the codes is being compiled and executed the following error message is being thrown. Apparently the variable contatining the table name is not resolved. How can I use a variable instead of table name in the sql set statement? Thanks
... View more