How CONNECT TO STATEMENT Work in SAS
CONNECT TO STATEMENT in SAS is used when we want to connect database using explicit SQL pass-through let’s take an example using CONNECT TO STATEMENT to connect Teradata system. PROC SQL ; CONNECT TO TERADATA(USER=<USERID> PASSWORD=”<PASSWORD>” SERVER=<SERVERNAME> DATABASE=<DATABASENAME> CONNECTION=GLOBAL MODE=TERADATA); CREATE TABLE DEMO AS …