Back in November last year I mentioned Metadata-Bound Libraries. This v9.3 M2 (and above) functionality allows you to force access to your data through metadata libraries, thereby enforcing your metadata security plans.
One of the nuggets of informati…
I got as lot of feedback about the DS2 articles I recently wrote. I should add a few more summarising comments:
I mentioned that DS2 doesn’t currently support MERGE. Chris Hemedinger commented that the ability to use SQL in your SET statement means th…
My friend Stuart Pearson alerted me to a distant but fast approaching issue for some SAS sites. Stuart observed a problem at one of his clients as they were working on forecasts for the next ten years and one of their processes was feeding-in 2 digit…
In my previous posts, I’ve covered many aspects of DS2 (previous posts are listed at the bottom of this post). It’s time to wrap up by offering a few more final details.
Whilst DS2 provides a wide range of data types, not all types are supported by all…
In my recent posts on DS2 (DATA step evolved), I showed the basic syntax plus packages & methods, and I showed the use of SQL within a SET statement. In today’s post, I’ll show the biggest raison d’être for DS2 – the ability to run your code in th…
Earlier this week, I suggested taking a look at DS2 (“the DATA step evolved”) as a learning opportunity for the New Year. I listed the advantages that DS2 offers over the traditional DATA step. One of those was the ability to use SQL within a SET state…
There’s never a bad time to learn something new. How about DS2?
In May of last year, upon returning home from SAS Global Forum, I wrote about DS2, a new alternative to DATA step. Generally available in V9.4, PROC DS2 is currently available in SAS…
Sometimes you get into a habit that is so deep-seated that you don’t realise you’re doing it. I was just reminded of a little trick that I regularly use when editing ODS graphics templates.
A colleague of mine was using PROC TEMPLATE and getting the f…