BookmarkSubscribeRSS Feed
Prabu
Fluorite | Level 6

1.libname tdsas teradata TDPID=AML_DM user="%SYSGET(user)"  password="%SYSGET(PASSWD)" ;

2.LIBNAME Tdsas teradata server='P2TERDTDBV01:1521' TDPID=AML_DM USER= "%SYSGET(USER)"
   PASSWORD="%SYSGET(PASSWD)";

 

I tried the above approaches to connect Teradata DB to SAS, But I get the following error

ERROR: Teradata connection: MTDP: EM_NOHOST(224): name not in HOSTS file or names database.

my aim is to convert a Teradata table to a SAS dataset.

 

Kindly help me with a solution.

2 REPLIES 2
kiranv_
Rhodochrosite | Level 12

did your libname work, what does your log say. if your log shows no error you can do.

 

data work.sastable;

set Tdsas.teradatatable;

run;

 

 

 

 

kiranv_
Rhodochrosite | Level 12

looks like you are unable to connect. easiest way to fix ask a colleague how they connect to Teradata, even better inform a SAS admin about this and he will be able to help you with this.

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

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
  • 2 replies
  • 1905 views
  • 0 likes
  • 2 in conversation