Options sastrace=',d' sastraceloc=saslog nostsuffix msglevel=i
#IPTRACE COUNTRY REGION 202.153.39.52 CODE#
But where does this join process occur? In SAS, after having downloaded all of the tables from Redshift to SAS, or in Redshift? If you set the right option prior to running your code, you can get some useful information in the SAS log about how your SAS code is transformed into database code: In this code, the user wants to join multiple tables from Redshift and store the result in a SAS table. Libname myrs redshift server=""įrom myrs.part p, myrs.supplier s, myrs.customer c, myrs.dwdate d, myrs.lineorder lo For example, consider the following SQL code against Redshift data: If you don’t specify any options, SAS tries to push the processing to the database as much as it can. A lot of SAS users use the SQL language to work with SAS and third-party data, through the SAS SQL procedure. Implicit pass-through improves query response time and enhances security. Implicit pass-through is the process of translating SAS code into equivalent data source-specific SQL code so that it can be passed directly to the data source for processing. This topic focuses on efficiently processing Redshift data in place, minimizing data movement between SAS and Redshift. But you might want to know about the SAS® In-Database features that enable SAS users to transparently work with Redshift data without moving the data.
#IPTRACE COUNTRY REGION 202.153.39.52 FULL#
You can certainly move the data from Redshift down to SAS and use the full stack of SAS capabilities. When you have data residing in Redshift, you probably want to analyze it or manipulate it in different ways in order to build customized data sets that are required by your analytics processes.
After loading Redshift data in CAS, saving CAS data in Redshift and processing Redshift data in place from CAS, let’s terminate this series by exploring the capabilities SAS offers when you are using SAS 9.4 or the SAS Compute Server in SAS Viya and you want to process Redshift data in place without moving it. In this series, I want to share more general information about the integration between SAS and Redshift.
0 kommentar(er)
