Exection Teradata Stored procedure from SAS

[Venky22]

Hi All,

Trying to execute the teradata stored procedure in sas.

libname a teradata user =xx pwd =xxxx server=xxxx db=MNO connection=shared;
proc sql;
connect using a;
execute (call MNO.procedure('202010',0);) by a;
quit;

I've followed changes as shown below

ODBC ADministrator --> Configure --> Options --> Session Mode (Selected ANSI)

Getting below error:

Error:Teradata execute:Invlid Session mode for Procedure execution.

Can some help me to resolve this issue.

Thanks & Regards,

VNKY

[LinusH]

Just a hunch, does the procedure "stream" output?

If so, that will probably clash with how SAS EXECUTE blocks works.

[Venky22]

What procedure does is :

It cretes tables with 202010 data and eports to an excel file. After the data is being populated Business Objects will use those tables to generate the report.

Currently  we are manually triggering each procedure(there are around 20 procedures) and create tables. 

[SASKiwi]

There are two modes you can specify with Teradata: ANSI (default) and TERADATA. I suggest you try MODE = TERADATA on your LIBNAME statement: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=acreldb&docsetTarget=n0tf...