SAS Users
Providing technical tips and support information, written for and by SAS users.![Unexpected results from missing values with PROC SQL](https://blogs.sas.com/content/sgf/files/2022/07/9781955977890-702x336.jpg)
SAS SQL handles missing values differently than the ANSI standard for SQL. PROC SQL follows the SAS convention for handling missing values: numerical missing values are always interpreted as less or smaller than all nonmissing values. My first blog showed that missing values can be troublemakers in non-grouped descriptive statistics.
![Machine learning models for payment fraud](https://blogs.sas.com/content/sgf/files/2022/10/Model-Processing-702x229.png)
Fraud detection is becoming increasingly more complex. Customers are demanding a frictionless consumer experience. Luckily, SAS' advanced machine learning models can better prevent fraud and protect customers by analyzing behaviors and detecting suspicious patterns in real-time.
![Formatting your Microsoft Excel output using ODS Excel](https://blogs.sas.com/content/sgf/files/2022/02/ProblemSolvers-400x336.jpg)
SAS' Chevell Parker walks you through eight formatting scenarios that can occur when using ODS Excel and how to address them using formatting and formatting values after export.
![Adaptive SAS programming for the Software Development Life Cycle](https://blogs.sas.com/content/sgf/files/2022/10/chameleon-600x336.jpg)
Leonid Batkhan reveals programming technique to build adaptive SAS programs to facilitate transition between various environments for a smoother SDLC.
![Export a Visual Analytics report using REST APIs](https://blogs.sas.com/content/sgf/files/2022/10/sas-visual-analytics-sdk-aquabank-702x336.png)
In my previous blog Programmatically export a Visual Analytics report to PDF - SAS Users, I use the SAS Visual Analytics SDK to export a report to PDF, which is quite simple if we have basic knowledge with JavaScript programming. It works for both the latest version of SAS Viya
![Getting started with Python integration to SAS® Viya® - Part 11 - Rename Columns](https://blogs.sas.com/content/sgf/files/2021/10/Python-Integration-to-SAS-Viya-702x336.jpg)
Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. In previous posts, I discussed how to connect to the CAS server, how to execute CAS actions, and how to summarize columns. Now it's time to focus on how to rename columns in CAS tables. Load and explore data