proc sql; connect to TERADATA ( SERVER=ABCDE AUTHDOMAIN="ABC12345" ); CREATE TABLE WORK.ABCD_AP_LDC_010_V AS ----<<< CREATES A WORK.TABLE IN SAS select * from connection to TERADATA ( SELECT * FROM TERADATA_SCHEMA.ABCD_AP_LDC_010_V ); execute (commit) by TERADATA; execute ( CREATE VOLATILE TABLE ABCD_AP_LDC_010_V AS ----<<< CREATES A VOLATILE TEMPORARY TABLE IN TERADATA (SELECT TOP 5 AB_ID FROM TERADATA_SCHEMA.ABCD_AP_LDC_010_V) WITH DATA ON COMMIT PRESERVE ROWS ) by TERADATA; execute (commit) by TERADATA; execute(TERADATA_SCHEMA.STORED_PROCESS(PARAMETERS)); -----<<< TO EXECUTE A STORED PROCESS/MACRO disconnect from TERADATA; quit;
... View more