All Posts
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
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.
How much time should be devoted to preparing for an important challenge? Depends on the challenge, I hear you say. From my experience, it is important to be aware of the challenges to be confronted when completing a significant project. Not under-estimating the real effort required, often depends on fitness
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
I have emailed this simple code up & down the east coast. My memory isnt as good as it use to be, so I also have a copy nearby to implement when onsite. This updates the metadata within the specified library (and delete tables/info if it no longer exists in
Joining SAS in North Carolina as a marketer from New York City has been a real eye opener. Language like OLAP, DI, ERM, DPPM and various other business intelligence buzzwords have been thrown my way in a vernacular I am not completely used to. The cuisine and culture are a
Cross tabulations in SAS Web Report Studio don't work with just category/qualitative data. A measure is required. So how to count the number of records that exist in the group? Using the SASHELP.SHOES data table, we would like to count the number of subsidaries that exist within a region, or
I recently visited New York to attend the PRMIA Frontiers of Technology Forum to hear and discuss the main issues that are impacting the world of risk management. While I was travelling, the airline misplaced my luggage. Reliable information, whether it’s related to finance, risk, marketing, sales – or to
Rhesus monkeys can figure out basic probabilities, according to this study. Now I suppose that given enough monkeys and time, they might even replace your forecasting department. But I wouldn't worry. They haven't even managed to come up with the works of Shakespeare yet.
In the UK there is debate forming about how best to target benefits on the most deserving cases without building a dependency culture. For some time the UK Government has been using 'means tests' to ascertain whether a claimant needs State support, or whether they have independent resources that they