




























Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
SAS best Practices in Dataware house and how to migrate to cloud
Typology: Summaries
1 / 36
This page cannot be seen from the preview
Don't miss anything!
The SAS & Teradata Partnership Overview Teradata is an Authorized Global Reseller of SAS Solutions Partnership began in 2007 to improving analytic performance Focus on joint product collaboration and customer success More than 550+ sales to over 600+ customers already *** Teradata has dedicated R&D teams onsite at SAS *** Regular collaboration on Joint Product Roadmap to ensure seamless product integration
Did You Know what the SAS Team is Working On? ▪ Work at Discover – SAS is using 33% of the CPU, and 21% of I/O ▪ Old process for Scoring was 7 days, New In DB with TD & SAS Scoring Accelerator was 36 minutes ▪ Work at Delta – SAS usage is 30% of the CPU, and 59% of all Queries ▪ Work at Amex - SAS is using 38% of the CPU, and 48.85 % of all Queries ▪ Work at Bell Canada – SAS is using 66% of the CPU, and 77% of all the Queries ▪ Implementing all SAS Viya RISK Applications to run on Teradata Vantage in the Cloud ▪ SAS Credit Scoring ▪ SAS Risk Modeling ▪ SAS Model Risk Management ▪ SAS Risk Engine ▪ Created a new Cloud Migration Program with Accenture & SAS – Rolling out now! ▪ Implementing for all Verticals ▪ More about: Integrating all SAS Risk Applications to run on Viya with Teradata in the Cloud ▪ No Other database vendor has this capability ( No Snowflake, No Redshift, No Synapse, integration!) ▪ A current example of Joint R&D development engagement as a continuous Partnership with SAS for last 15 years! ▪ SAS RISK PRODUCTS COMING IN Q4/Q! ▪ SAS Solution for CECIL ▪ SAS Solution for CCAR ▪ More to come – Financial Crimes Applications next ( Fraud, AML, etc.)
AMEX
4 Ways the SAS & Teradata Integration Drives Customer Value Translating analytic speed, availability and performance into increased corporate revenue Time to Develop Model Value Creation Additional Value Created Current Process Improved Process Reducing Model Development Time
Improved Model Performance
Additional Value Created Per Year Month 2 Month 4 Month 6 Month 8 Month 10 Month 12 $500k $400k $300k $200K $100k $ Improved Models Existing Models Improving Workforce Productivity
Scoring Models to All the Data
Database
SAS & Teradata Partnership Offerings How we can help get started! SAS - Teradata Assessment Workshop (FREE!) SAS Teradata Coding Training Integration Skills Training (IST) Optimization Service Offering Data Lab Presales & Implementation Services SAS - Teradata Roadshow (One on one sessions with customers) Cloud Migration Program with Accenture & SAS Offering
Example of In Database with Proc FREQ
Traditional SQL Pushdown Rows Returned (^) 9,000,000 51 Time to Process (^) 55 seconds 2 seconds
SAS® Session
SAS/Access to Teradata Node Amps Node Amps Node Amps Node Amps Node Amps Node Amps Node Amps Node Amps Node Amps Node Amps Node Amps Node Amps Node Amps Node Amps Node Amps Node Amps
In Database Coding Example Testing In-database Functionality Not Running In Database Example: ( SQLGENERATION=NONE;) will tell the code to NOT run In database.
12 libname tdXXXX teradata server="XXXserver" database=XXXXP user=&user password=&password; 13 17 options sastrace=(,,,ds) sastraceloc=saslog nostsuffix; 20 OPTIONS SQLGENERATION=NONE; 21 PROC FREQ DATA=tdxxxx.xxxxx; 22 TABLES XXXX_XXXX; 23 RUN; Running In Database Example: ( SQLGENRATION=DBMS; ) will tell the code to run In database
12 libname tdXXXX teradata server="XXXserver" database=XXXXP user=&user password=&password; 13 17 options sastrace=(,,,ds) sastraceloc=saslog nostsuffix; 20 OPTIONS SQLGENERATION=DBMS DBIDIRECTEXEC; 21 PROC FREQ DATA=tdxxxx.xxxxx; 22 TABLES XXXX_XXXX; 23 RUN;
In-Database Functionality
Customer Case Study Global Telecom Firm Initial findings:
# Process Name SAS + Oracle SAS + 2 Node Teradata X Faster 1 Horizontalization – Reduction Process 18 hrs 7 mins 32 mins 34 X 2 Horizontalization – 2nd 15 hrs 3 mins 33 mins 27 X 3 Variable Calculation 6 hrs 57 mins 4 mins 104 X 4 Risk Scoring^ 10 hrs 56 mins 11 mins (^) 60 X 5 Data Mart Generation^ 27 hrs 50 mins 1 hour 28 mins 19 X
SAS Viya & Vantage Integration