you are creating SAS work table and trying to use that in explicit SQL pass through query(via connect statement). Once to connect statement to Teradata, you cannot use SAS work table. For your query, you can use Teradata volatile table, all users can create Teradata volatile table and use the same query. below link shows how to create volatile table and use them.
http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a002677096.htm.
or you can do everything in SAS by using teradata libname statement.
libname teralib teradata server=myserver user=myuserid pwd=mypass;
;
proc sql;
create teralib.yourotherteradatatable as
select id, col from teralib.yourteradatatable
where id in(select id from sastable);
... View more