Many SAS programmers use macros. I have seen students in my SAS classes use several methods to activate their macros. One way is to load the macro in the Display manager or editor in SAS OnDemand for Academics and submit it. Another technique is to use the statement %Include macro-name. […]
How to use the SAS Auto Call facility was published on SAS Users.
Last year, I wrote a blog demonstrating how to use the %Auto_Outliers macro to automatically identify possible data errors. This blog demonstrates a different approach—one that is useful for variables for which you can identify reasonable ranges of values for each variable. For example, you would not expect resting heart […]
Two macros for detecting data errors was published on SAS Users.
In many programming languages, there is a function named eval() that can be used to evaluate an expression and return the result at run time. For example, in Python, the eval() function parses the expression passed to it and runs a Python expression or code within the program. Even Python […]
How to evaluate SAS expression in DATA Step dynamically was published on SAS Users.
SAS Press author Kim Chantala shows you how to to spend less time preparing data so you can lavish time on analysis.
Creating codebooks with SAS macros was published on SAS Users.
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.
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.
SAS’ Leonid Batkhan differentiates between SAS macro and programming languages, defines two types of SAS macros and much more.
How to create and use SAS macro functions was published on SAS Users.
I needed to extract some SAS identity related metadata today using the Metacoda Identity Sync Utils on GitHub. That repository contains some macros we publish to help our customers and partners when they need to get hold of some identity related metada…