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.
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;
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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
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!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.