We’re smarter together. Learn from this collection of community knowledge and add your expertise.

A Waze App for Base SAS: Automatically Routing Around Locked Data Sets, Bottleneck Processes, and Other Traffic Congestion on the Data Superhighway

by Community Manager ‎08-11-2016 03:16 PM - edited ‎08-11-2016 03:18 PM (285 Views)

Enabling Autonomous Decision Making

Thanks to @sasbrah for his paper from SGF 2016 on the LOCKSMART macro and its ability to enable autonomous decision making. Learn how to implement LOCKSMART and its lock performance metrics to create data-driven, fuzzy logic algorithms that preemptively reroute program flow around inaccessible data sets. Using the macro helps to avoid needlessly waiting for a data set to become available or a process to complete. The software actually anticipates the wait time based on historical norms, performs other (independent) functions, and returns to the original process when it becomes available.


Waze and ETL

Creatively, @sasbrah used Waze, the community-based traffic and navigation app, to help explain the concept of extract, transform, load (ETL). ETL infrastructures often represent serialized process flows that can mimic highways, and which can become similarly snarled by locked data sets, slow processes, and other factors that introduce inefficiency. The LOCKITDOWN SAS® macro, introduced at WUSS in 2014, detects and prevents data access collisions that occur when two or more SAS processes or users simultaneously attempt to access the same SAS data set. Moreover, the LOCKANDTRACK macro, introduced at WUSS in 2015, provides real-time tracking of and historical performance metrics for locked data sets through a unified control table, enabling developers to hone processes to optimize efficiency and data throughput. 


Get full details at A Waze App for Base SAS: Automatically Routing around Locked Data Sets, Bottleneck Processes, and Ot....


Your turn
Sign In!

Want to write an article? Sign in with your profile.

Looking for the Ask the Expert series? Find it in its new home: communities.sas.com/askexpert.