The auxiliar table has more than 65534 characters.    ERROR: The length of the value of the macro variable ID_LIST (65540) exceeds the maximum length (65534). The value has been truncated to 65534 characters.   How would it be "dynamic macro"? ... View more

Thanks again!  You can see a simple example below. I am connecting in a Teradata Server, and I want to make a join with a table that is outside of this connection, like a Lib or Work. I just wanna make a filter using auxiliar table in my teradata query. This auxlliar tabela could be temporarily, no problem.   LIBNAME R_PNL '/sasusers/workgroup/PNL'; PROC SQL; CONNECT TO TERADATA(SERVER='xxx' SCHEMA='VWDW' USER="xxxxx" PASSWORD="xxxx" MODE=TERADATA); CREATE TABLE Test AS SELECT * FROM CONNECTION TO TERADATA (Select * FROM VWDW.VDW_TERA AS X INNER JOIN R_PNL.COSTUMERS AS Y ON Y.ID = X.ID ); DISCONNECT FROM TERADATA; QUIT; ... View more

Thanks for your reply! I am using this method to connect Teradata: "PROC SQL; CONNECT TO TERADATA(SERVER='xxxx' SCHEMA='VWDW' USER="xxxx" PASSWORD="xxxx" MODE=TERADATA);"   I want to see some table in my work/lib in SAS and make filters using my own table inside the SAS.   Is it possible? ... View more