Our Blogs
Category
- AWS
- Advice
- Agile
- Apple
- Applications
- Armed Forces
- Artificial Intelligence
- Automation
- Azure
- B Corp
- Basketball
- Book Club
- Butterfly Academy
- Butterfly Data
- CASLIB
- Case Study
- Christmas
- Climbing
- Cloud
- Coding
- Communication
- Company News
- Cricket
- Cyber Security
- Dashboarding
- Data Acquisition
- Data Analytics
- Data Anonymisation
- Data Integration
- Data Management
- Data Science
- Data Strategy
- Data Visualisation
- Deprecation
- Development
- Encoding
- Environment
- Exhibition
- Financial Services
- Fitness
- Food
- Forecasting
- Fraud
- Fuzzy Matching
- Git
- Government
- Graphs
- Healthcare
- IBM
Tags
- Agile
- Armed Forces
- Azure
- Butterfly Data
- Cloud
- Company News
- Data Analysis
- Data Analytics
- Data Engineering
- Data Integration
- Data Management
- Data Migration
- Data Privacy
- Data Quality
- Data Science
- Data Transformation
- Data Visualisation
- Finance
- Fraud
- Git
- Government
- Healthcare
- Insurance
- Open Source
- Policing
- Programming
- Python
- R
- Retail
- SAS
- SAS Viya
- homeworking
SAS Made Simple: How to prevent rounding errors when using SAS’s Proc SQL
Join us as we look at how to prevent rounding errors when using SAS’s Proc SQL; leveraging the default formatting of the SELECT INTO statement. I recently encountered some peculiar behaviour when using the “select into” function in SAS’s proc SQL. It was rounding very large numeric values in macro variables to the nearest 5 significant figures…
SAS Fans 2024 - Understanding Analogies in Data - Part 2
Analogies can be overused and can be used in many difference situations, and this can be distracting.
As an example, using the Recipe analogy is a good way for describing different concepts and ideas…
SAS Fans 2024 - Understanding Analogies in Data - Part 1
As our very own Henry Newman-Burke looks to present at SAS Fans on Wednesday, 27th November, he will be sharing his take on ‘What if Santa was moving house?’ A presentation which shares the festive view of analogies used…
SAS Made Simple: ANYCNTRL & NOTCNTRL Regex Alternatives for SAS
A control character is a character that does not represent a traditional printable character but is intended to act as a particular action...
SAS Made Simple: Using CAS’ Multi-Node Processing to Improve Data Loading
When working with data in SAS Viya you have most likely accessed it via a Caslib. In order to analyse this data, you need to load it into CAS memory. So this is going to be a short guide into how best to achieve this…
SAS Made Simple: Into the Multiv(iya)erse - Understanding Scope and Loading Tables in SAS Viya
SAS Viya is a comprehensive data analytics platform, which is particularly useful due to the speed improvements, compared to older versions of SAS, offered by the parallel processing of the SAS Cloud Analytics Service (CAS) within SAS Viya…
SAS Viya Tips: Finding and Utilising the Number of Rows in a CAS Table Through Macros
This article might be somewhat more specific than a few of our broader discussions here. However, SAS Viya is a reasonably new tool…
How to Import JSON into SAS without the LIBNAME Statement
For users running SAS 9.4 maintenance release 4 or later, the LIBNAME JSON engine is a great feature that allows JSON data to be read into SAS with only a few lines of code. For those without access to the JSON engine…
Using SAS SQL to Create Data-Driven Macro Variables
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…
Discovering All Available Data in a SAS Viya CASLIB
SAS Viya is a cloud-native platform which is able to host many of SAS’s other services such as SAS Visual Analytics or SAS Studio. One of the strengths of SAS Viya is the Cloud Analytics Services (CAS) in-memory engine…