If you are looking for a way to assign data values to macro variables in SAS, a PROC SQL step is one of the easiest and most readable ways to do it. In this article, you will learn how to assign data values to macro variables in a PROC SQL step, making your code more dynamic and self-sufficient…

One of the first ever programming environments I used was a scripting language inbuilt into my Texas Instruments TI-83 calculator, which I needed for my Maths A-level…

Building an application from scratch has often been seen as a daunting task, a web of intricate code, functions, and dependencies traditionally best left to the programmers. These programmers are required to have an in-depth knowledge of their language of choice, as well as the peculiarities of development environments, deployment processes, and then their approach to testing…

When you need to export data from your SAS system JSON proves to be an ideal format, given the superb inbuilt tools in SAS…

The ability to dynamically create code allows you to make incredibly flexible systems for processing data. For example, on a project Butterfly Data has worked on, we built a data quality system which checked the quality of 190+ data types, each of which had different formats.

Fuzzy Matching, also known as Approximate String Matching, is a technique to identify whether two strings are similar but not the same. Some everyday uses of fuzzy matching include: spell check, auto-correct, spam filtering, record linkage, and address matching.

“Computers? Data analytics? Is that what you are really doing now?! You’ve changed!” 

This is what I hear my old climbing partners say and they then continue with, “...but your passion is being outside climbing, experiences, adventures, I don’t understand?”