SAS’ Leonid Batkhan explains the data cleansing task of removing unwanted repeated characters in SAS character variables.
Removing repeated characters in SAS strings was published on SAS Users.
Tag: Programming Tips
How to unquote SAS character variable values
SAS’ Leonid Batkhan reviews SAS functionality related to the character strings quoting/unquoting, then dives deep into unquoting SAS character variables.
How to unquote SAS character variable values was published on SAS Users.
Expanding lengths of all character variables in SAS data sets
SAS’ Leonid Batkhan reveals how to change lengths for all character variables in a data set and all data sets in a data library to facilitate data migration to Unicode encoding environment.
Expanding lengths of all character variables in SAS data sets was published on SAS Users.
Adjusting outliers with the 1.5 IQR rule
In my new book, End-to-End Data Science with SAS: A Hands-On Programming Guide, I use the 1.5 IQR rule to adjust multiple variables. This program utilizes a macro that loops through a list of variables to make the necessary adjustments and creates an output data set. One of the most […]
Adjusting outliers with the 1.5 IQR rule was published on SAS Users.
Multi-purpose macro function for getting information about data sets
SAS’ Leonid Batkhan describes programming technique for creating multi-purpose SAS® Macro functions.
Multi-purpose macro function for getting information about data sets was published on SAS Users.
Missing data? Quickly impute values using SAS Viya
This blog is part of a series on SAS Visual Data Mining and Machine Learning (VDMML). If you’re new to SAS VDMML and you want a brief overview of the features available, check out my last blog post! This blog will discuss types of missing data and how to use imputation […]
Missing data? Quickly impute values using SAS Viya was published on SAS Users.
How to retrieve contents of a SAS® Scalable Performance Data Server library
Just when you think you’ve seen it all, life can surprise you in a big way, making you wonder what else you’ve missed. That is what happened when I recently had a chance to work with the SAS® Scalable Performance Data Server, a product that’s been around a while, but […]
How to retrieve contents of a SAS® Scalable Performance Data Server library was published on SAS Users.
Passing comma-delimited values into SAS macros and macro functions
Have you ever tried to pass comma-delimited values to SAS macro or to a SAS macro function? How can SAS distinguish commas separating parameters or arguments from commas separating parts of the values? Passing comma-delimited value as an argument to a SAS macro function Let’s say you want to extract […]
Passing comma-delimited values into SAS macros and macro functions was published on SAS Users.