Our Blogs

WE LOVE TO SHARE

So here are our latest blogs sharing what we have learnt lately, we hope it will make your life easier.
SAS Functions Book

SAS Functions Book

Over the years, we've been building up our comic-style SAS function one-page guides, drip-feeding them to you.  Well, guess what?!  We put them all together and made a book so they're all in the one place, to make referencing them easier for you. Thank you...

SAS Utilities: cleanwork

SAS Utilities: cleanwork

When a user starts and runs code in a SAS session, a number of temporary folders and files are created in the SASWork and SASUtil locations.  If that session completed and exits normally these folders and files are removed, however some SAS sessions exit abnormally,...

How To Intnx With SAS

How To Intnx With SAS

We like making life a little bit easier here at OptimalBI and one of the ways we have found to do that is by making quick how to guides. The standard text bullet point style guides isn’t what we do, we do cool sh!t. Below is a guide we have on the SAS function INTNX....

SUNZ – National Conference 2019 – Data and Beyond

SUNZ – National Conference 2019 – Data and Beyond

  The Planets and stars aligned; While visiting family near Wellington and our monthly team meeting was on the same week, I was fortunate enough to be able to attend the SUNZ National conference held at the Michael Fowler Centre in Wellington. For this short post...

SUNZ National Conference 2017 – Open Minds

SUNZ National Conference 2017 – Open Minds

Once again, I have been fortunate enough to be able to attend a SUNZ conference, this time the national conference titled ‘Open Minds’ held at the famous Michael Fowler Centre in Wellington. This is my take on the day, however, unfortunately, my phone had died the...

Faster, faster, faster

As a SAS Admin I like things to be ordered and efficient. This includes the SAS code that you write, that then runs on my server.   I have learnt a number of performance tricks over the decades and am happy to admit that I am not too old to learn some more.  So...

SAS Admin The Basics – Part 3

SAS Admin The Basics – Part 3

Hi, all you new and budding SAS administrators.   I hope you have read my other two blogs in this series, SAS Admin The Basics - Part 1 and Part 2 where I discussed creating a daily checklist and the need to have a Monthly Health Check.  Now in SAS Admin The...