In many data heavy SAS operations it is crucial to reduce I/O operations. I/O is the most common bottleneck in production ETLs. Therefore, you should think about where your data reside. If you have reasonably sized data sets in a library you access frequently, you...
Usually, I prefer the Data Step over PROC SQL in SAS. I know exactly how the program compiles and executes and in what order. However, problems do arise where an SQL solution is simpler and more intuitive. In that case, I have to force myself out of my data step...
Have you ever been in a situation where you know what you want SAS to do, but you can not quite figure out how? I sure have. Luckily, there is help out there and plenty of experienced SAS users who are willing to guide you. That is why I devote this blog post to one...
In the blog posts Convert from Character to Numeric and Convert from Numeric to Character I demonstrate the correct way of converting variable types in SAS by use of the INPUT and PUT Function respectively. A common use of converting a variable from character to...
I like the SAS programming language and I especially like doing statistics in it. Also, I like to gain knowledge and learn about topics not yet familiar to me. One of the best ways to do this is through the many books out there, covering many different topics. My SAS...
Last week in the blog post Convert From Character to numeric in SAS – The Easy and the Right Way, I showed how to convert from character to numeric in SAS. Also I showed examples of how not to do it. In this post, I show you how to convert from numeric to...