specifies data source options. Aliases: options, dataSource For more information about specifying the dataSourceOptions parameter, see the common dataSourceOptions parameter (Appendix A: Common Parameters).
This example shows how to join three external tables using the fedSql.execDirect action. It combines a Base SAS dataset named Customers, an SPD Engine dataset named Products, and a Teradata table named Sales. The example explains how to assign caslibs to data sources and how to identify tables in...
This SAS script demonstrates the use of the Teradata Parallel Transporter (TPT) option with SAS/ACCESS to bulk load data into a Teradata database, using both PROC APPEND and PROC SQL.
This document provides detailed examples on how to use SAS engines to interact with various external data formats, including CSV, Excel files, databases (Teradata), XML, and JSON, within the SAS Viya 4 and SAS Studio environment.
This example illustrates how to use the CONNECTION TO component of the FROM clause of a FedSQL SELECT statement to select data, allowing explicit pass-through of database-specific SQL queries to an external data source (here simulated by Teradata) via a caslib.
/* 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;