Subhro, Author At 9TO5SAS

7 Proc SQL Automatic Macro Variables for debugging

November 20, 2022

During the execution of each PROC SQL step, macro variables are set up with … Read more

7 PROC SQL Options You Should Use to Debug Queries

November 13, 2022

PROC SQL is a powerful tool, but it can be challenging to debug queries. In this blog post, we’ll discuss some PROC SQL options to help you troubleshoot your queries.

How To Use The SAS Proc SQL Order By Statement?

November 6, 2022

Sorting is an important process when working with data. It allows you to organize the data in a way that makes it easier to work with and understand. There are a number of ways to sort data, but one of the most popular methods is SAS Proc SQL Order By.

How to use Truncated String Comparison Operators In Proc SQL?

October 31, 2022

The dataset can use the Truncated String Comparison Operators (such as =:, >:, and <=:) for truncated string comparisons. However, you find that the Colon operator is not available in PROC SQL. In Proc SQL, you can use the Truncated String Operators such as EQT, GTT, LTT, GET, LET and NET.

K-Means Clustering in SAS: an easy step-by-step guide

October 27, 2022

Cluster analysis is a type of multivariate data mining that groups items (like products, respondents, or other entities) based on characteristics or attributes chosen by the user.
It is the first and most crucial step in data mining. It is a common way to look at statistical data and is used in many different areas, such as data compression, machine learning, pattern recognition, and finding information.