I follow quite a few SAS users who blog. One of my favorites - because she shares my quirky wit and hatred for shopping - is Dr. AnnMaria De Mars, author of AnnMaria's blog. She has a way of telling stories that leaves me in stitches. I was reading about how AnnMaria
In September 2010, I questioned whether you should care about native 64-bit client applications (or the lack thereof). At the time, SAS did not have a 64-bit version of SAS Enterprise Guide or SAS Add-In for Microsoft Office. A skeptical reader might assume that I was just trying to make
Neil Constable is a Principal Education Consultant at SAS in the United Kingdom, where he applies his extensive knowledge of Base SAS, SAS Enterprise Guide, and the SAS business intelligence tools. He's also the author of SAS Programming for Enterprise Guide Users, Second Edition--and this week's featured tip. You can get to know Neil
Do you want your report to look good on the web, or to look good when you print it? Pick one. Before the SAS Report file format, that was the choice that you faced. HTML is perfect for the web browser. It's easy to scroll through tables, to apply an
We call it the "metadata profile", but really it's like a telephone number that connects you to your SAS environment. Just as a telephone number has component parts (country code, area code, exchange), the metadata profile contains information that allow you to "dial in" to your SAS servers. This information
Before there was CNN or FOX News, people used to get their news from SAS. At least, that's how I imagine that people kept themselves informed. What else can explain the existence of the NEWS= system option, which helps SAS admins to surface the must-know information to the SAS community?
On the heels of the release of the popular SAS macro variable viewer from last month, I'm providing another custom task that I hope will prove just as useful. This one is a SAS options viewer, similar in concept to the OPTIONS window in SAS display manager. You can download
On this blog, I've delivered a few tips about using SAS formats to stratify your data values "in place" without having to actually change your data. The most recent example addressed date and datetime variables. My previous examples included simple SAS programs that you can run in SAS display manager
Rick posted a tip today about using abbreviations in the SAS program editor window (often referred to as the "enhanced editor"). Defining abbreviations is a great way to save keystrokes and re-use "templates" of code that you've squirreled away. (One of Rick's readers also picked up on the tip, and
This blog post is a "mashup" of a couple of my previous posts, combining the lessons to create something brand new that I hope you will find useful. First, let's review what we know: SAS Enterprise Guide supports a scriptable object model, which allows you to write scripts or programs
Super authors Susan Slaughter and Lora Delwiche and their bestselling Little SAS Book series have empowered the user community for years. This dynamic duo has uncannily anticipated what SAS users need to know. And they've produced thoughtful and accessible books with remarkable speed. One of their most recent books The Little SAS Book for Enterprise Guide 4.2 provides
At the Western Users of SAS Software (WUSS)conference this morning, I witnessed my first Super Demo, taught by SAS’ own Andy Ravenna covering the major improvements to the latest version of SAS® Enterprise Guide®. The coolest new new features: Mouse over tooltip – gives you help right in the program editor
What is the best way to organize your SAS work in a SAS Enterprise Guide project? There are no project templates or enforced structure, really, but isn't there a best practice? I don't have a single prescription for the best project organization. I believe that it depends on the nature
Chris Hemedinger, author of the SAS Dummy blog, read last week's Innovation Inspiration post and was reminded of a couple of cool things he'd seen SAS users do. He also told me of one of his most recent rock star moments. (In all fairness to Hemedinger, he didn't call his
It turns out that I'm not receiving the maximum potential value from my Netflix streaming service. Perhaps it's because I place too much value on sleep. With my monthly subscription, I am permitted to view Netflix content 24 hours a day, 7 days a week. In my house I have
Filed under "Little changes that you probably didn't notice". When Microsoft introduced Windows 7 to the desktop, one of the many usability features that they added were "Jump Lists". Jump Lists serve as a sort of shortcut to not just open an application, but "jump right in" to a particular
Today, I came across this article that discusses how software users rarely change the settings in the applications that they use. Users assume that the software vendor sets the default values as they are for a reason, and who are they to set them otherwise? I'm a software developer (and
Like millions of other Americans, I recently was asked to make a decision of tremendous importance to my household -- a decision that would affect the welfare of everyone in my family. That decision, of course, was whether to continue to receive Netflix movies by mail, or opt for the
It's been a well-known limitation for a long time. When you connect to a SAS session using SAS Enterprise Guide, shell commands (including X command, SYSTASK, and FILENAME PIPE) are off-limits because the default SAS invocation disables them. It does this by including -NOXCMD as a command-line option. This makes
Registration is now open for the SCSUG 2011 (South Central SAS Users Group) educational forum to be held at the Sheraton Fort Worth Hotel and Spa in Fort Worth, Texas November 6 - 8. Whet your SAS tastebuds with this lineup of speakers: Keynote Address What’s New in SAS® 9.3 Rick Langston
SAS Enterprise Guide sets values for several useful SAS macro variables when it connects to a SAS session, including one macro variable, &_CLIENTPROJECTPATH, that contains the name and path of the current SAS Enterprise Guide project file. (To learn about this and other macro variables that SAS Enterprise Guide assigns,
As I write this, SAS 9.3 has not yet been "shipped", but its release is imminent. I've already heard many questions about how SAS Enterprise Guide works with the new version, so I decided to write this "Frequently-soon-to-be-asked questions" document to help sort it out. What version of SAS Enterprise
SAS Enterprise Guide has about 150 options that you can customize in the Tools->Options window. With each release, the development team adds a few more options that have been asked for by customers, and they rarely decommission any existing options. It's getting quite crowded on some of those options windows!
I hope that the following statement is not too controversial...but here it goes: Microsoft Excel is not a database system. That is, I know that people do use it as a database, but it's not an application that supports the rigor and discipline of managing data in the same way
SAS Enterprise Guide is best known as an interactive interface to SAS, but did you know that you can use it to run batch-style programs as well? SAS Enterprise Guide has always offered an automation object model, which allows you to use scripting languages (such as VBScript or Windows PowerShell)
I believe I would have interviewed AnnMaria De Mars even if you hadn't sent me scads of e-mails and tweets suggesting her as a perfect candidate for the SAS Rock Stars series. I "met" AnnMaria when I started looking for SAS users on Twitter – nearly three years ago while
I met Phil Holland nearly three years ago at my first SAS Global Forum. Actually, he and I met on Twitter before the conference. Phil, as @hollandnumerics, talked with me many times on Twitter about his plans for attending SAS Global Forum. He and I were excited about SAS'; plans
The ODS Graphics Designer allows you to design and build your own statistical graphs in SAS, without having to learn how to program in the new graph template language (GTL). The ODS Graphics Designer is a rich user interface that allows you to design these graphs based upon your own
Millions of Americans will be gathering around the television this Sunday to watch Super Bowl XLV. They'll gather in bars and private homes, prepare billions of calories worth of snacks, and root for their favorite teams. But if you're looking for an alternate form of entertainment, why not watch "New
AUTOEXEC.SAS wasn't enough for you. Yes, it's a sure-fire way to run SAS statements (such as LIBNAME assignments or macro definitions) whenever you start your SAS session, but you found it has limitations when used in configurations with lots of users who connect with SAS Enterprise Guide. Limitations such as:
