/* Specify the DBMS engine, for example: ODBC */ %let srctype=odbc; %let cas_session = mysess; %let caslib_alias = datalib; /*Specify connection parameters within a string Edit the below variables with the required DBMS-specific conection options Also, specify such variables within the CONNOP...
/* Specify the DBMS engine, for example: ODBC */ %let srctype=odbc; %let cas_session = mysess; %let caslib_alias = datalib; /*Specify connection parameters within a string Edit the below variables with the required DBMS-specific conection options Also, specify such variables within the CONNOP...
libname mytddata teradata server=mytera user=myid password=mypw; data mytddata.grades; input student $ test1 test2 final; datalines; Fred 66 80 70 Wilma 97 91 98 ; proc datasets library=mytddata; run; quit;
libname target 'library-path'; libname mytddata teradata server=mytera user=myid password=mypw; data target.highgrades / view=target.highgrades; set mytddata.grades; where final gt 80; run; proc...
libname mytddata teradata server=mytera user=myid password=mypw; data mytddata.grades; input student $ test1 test2 final; datalines; Fred 66 80 70 Wilma 97 91 98 ; proc datasets library=mytddata; run; quit;
libname viewlib v9 'library-path'; proc sql; create view viewlib.mygrades as select * from mytddata.grades using libname mytddata teradata server=mytera user=myid pass...
proc sql; connect to teradata as myconn (server=mytera user=myid password=mypw); select * from connection to myconn (select * from grades where final gt 90); disconnect from myconn; quit;
/* Création d'une table CAS temporaire pour simuler la table 'employees' sur Teradata */ /* Dans un environnement réel, la table 'employees' existerait sur Teradata. */ /* Ici, 'TDcaslib' est une caslib logique pointant vers la table casuser.employees. */ data casuser.employees; input Employe...
libname mytddata teradata server=mytera user=myid password=mypw; data mytddata.grades; input student $ test1 test2 final; datalines; Fred 66 80 70 Wilma 97 91 98 ; proc datasets library=mytddata; run; quit;
libname target 'library-path'; libname mytddata teradata server=mytera user=myid password=mypw; data target.highgrades / view=target.highgrades; set mytddata.grades; where final gt 80; run; proc print data=target.highgrades; run; proc datasets library=target; run; quit;