BookmarkSubscribeRSS Feed
Anil1401
Calcite | Level 5

Hi All,

When I execute the Linear Regression on a dataset of Teradata Library I am getting following Error Message.

ERROR: None of the following SAS-supplied 3 UDFs that are used by the procedure have been published:

       'SAS_LITTLEENDIAN','SAS_TACORR', 'SAS_TOVB'.

NOTE: Cannot use SQL for in-database computation for the data set DATA=AMI_CMB.KTV_trans.DATA for the following reason:

      3 of the following SAS UDF(s) are required but not found in SYSLIB or the current database: 'SAS_LITTLEENDIAN','SAS_TACORR',

      'SAS_TOVB'.

ERROR: The script file for FastExport could not be written out to the local filesystem.

Note: When I run Linear Regression on general dataset sas library i.e like sashelp  Class, its working fine.

It seems that something needs to be done with Teradata library, with UDF's

Please Help me in Resolving this Issue.

I am using SAS EG 5.1

Thanks in Advance

2 REPLIES 2
jakarman
Barite | Level 11

Teradata is a grid solution with many amps processes and nodes. It is better to keep the data there in Teradata and run the processes there as of in-database processing options.

You conclusion is correct there is something wrong with those UDf's. Teradata can be connected to Mainframes and Unix/Linux. That is the Endianness - Wikipedia, the free encyclopedia .   As you are getting that message the accelerator is licensed and installed at SAS but not found at Teradata SAS Analytics Accelerator for Teradata.

It could be not installed at all Teradata nodes in the cases you are getting that message intermittent with exact the same code and same data.
Anyway have checked the prereqs are done SAS(R) 9.4 In-Database Products: Administrator's Guide, Fifth Edition (installation at TD) and your sas options are accordinglyc

See Also chapter 9 of: http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/64205/PDF/default/config.pdf

---->-- ja karman --<-----

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1311 views
  • 1 like
  • 3 in conversation