SAS--TERA

[Ronein]

In your code should use Tera language or sas language?

[LinusH]

All syntax within an EXCUTE or ..FROM CONNECTION TO blocks need to be in RDBMS specific.
Anything outside these blocks should be SAS PROC SQL syntax.

[LinusH]

I suggest that you read through the documentation for a better understanding:
https://documentation.sas.com/doc/en/lrcon/9.4/n1kbstf7vw0qcjn1ibfc8c78a9lc.htm

[Ronein]

So use DBMS SQL syntax

[Tom]

---

@Ronein wrote:
In your code should use Tera language or sas language?

---

It was already clear which parts are using SAS syntax and which parts are using Teradata syntax.

libname tera teradata server=dwprod schema=DWP_vall authdomain=TeraDataAuth;
proc sql;
connect using tera;
execute by tera 
( ... teradata statement here ...
);
create table want as select * from connection to tera
( .. teradata query here ...
);
quit;

The code shown is all SAS code. The parts with the ... elipses ... are where you place the Teradata code.