Variable Table Name in PROC DS2 SET SQL Statement

Yuriy_pbb — Mon, 23 Jan 2023 12:24:59 GMT

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

Re: Variable Table Name in PROC DS2 SET SQL Statement

LinusH — Mon, 23 Jan 2023 12:33:56 GMT

I don't know what you can and cannot do in SET statement for PROC DS2.

But an easy way out is to store the result of your query in a macro variable instead, prior to the PROC DS2 program.

topic Re: Variable Table Name in PROC DS2 SET SQL Statement in SAS Programming

Variable Table Name in PROC DS2 SET SQL Statement

Re: Variable Table Name in PROC DS2 SET SQL Statement