How do I convert HEXADECIMAL to DECIMAL in SAS? Converting Hexadecimal to Decimal in SAS A Simple Guide Working with different number systems is common in data analysis and sometimes you need to convert hexad 2 min read 07-10-2024 40
Python/Pandas equivalent of SAS Proc Summary procedure Unlocking the Power of Summary Statistics with Python and Pandas A SAS Proc Summary Equivalence Tired of navigating complex SAS Proc Summary commands for data e 2 min read 06-10-2024 62
How to connect Python to a SAS Enterprise Guide (EG) Server Connecting Python to SAS Enterprise Guide Unleashing the Power of Integration SAS Enterprise Guide EG is a powerful tool for data analysis and reporting known f 3 min read 06-10-2024 39
Is there any equivalent of SAS merging in python? Merging Dataframes in Python A Comprehensive Guide In the world of data analysis merging datasets is a fundamental operation SAS users are familiar with the pow 3 min read 04-10-2024 52
Extract alphanumeric sequence SAS/PROC SQL Extracting Alphanumeric Sequences using SAS PROC SQL In data manipulation and analysis extracting specific patterns from a string is a common task One such task 2 min read 25-09-2024 49
Add age group populations together SAS Combining Age Group Populations in SAS A Comprehensive Guide Combining age group populations in SAS can enhance your data analysis and provide valuable insights 2 min read 25-09-2024 37
How to get the number of observations per table for a library without using sashelp.vtable How to Get the Number of Observations per Table for a Library Without Using sashelp vtable When working with SAS data management and exploration often require i 2 min read 24-09-2024 47
Dedup based on the value of a variable Understanding Deduplication Based on Variable Values When dealing with datasets a common challenge is ensuring that the information is unique and free from dupl 2 min read 23-09-2024 45
Can the font used by the SAS Enterprise Guide file explorer be changed (to fixed font width)? I only find options for editor fonts Changing the Font in SAS Enterprise Guide File Explorer A Guide to Fixed Width Fonts When working with SAS Enterprise Guide EG you may find yourself wondering w 2 min read 23-09-2024 64
SAS proc import imports date with dots at random place. How can I solve this problem? Resolving SAS PROC IMPORT Issues with Dates Containing Random Dots When using SAS to import datasets a common issue arises with date fields that contain unexpec 2 min read 23-09-2024 50
Row count in a SAS file using R's haven package or others Counting Rows in a SAS File Using Rs Haven Package When working with SAS files particularly in data analysis and statistical modeling it s essential to understa 2 min read 23-09-2024 45
SAS: How to spot Regex patterns in space separated values and split them into multiple columns SAS How to Spot Regex Patterns in Space Separated Values and Split Them into Multiple Columns When working with data it s common to encounter space separated va 2 min read 22-09-2024 72
Not being able to use macro inside ODS Understanding the Limitations of Using Macros in ODS When working with SAS Statistical Analysis System many users find themselves in a tricky situation when the 3 min read 22-09-2024 46
Wrong Column names on SAS Understanding and Correcting Wrong Column Names in SAS SAS Statistical Analysis System is a powerful tool used for data management analytics and reporting Howev 2 min read 20-09-2024 43
SAS day of week name to char (downame.) Understanding SAS downame Format Converting Day of the Week to Character Representation SAS Statistical Analysis System is a powerful analytics software that al 2 min read 19-09-2024 59
Set a value for repeated records Setting Values for Repeated Records in Databases In data management a common challenge arises when dealing with repeated records When multiple entries share sim 2 min read 17-09-2024 43
Why is textattributes(textattrs) not working in my SAS barchart with segments? Troubleshooting Text Attributes in SAS Bar Charts with Segments If you re working on creating visualizations in SAS you might run into a common issue the textat 2 min read 16-09-2024 48
SAS_Recursive Function to Estimate parameter Understanding SAS Recursive Functions to Estimate Parameters When working with statistical analysis and model fitting it is often necessary to implement recursi 3 min read 16-09-2024 54
Find the second and third highest value per group excluding ties using SAS SQL Finding the Second and Third Highest Values per Group Excluding Ties in SAS SQL When working with data analysis in SAS SQL you may encounter scenarios where you 2 min read 14-09-2024 47
SAS dataset index copy Understanding SAS Dataset Indexes and Efficient Copying When working with large SAS datasets understanding indexes and how to copy them efficiently is crucial f 2 min read 13-09-2024 47
Compare dates between two datasets Comparing Dates Between Two Datasets A Guide to Effective Analysis Imagine you have two datasets containing important information about customer transactions ea 2 min read 13-09-2024 41
Creating macro variables based on data from dataset Dynamically Creating Macro Variables from SAS Datasets A Powerful Technique In SAS programming macro variables are powerful tools that allow you to store and re 2 min read 13-09-2024 74
how to remove a scheduled task in Putty How to Remove Scheduled Tasks in Pu TTY A Step by Step Guide Pu TTY a popular SSH and Telnet client offers a convenient way to manage remote systems While Pu TT 2 min read 13-09-2024 64
Stop SAS execution How to Stop SAS Execution Mid Program A Simple Solution Lets say you re working on a large SAS program and realize you ve made an error in the middle of the cod 2 min read 06-09-2024 71
How to add a sum column with respect to a group by Adding a Sum Column with Group By A Comprehensive Guide Often in data analysis you need to aggregate data by groups and calculate the sum of a specific column w 2 min read 06-09-2024 51