SAS Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Chris HemedingerMarch 3, 2008 0

Are you a SAS programmer who does not yet use SAS Enterprise Guide? If so, what are you missing? That's the topic of my SAS Presents paper at SAS Global Forum: Find Out What You're Missing: Programming with SAS Enterprise Guide. From the introduction: More and more SAS programmers are

English

Programming Tips

Chris HemedingerJanuary 17, 2008 0

The road to San Antonio

It's only January, and SAS Global Forum 2008 isn't until March, but folks around here have already been preparing for months. For my part, I'm on the hook for two papers: one "invited" (submitted and accepted by the SAS Global Forum committee) and one as a "SAS Presents" (topics that

English

Programming Tips

Chris HemedingerDecember 14, 2007 0

Using SAS Enterprise Guide to read Microsoft Office 2007 files

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

English

Programming Tips

Chris HemedingerOctober 29, 2007 0

SAS 9 Tips O Plenty

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.

English

Programming Tips

Chris HemedingerOctober 5, 2007 0

You are under my command (prompt)

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

English

Programming Tips

Chris HemedingerSeptember 28, 2007 0

How can you calculate someone's age?

"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.

English

Programming Tips

Chris HemedingerSeptember 27, 2007 0

They all look the same to me: SAS.EXEs are everywhere

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

English

Programming Tips

Chris HemedingerSeptember 19, 2007 0

fuente de la juventud (font of youth)

My new favorite typeface for programming is Consolas, a font designed for use with Microsoft Visual Studio 2005. I use it there, but I now also use it for SAS programming. It uses ClearType technology, so the "crisp and clean" benefits kick in only when you have ClearType smoothing enabled.

English

Programming Tips

Chris HemedingerSeptember 14, 2007 0

Will the real column "AGE" please stand up?

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

English

Programming Tips

Chris HemedingerAugust 29, 2007 0

SAS alchemy: turn your SAS Report into PDF gold

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

English

Programming Tips

Chris HemedingerAugust 27, 2007 0

Updating library metadata, the fun and easy way

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

English