The XLSX libname engine in SAS allows you to read and write Microsoft Excel files in the same way that you can work with other data sets and databases. This article describes the basic (and some limitations) of the XLSX engine.
I've written about how to use the FILENAME ZIP method to read and update ZIP files in your SAS programs. The ZIP method was added in SAS 9.4, and its advantage is that you can accomplish more in SAS without having to launch external utilities such as WinZip, gunzip, or
Somebody once said that relationships are not easy. Well now they are—in SAS 9.4, at least! SAS objects have inherent relationships and dependencies, and a change to one element can often have an impact on one or many related objects. For example, for SAS Visual Analytics reports to work as
Beginning with the first maintenance of SAS 9.4, you have the ability to define your own symbol markers using the SYMBOLCHAR and SYMBOLIMAGE statements. With these statements you can select a Unicode value or you can select an image file that exists on the local file system—making the possibilities for
The ODS ExcelXP tagset has served us well over the years. It provides a reliable method to get formatted SAS output into Microsoft Excel workbooks, where the business world seems to like to live. And it's available in Base SAS, which means that you don't need SAS/ACCESS to PC Files
Today SAS began shipping the second maintenance release of SAS 9.4, colloquially known as "SAS 9.4M2". This is an incremental release, meant to build upon the already-solid SAS 9.4 platform. Even as a SAS insider, I cannot possibly keep track of every new feature that has been added in maintenance.
I'm currently working on a large project for a SAS customer. The project comprises many activities and phases, so there is a need to track progress on many different levels. During a recent meeting the project manager announced, "I'm putting together a status deck, and I'll include some Harvey Balls
When you run a program or task in SAS Enterprise Guide, the application wraps your job in an "ODS sandwich", the colloquial term we use for the ODS statements necessary to create output that can be viewed in your project. That's convenient for exploring and refining your program, but at
SAS administrators have a delicate balance to maintain. SAS users want to be happy and productive, and to be granted the freedom to use any techniques in their skill set to accomplish their work. But the Business (or Government or Research institution) wants their sensitive data to be protected, and
Are you one of the users who upgrades to the latest version of SAS as soon as it comes out? Or are you like some and wait to upgrade until you’re jumping several versions? We’ve talked in previous posts about the benefits of moving to SAS 9.4, so today I’m
SAS administrators now have another tool to keep SAS users from straying off their permitted path: the LOCKDOWN system option. The option was introduced in "stealth mode" for SAS 9.4. In SAS 9.4M1, it became a true, documented option. For the official guide to creating "locked-down servers", see the SAS
SAS Environment Manager 2.1 (which was released with SAS 9.4 M1), has new features to make it easier to manage your SAS environment. For example, it now supports metadata clusters, and it has an improved method for handling access to the application. But the biggest change is in metadata access.
Need to read or update a ZIP file within your SAS program? In SAS 9.4, you can use the FILENAME ZIP access method to do the job. Explanation and examples here!
Recency, Frequency, and Monetary Analysis (or RFM) is a popular customer segmentation technique employed by database marketers everywhere. Marketers use RFM to identify which customers are most likely to respond to a direct marketing campaign. The model takes into account three simple metrics: How recently did the customer buy from
SHA256 and other hash functions are supported in SAS 9.4 and SAS Viya. It's better than MD5 as a cryptographic hash!
Because I began my SAS career in the Publications division, I like to think that I have a keen eye when it comes to SAS documentation. When I first visited the SAS 9.4 online documentation, I immediately noticed that it had a different look. Examine the image below; can you
My children learned this skill early in life: when you want to secure permission for a questionable activity (say, "watch 5 hours of Phineas and Ferb" or "eat a bowl of candy for breakfast"), you should approach the most lenient adult in the household. In my early days of fatherhood,
Microsoft Windows 8 has been with us for a year, and its first major update -- Windows 8.1 -- has just arrived. So how does SAS support these Windows 8 platforms? The answer can be found on support.sas.com in SAS Note 46876. I'll summarize it here: SAS 9.3 and SAS
SAS 9.4 has been out for some time now, and all SAS grid computing enthusiasts know that one of the new features is that SAS Workspace Server processes can be directly launched on the grid. (See The Top Four User-Requested Grid Features Delivered with SAS® Grid Manager 9.4.) What does
Although the NSA and news media have given metadata a bad name in the popular press, the fact remains that information about the nature of your data is extremely valuable. For example, I posted an article yesterday about data cardinality. Cardinality measures the uniqueness of values in a variable. Cardinality
Recently I delivered a SAS Talks session: SAS 9.4: What’s New for SAS® Administrators . We had a large group attend and subsequently had a wonderful flood of questions that we couldn’t always keep up with. So I wanted to follow up with some of the popular questions:
My family are all Lord of the Rings Trilogy fans. As a novice in the world of SAS administration, I find discussing the SAS middle tier architecture a little like traveling through Middle Earth. For me, it’s new and fascinating terrain. And like other travelers, I would find it useful
A couple of years ago I shared a method for copying any file within a SAS program. It was a simple approach, copying the file byte-by-byte from one fileref (SAS file reference) to another. My colleague Bruno Müller, a SAS trainer in Switzerland, has since provided a much more robust
Please register and join SAS Product Manager Amy Peters on September 26 at 1:00 pm ET for a SAS Talks webinar: SAS 9.4: What's New for SAS Administrators. This SAS Talks webinar is laser-focused on enhancements and changes that will interest SAS administrators. Specifically, Amy will highlight how the new
Some handy folks at SAS got together and created a series of videos to help you get started with the SAS 9.4 installation. It starts with the basics that explain what you should do with your Software Order Email. Step two provides videos for creating or moving the software depot.
Over the past few releases, SAS has offered high availability for servers through various failover techniques. So I’ve been wondering how metadata clustering differs and why does SAS 9.4 provide it. The “why” is an easy question to answer. Today’s SAS software is used in a wide array of business-critical applications
SAS 9.4 was released a month ago, and we are excited about all the new features in SG Procedures, GTL and Designer. I wrote an article on SAS 9.4 graph features last month, and promised more to come. What then could be better than this Tech Talk video hosted by our
In SAS 9.4, the SAS programming language continues add new features by the truckload. I've already discussed PROC DELETE (which is actually an old feature, but like an 80s hit song it's now back with a better version). In this SAS Tech Talk video from SAS Global Forum 2013, I
With the release of SAS 9.4 (which included SAS/STAT 12.3 and SAS Enterprise Guide 6.1), you might seriously consider hiring a Chief Versions Officer (CVO). Fortunately, most of the recent versions of SAS Enterprise Guide work with the different recent versions of SAS, so you have some flexibility as you
Previously I've described how you can use SAS Enterprise Guide to send an e-mail message using Gmail as your e-mail provider. In the article, I mentioned that you can also write SAS programs that send e-mail messages, but at the time you could not reach Gmail using the FILENAME EMAIL
