Within the SAS DATA step, the LAG function is provided to return a variable’s value from a previous data set observation. With certain data criteria, sometimes there is a need to look ahead at the next observation and you would expect to use a LEAD function, but this does not
Recent updates to SAS 9.4 have introduced some nice improvements in support of automated migration using the SAS Migration Utility and SAS Deployment Wizard. SAS has been working hard to make the migration experience more user friendly and less error prone. Changes have focused on making errors easier to identify
Hadoop has been called a game changer technology. Here’s why: - DATA IS DIFFERENT: We now have to deal with both structured and unstructured data. - NO LIMITS: We now deal with Terabyte or Petabyte data size and not just with old Megabyte. - COMPLEXITY: We work with complex multi-server
Recently my wife and I took our annual anniversary trip – this time we went to the Grand Canyon, staying in Las Vegas. In researching our options to fly from Raleigh-Durham (RDU) to Las Vegas (LAS), we had several different selection criteria: what time we wanted to leave what time
➤ DISCLOSURE! In June 2018 Google introduced changes to the way it handles its Maps platform. They now require API key in order to embed a map, plus Google Maps "projects" must now be associated with a billing account. Unless these new Google rules are met, Google maps described in
If you have your SAS Certified Platform Administrator Credential, then it’s clear that you’ve studied a lot to achieve it. But suddenly the Hadoop era shows up and what you find are big gaps in your skills inventory. SAS administrators must be familiar with all the data SAS platform can
An important goal of SAS Environment Manager is to communicate with existing software systems. This capability includes not only monitoring other non-SAS platform resources, but also means having the ability to respond to events from outside the SAS platform. We’ve seen how SAS Environment Manager can generate an event for external consumption (see Scott McCauley’s
SAS Cares. That’s how we want you to feel once you become a SAS customer. How do we do that? By bringing all of the support resources together with one goal in mind – helping you become a better SAS user. The SAS Cares experience involves everything from searching on
I’ve had the good fortune to support the Pharmaceutical Industry SAS Users Group as their SAS liaison for the majority of their conferences since 1996. That’s meant a lot to me personally and professionally over the years. I’ve developed some genuine friendships with the dedicated volunteer leaders who organize the
SAS offers a rich collection of features for working with Hadoop quickly and efficiently. This post will provide a brief run-through of the various technologies used by SAS to get to data in Hadoop and what’s needed to get the job done. Working with text files Base SAS software has the
