Why does this SAS program produce an error? proc means data=sashelp.cars mean median min max; by origin; run; It's because SASHELP.CARS is a SAS data set, and SAS data sets observations are stored and processed sequentially, and a BY group operation requires that the observations are already grouped and sorted

When you connect to a SAS environment with SAS Enterprise Guide, are you a single, consistent person? Or do you have more identities than Chevy Chase in Fletch? When you connect to a SAS environment, you can be many people at once: You are logged into your Windows account on

Check out AnnMaria's blog covering what she's learned by being on the bleeding edge: using SAS 9.2 for Windows x64 on a Win7 virtual machine. Also, her short primer on XPT files makes me want to add some native capability into SAS Enterprise Guide. If your goal is to send

As you use the Query Builder task in SAS Enterprise Guide, you might notice that it refers to tables and computed columns using names that are different than you expect. For example, instead of a table named CANDY_SALES_HISTORY, the Query Builder might show t1. This is called an alias, and

Subtitle: An accounting of accounts which, by all accounts, you should hold accountable. With the introduction of the SAS metadata server for use with SAS Business Intelligence, the role of the SAS administrator became more important. In SAS 9.1.3 a number of new standard "accounts" -- user IDs that serve

Most modern programmer text editors allow you to see multiple views of the document you're working on. The SAS program editor within SAS Enterprise Guide is no exception, although we've done a pretty good job of hiding this feature. Read on and learn how to easily "divide and conquer" your

In a previous posting I showed an example of how you can use the GKPI procedure in SAS 9.2 to create dashboard-quality charts. Here's a more formal sample that you can use, including a custom task that you can use in SAS Enterprise Guide 4.2 to point-and-click your way the

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

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