Recent Posts

5 ways to remove Leading Zeros in SAS

5 Techniques for Quickly Removing Leading Zeros in SAS

• Post author:Subhro
• Post published:January 4, 2023
• Post category:SAS PROGRAMS
• Reading time:7 mins read

Continue Reading5 Techniques for Quickly Removing Leading Zeros in SAS

Proc SQL Automatic Macro Variables

Top 7 Tips to Troubleshoot Your Proc SQL Code Like a Pro

• Post author:Subhro
• Post published:November 20, 2022
• Post category:PROC SQL
• Reading time:8 mins read

Continue ReadingTop 7 Tips to Troubleshoot Your Proc SQL Code Like a Pro

proc sql debug queries

7 PROC SQL Options You Should Use to Debug Queries

• Post author:Subhro
• Post published:November 13, 2022
• Post category:PROC SQL
• Reading time:13 mins read

Continue Reading7 PROC SQL Options You Should Use to Debug Queries

How To Use The SAS Proc SQL Order By Statement?

How To Use The SAS Proc SQL Order By Statement?

• Post author:Subhro
• Post published:November 6, 2022
• Post category:PROC SQL/ADVANCED SAS
• Reading time:7 mins read

Continue ReadingHow To Use The SAS Proc SQL Order By Statement?

Truncated String Comparison Operators

Why Should You Use Truncated String Comparison Operators?

• Post author:Subhro
• Post published:October 31, 2022
• Post category:PROC SQL
• Reading time:4 mins read

Continue ReadingWhy Should You Use Truncated String Comparison Operators?

K-Means Clustering in SAS

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

• Post author:Subhro
• Post published:October 27, 2022
• Post category:Data Science
• Reading time:21 mins read

Continue ReadingK-Means Clustering in SAS: an easy step-by-step guide

sql pass through sas

A Comprehensive Guide to the SQL Pass-Through Facility

• Post author:Subhro
• Post published:October 11, 2022
• Post category:PROC SQL
• Reading time:7 mins read

Continue ReadingA Comprehensive Guide to the SQL Pass-Through Facility

SAS Data Views: What They Are & How They Work

Unleash the Power of SAS Data Views

• Post author:Subhro
• Post published:October 9, 2022
• Post category:Advanced SAS Programming
• Reading time:15 mins read

Continue ReadingUnleash the Power of SAS Data Views

Maximizing the Power of SAS Macro Variables: Using Them as Dates

• Post author:Subhro
• Post published:September 18, 2022
• Post category:SAS Macros
• Reading time:7 mins read

Continue ReadingMaximizing the Power of SAS Macro Variables: Using Them as Dates