The SAS Dummy

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Chris HemedingerNovember 10, 2010 0

An "Enterprise Guide" in a parallel universe

Dear Readers, You might visit this blog for many reasons, chief among them to learn useful information about SAS. You know that I often post tips about SAS Enterprise Guide, and sometimes people go so far as to call this a "SAS Enterprise Guide" blog*. But for all of the

English

Programming Tips

Chris HemedingerNovember 3, 2010 6

Peek at your data using VBScript, OLE DB, and the SAS local data provider

Let's pretend for a moment that you don't have SAS installed on all of your office computers. But you've got some great content locked away inside SAS data sets. Is there a way to get to the content of that data, without having to push the data through a SAS

English

Programming Tips

Chris HemedingerOctober 27, 2010 5

SAS Enterprise Guide 4.1: it's not dead yet

Are you up to date on your hotfixes for SAS Enterprise Guide 4.1? If you're not certain of the answer, you'll find out next week when you might see this message appear: This version of SAS Enterprise Guide will expire on December 1st, 2010. If you've applied any SAS Enterprise

English

Programming Tips

Chris HemedingerOctober 25, 2010 3

SAS Enterprise Guide 4.3 Tutorials in your language

We've just pushed out the localized versions of the Getting Started with SAS Enterprise Guide 4.3 tutorial. This is the tutorial that you'll see when you select Help->Getting Started Tutorial from within SAS Enterprise Guide. Here is a list of the supported languages, and links to the tutorial content: English

English

Programming Tips

Chris HemedingerOctober 22, 2010 1

PROC REPORT versus TABULATE: two SAS heavyweights

The question came up on the SAS Enterprise Guide discussion forum: which do you prefer, List Report Wizard (PROC REPORT) or Summary Tables (PROC TABULATE)? And as with most SAS-related questions, the proper response is: "it depends." If you put these two PROCs in the ring with a Google Fight,

English

Programming Tips

Chris HemedingerOctober 9, 2010 3

World Statistics, FTW!

Yesterday, I was in the #raganSAS audience as David Pogue told me What's New and What's Next in the world of technology. David is a great presenter, and he really had the audience engaged as he talked about augmented reality, his world according to Twitter, and an iPhone app that

English

Programming Tips

Chris HemedingerOctober 8, 2010 1

Tuning your Windows 2008 environment for SAS

If you're an administrator of systems that run SAS, you have probably already read up on How to Maintain Happy SAS 9 Users. If not, go read that first. Now, are you looking to squeeze the best performance out of SAS on Microsoft Windows 2008 Server? Be sure to read

English

Programming Tips

Chris HemedingerOctober 1, 2010 32

Export to Excel 2007/2010 using SAS Enterprise Guide

Since its 4.2 release, SAS Enterprise Guide has been able to import Microsoft Excel 2007 and 2010 spreadsheet files (usually encountered as .XLSX files). But while SAS Enterprise Guide can export XLS files (which are compatible with all versions of Microsoft Excel), it does not have the ability to export

English

Programming Tips

Chris HemedingerSeptember 29, 2010 1

What to do IN BETWEEN dates

I saw a suggestion arrive from a SAS customer who would like to see the IN operator extended to allow ranges of date values. For example, you can currently write a program that checks for values IN a collection or range of numbers: data check; if x in (1:10) then

English

Programming Tips | SAS Events

Chris HemedingerSeptember 28, 2010 1

Get Smart!

AnnMaria wrote her latest blog post, "SAS Enterprise Guide makes you smarter", partly in response to my recent post about whether it's making you stupider. From the contents of her program example, I'm guessing that she's preparing for WUSS in November. I don't get to attend this year, but my

English

Blogs

Blogs

Programming Tips