topic Teradata Passthrough Help in SAS Enterprise Guide

Teradata Passthrough Help

new_sas_user_4 — Mon, 10 Mar 2025 15:36:20 GMT

I have access to the EDW database GRP_A (that I am trying to access via SAS)

not sure how can I find the libref for GRP_A....also what would the SERVER, mode=teradata(i guess), DATABASE be?

I do not see the database under the list of Libraries (under Servers under my user)

proc sql;
CONNECT TO TERADATA(USER="new_Sas_user_4" PASSWORD="xxxx" SERVER="???" mode=teradata DATABASE="???");
create table base as select * from connection to teradata(
select BRAND,
PLAN,
count(*) as count
from GRP_A.table_name
where plan in ('ontario')
group by 1,2;
disconnect from teradata;
quit;

Re: Teradata Passthrough Help

Tom — Mon, 10 Mar 2025 16:30:02 GMT

I don't quite follow what your setup is.

But if you have an existing SAS libref named GRP_A that is using the TERADATA engine to connection to a teradata database/schema you should be able to see the schema name in the view SASHELP.VLIBNAM.

You can use this macro to help you get what schema it is using into a macro variable so that you can use that name in your explicit passthru SQL.

https://github.com/sasutils/macros/blob/master/dblibchk.sas

Re: Teradata Passthrough Help

new_sas_user_4 — Tue, 11 Mar 2025 13:50:58 GMT

I was able to use the Teradata Passthough using Teradata sytax within the passthrough code.

The error was because I was using today()-1 (SAS syntax) within the passthrough...when I changed into current_Date-1...it worked 🙂

PROC SQL;
CONNECT TO TERADATA(USER="new_sas_user_4" PASSWORD="xxxx" );
create table base as select * from connection to teradata(
select a,b,c
count(*) as count
from GRP_A.table_name
where current_date-1 between date1 and date2 and prov in ('Ontario')
group by 1,2,3);
disconnect from teradata;
quit;