BookmarkSubscribeRSS Feed
ani
Calcite | Level 5 ani
Calcite | Level 5

I want to connect teradata from PC SAS 9.2. I have tried the the following two methods:

1)libname tst TERADATA server=XXX user=XXX password=XXX;

ERROR: The TERADATA engine cannot be found.

ERROR: Error in the LIBNAME statement.

2) proc sql;

CONNECT TO TERADATA AS TERA

(Server = XXX Schema = XXX user = xxx pwd = xxx mode=teradata);

quit;

ERROR: The TERADATA engine cannot be found.

ERROR: A Connection to the TERADATA DBMS is not currently supported, or is not installed at

To connect teradata is there any other step I have to ensure before writing these code?

Thanks in advance Smiley Happy

4 REPLIES 4
art297
Opal | Level 21

Does your site license SAS Access for Teradata?

FriedEgg
SAS Employee

post the outout of proc setinit; run;

LinusH
Tourmaline | Level 20

As the message implies, are you sure that SAS/ACCESS to Teradata is installed?

Later on, you need the Teradata client, which more or less their ODBC driver.

/Linus

Data never sleeps
robby_beum
Quartz | Level 8

If after doing a PROC SETINIT you have SAS/ACCESS to Teradata installed - I used to connect to teradata this way where UPPERCASE are required and lowercase are my names.

LIBNAME tst TERADATA TDPID="10.2.123.456" USER=myuserid PASSWORD=mypassword SCHEMA=dbschema;

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 4998 views
  • 0 likes
  • 5 in conversation