This post shows you example code of how to select entire By Groups of data in SAS conditional on criteria on single observations.

Browsing Category

This post shows you example code of how to select entire By Groups of data in SAS conditional on criteria on single observations.

This post shows an example of how to decrease CPU – and elapsed time when you subset data sets in SAS using an index. We create a simple index using PROC DATASETS and subset a large data set with a WHERE Statement.

This posts demonstrates how easy it is to track performance of your SAS programs using the LOGPARSE macro provided by SAS Institute. The post also contains an example of how to save the performance statistics in a SAS data set.

A frequent question on SAS Communities is how to replace missing values with the previous non-missing. This post shows you how to do so using the UPDATE Statement.

Control Order of Columns When you work with data in SAS, you sometimes work with a lot of columns or variables. Usually, you have some order in your head as

Beginner Tips, Data Manipulation, Finance, Graph, Linear Modelling, ODS, Regression, SAS/IML, Simulation, Statistics, Time Series,

Have you ever been stuck on a SAS problem and not even Google seems to be of help? Fear not! Help is on the way in the SAS online communities.

In a previous post, I demonstrated how to replace missing values with zero. Now, we generalize things a bit as I show you how to replace them with group means or any group statistic you might like.

This post shows you how to convert a date stored as a character value into a valid SAS date using the INPUT function.

Beginner Tips, Data Manipulation, Finance, Graph, Linear Modelling, ODS, Regression, SAS/IML, Simulation, Statistics, Time Series,

Learning SAS programming, I like to learn new stuff and to learn more about the subjects I am already familiar with. SAS books is a great way to do this. Here are the SAS books on my shelf.

Most users have tried to convert variables SAS. Too few of them does it right though. This post shows you the wrong and the right way to convert from numeric to character.