Category: SAS

Building an SQL subquery in SAS Enterprise Guide

Many SAS Enterprise Guide users practically live in the Query Builder. For those who understand their data tables, the Query Builder provides a tremendous amount of flexibility to pull and manipulate data. The Query Builder produces SQL programs behind the scenes, which translates well for database-centric work. Sometimes a complex […]

The complexity for Fibonacci numbers in SAS

Fibonacci numbers has a lot of applications. There have been a lot of interesting researches regarding Fibonacci numbers since 800 years ago. Mathematically they are the numbers from a sequence, which is defined as .

Experiment and Result

Fibona…

Innovation and communication in analytics

Last week I awoke to an email saying that a respected friend and colleague in Belgium had had an injury and was not well enough to give his talks at the Analytics conference in London. “Can you hop a plane out here and cover six talks?” A trip to Londo…

Use doParallel for rolling regression in R

Rolling regression for a large data set costs lots of resources. There are a few strategies to speed up this process. For example, in R, there is a rollapply function in the dynlm package. In SAS, PROC FCMP is one of the…

NOTE: Agile Developments at SAS

Seek and you shall find. Isn’t Google wonderful? I’m a keen proponent of Agile software development practices and processes. I’ve long been curious to know more about the software development processes used within the various teams at SAS. Jason Burke …

What’s the big idea? Big graphs, for bigger data!

Not everyone agrees on a definition of “big data” — but you’ll probably agree that the amount of data available today is a lot bigger than in the past, eh?!? … so let’s just call it “Bigger Data”!  🙂 And you might have noticed that some of your ol…

Going for gold using analytics

How do analytics and Olympic training go together? Olympic gold medalist, Greg Searle, explained how analytics has changed his approach to training in our one-on-one interview.   For more videos from the Analytics 2013 conference, check out our Yo…