Have you ever played the lottery? Have you ever heard people bragging about all the money they’ve won? Does it make you want to play? … We’ve had an Education Lottery here in North Carolina for over 10 years, but I still didn’t really know much about…
Category: SAS
How to secure your REST API credentials in SAS programs
I’ve used SAS with a bunch of different REST APIs: GitHub, Brightcove, Google Analytics, Lithium, LinkedIn, and more. For most of these I have to send user/password or “secret” application tokens to the web service so that it knows who I am and what data I can retrieve. I do […]
The post How to secure your REST API credentials in SAS programs appeared first on The SAS Dummy.
SAS Enterprise Guide tools for programmers
If you are a SAS programmer, you may wonder why you should read this. After all isn’t SAS Enterprise Guide just for folks who don’t want to be bothered writing SAS code? SAS Enterprise Guide is just point, click, and get results, right? Well there is a…
My 7 Favorite Features in SAS Visual Analytics 8.2 on Viya
In December 2017, SAS Visual Analytics 8.2 was recently released along with some fantastic functionality. Here’s the seven features that I find useful.
1 – Autosave and Auto Recovery
I’ve made the mistake of walking away from a browser se…
Computer says…my job is safe
The purpose of this blog is simply to post this link to an article in The Economist. Click here to read the article “How soon will computers replace The Economist’s science writers?” At this point, I could stop writing because this article falls into the category of No Comment Needed, but that would be too […]
How to list your mapped drives in a SAS program
If you work in a team environment, you might be accustomed to using mapped network drives for source data folders or to publish results. If you’ve recently moved to a SAS server environment, you might not have those mapped drives available. How can you tell? This question was posted on […]
The post How to list your mapped drives in a SAS program appeared first on The SAS Dummy.
Condition execution on row count
Use this code as a template for scenarios when you want to change how a SAS program runs depending on whether a data set is empty or not empty. For example, when a report is empty, you may want to not send an email with what would be a blank report. In other words, the report sends only when it has information.
On the other hand, you may want to send an email when a data set is empty if that means an automated SAS program had an error that requires manual intervention.
In general, it’s good practice in automated SAS programs to check the size of a data sets in case they are empty or otherwise have the wrong number of observations. With one easy tweak, you could check for a specific minimum number of observations that is greater than zero. (This is left as an exercise for the reader.)
For more posts like this, see Heuristic Andrew.
Price of marijuana, across the US
As marijuana has become legal in several states, it’s been a frequent topic of interest in the news. And as with any interesting topic, I like to find useful ways to visually analyze the data. In this case, let’s have a look at the price of marijuana, …