Hi @TeraGrapher
I think the use of explicit pass-through is messing up the code. TPT functionality must be invoked by SAS. This code is going to have problems, but it should give you an idea.
LIBNAME MyTd Teradata TDPID=QA1 AUTHDOMAIN=TeradataAuth FastExport=Yes DBSliceParm=(THREADED_APPS,2) Mode=Teradata Database=QA1_PL_SAS_VIEWS LogDb=SB_PRICING;
PROC SQL;
CONNECT USING MyTd as MyTd_1;
CREATE TABLE work.term AS
SELECT PolicyNo,
QuoteNo,
NumTerm,
GwTermNo,
ModelNo,
curmodel,
MIN(CAST(PeriodStartDate AS date)) AS date_inc,
MAX(CAST(PeriodEndDate AS date)) AS date_exp
FROM mytd.policy
WHERE numterm IS NOT NULL
AND ModelNo IS NOT NULL
GROUP BY PolicyNo, QuoteNo, NumTerm, GWTermNo, ModelNo, curmodel
ORDER BY PolicyNo, NumTerm, GwTermNo, ModelNo;
QUIT;
There is an old'ish paper, which needs to be updated, that may help you with this. It shows many examples of TPT. https://support.sas.com/resources/papers/proceedings11/142-2011.pdf
... View more
