Optimize Data Access within SAS Enterprise Guide

Shows the best way to access data in a DBMS from SAS Enterprise Guide. It's a performance in three movements: using ODBC from Enterprise Guide (bad), using SAS/ACCESS engine with no passthrough (better), using SAS/ACCESS engine with passthrough (best). The props? Three bowls and a pound of M&Ms.

Note: contributor is an employee of SAS, but this video is not official marketing or documentation material from SAS Institute Inc.

Category:

Howto & Style

Tags:

• SAS
• Enterprise
• Guide
• ODBC
• SAS/ACCESS
• data
• access
• M&M

[JohnConran]

nice... making Oracle do the work is good if the query that runs isn't malformed. If SAS EG is being blindly being asked by novice users to perform full table scans every time they execute their project, this is highly undesirable. DBAs love killing sessions with extreme prejudice in this case. What could be better is to use a data warehouse that has already stored the most commonly accessed data instead of accessing data at its generated source.

[Benlyness]

this is the only one i don't get . . but i still like the leaf blower one!