The following words are reserved in PROC SQL: The keyword CASE is always reserved; its use in the CASE expression (an SQL2 feature) precludes its use as a column name. If you have a column named CASE ...

You can use the pass-through facility of PROC SQL to build your own Teradata SQL statements and then pass them to the Teradata server for execution. The PROC SQL CONNECT statement defines the ...

Yes a sproc can return multiple resultsets and you can even work with them in ADO, though it is somewhat esoteric.