Geoff posted a nice article on his blog about how you can read and write Microsoft Excel spreadsheets programmatically from within SAS, without using DDE. I've previously written about how it's difficult to continue using DDE from SAS when you have a distributed environment (SAS on a server machine, Excel
Recoding values is one of the most common data prep tasks that folks need to do before they can analyze and report on data. In SAS, the most elegant way to handle this is by applying a SAS format. A SAS format allows you to "bucket" a bunch of raw
Useful charts can serve to persuade an audience of certain "truths", because they take real data and communicate it in a clear, visual medium. But what happens when you know something to be true, but you have no real data? Should you let the lack of hard data prevent you
The SAS output delivery system (ODS) makes it so easy to create great-looking output that many folks forget that you can make it even better. One step that folks often leave out: applying a custom title for HTML output. I'm not talking about the title text that you see as
Today's featured topic on support.sas.com teaches you how to use SAS to work with multiple languages and character sets in a single SAS session. The ability to switch locales and languages "on the fly" depends on the improved support for Unicode within SAS 9.2. Although it's a less heralded component
Jason posted his thoughts on using a netbook with a thin layer of applications to do the stuff that he needs to do: surf the web and work his inbox. But don't underestimate these little machines. Over on the Dell Mini forum there is a discussion among folks who use
My family and I attended the North Carolina State Fair on Tuesday (weather was beautiful), and noticed two differences from previous years: Everything was more expensive -- getting in, riding the rides, and especially the food. It was easier to get around, because it wasn't so crowded. We didn't have
The SAS support site has a new example of how to create a Top N report using SAS. The Top N report is pervasive in our society. From the Billboard Top 100 to the New York Times Best Sellers list to the Forbes list of the 100 Richest Americans, the
Here at SAS, we eat our own dogfood*. Actually, that's an understatement -- it's better to say that we feast on it. I've been using SAS 9.2 (released earlier this year) and SAS Enterprise Guide 4.2 (not yet released) for many months (years, actually) to accomplish several tasks, including to
At SAS Global Forum last week, a customer approached me with a very specific request. The conversation went something like this: Customer: My client demands a bar chart that uses a bar for one response, and a symbol for other responses, all on the same chart. We know it's possible
Even if you don't use Microsoft Office 2007, you might have noticed more ".xlsx" files floating around lately. Perhaps you've been sent one or two that you can't open. XLSX is one of the new Microsoft Excel 2007 file formats. (Others include XLSB and XLSM.) Like many software applications, SAS
SAS tip-meister Phil Mason shares a veritable cornucopia of tips at the CMG 2007 conference. Check it out, and learn how a healthy diet of flexible DATE formats can keep your Perl expressions regular.
In his blog, Jared details the hoops one must jump through to convince SAS to run system shell commands (such as the X command and SYSTASK) from SAS Enterprise Guide. Here is the explanation: SAS Enterprise Guide is a client application, and SAS runs as a server application. When launched
"Cut him in half and count the number of rings?" Some folks on the discussion forum share a better method to calculate someone's age from SAS Enterprise Guide.
If you deploy the SAS 9 environment on Windows, you may have multiple SAS processes running on a single box (metadata process, OLAP server, multiple workspace servers). Windows Task Manager doesn't provide a great way to distinguish one sas.exe process from another, but Process Explorer does. Process Explorer lets you
A colleague asked me to run a certain SAS program and then try to view the output in SAS Enterprise Guide. The output contained an SQL VIEW, and darn it, the application refused to open it, reporting only that the data "could not be opened." There was nothing wrong with
Let's say you use SAS Report format, the latest tagset supported by ODS. After all, it's the lingua franca of SAS BI applications, since it's also used by SAS Web Report Studio, SAS Add-In for Microsoft Office, and SAS Enterprise Guide. You've discovered how to use the report builder in
In the SAS BI-ogsource, Angela posts some sample SAS code for updating library definitions using the METALIB procedure. SAS Enterprise Guide users can make use of a friendlier interface to do the same job. Now available for download, the Update Library Metadata task plugs right into SAS Enterprise Guide and
