Category Archives: Statistics

SAS Framework Data Server

By | March 7, 2013

Comparing my SAS 9.2 and 9.3 Enterprise Business Intelligence (EBI) environments, a notable difference between daemons started by the sas.servers script was identified.  In 9.2, we had a SAS Table Server daemon.  It was not available in our 9.1.3 EBI installation, and was released in the 9.2 version.  Apparently SAS removed it from the 9.3… Read More »

SAS ODS: {thispage} and {lastpage} and PDF Output

By | February 26, 2013

When developing new reports, we typically give the end users a choice of output formats to choose from.  The SAS Output Delivery System (ODS) provides a versatile framework to transform the results of SAS procedures into consistent, high quality reports in formats that are widely used by information consumers: HTML (HyperText Markup Language), PDF (Portable… Read More »

Locating the Log Files for the SAS 9.3 Middle Tier

By | February 23, 2013

I have been doing some maintenance recently on one of our SAS EBI installations and needed to review the logs generated by the middle tier.  At some point any BI administrator will have to do this, so here are the default locations, directly from SAS: The log files for the SAS 9.3 middle tier are… Read More »

Enterprise Guide 4.1 Die Date

By | October 30, 2010

from The original SAS Enterprise Guide 4.1 expiration date is December 1st  of this year. SAS Enterprise Guide 4.1 customers who have not applied the SAS Enterprise Guide hot fix 41EG09wn or later will be affected. The workaround is to download and apply the latest hot fix: SAS Enterprise Guide die dates and… Read More »

Hot Fix Release A53007 for Enterprise Guide 4.22 Released

By | July 8, 2010

SAS released Hot Fix A53007 for Enterprise Guide 4.22 on June 29, 2010.  This Hot Fix applies to 32-bit and 64-bit versions of Microsoft Windows.  The Hot Fix address two issues, including: Issue 38357 – SAS stored process might fail to run when the language is set to Norwegian Issue 40130 – Errors might occur… Read More »

An Issue Creating a Format in SAS Enterprise Guide 4.2 after Installation of Hot Fix A53005

By | July 6, 2010

I had been using SAS Enterprise Guide 4.22 for months without any crashes, but in May I installed the SAS Hot Fix A53005 primarily because it was available.  After installation of the Hot Fix, whenever I attempted to run the Create Format task, even in a brand new project, I received the following error: SAS… Read More »

Undo an Action in Microsoft Excel with the SAS Add-In for Microsoft Office Installed

By | June 29, 2010

Even though we have Maintenance Release 2 installed on our SAS clients, we will still get undo problems in Excel.  Here is one more step that needs to be performed: The issue described in SAS Note 36601: Cannot undo changes in Microsoft Excel when the SAS® Add-In for Microsoft Office is installed can be fixed… Read More »

Sending SAS Enterprise Guide Data to Microsoft Excel

By | May 1, 2010

A strong point of SAS Enterprise Guide is that it interacts seamlessly with many data types using the Microsoft Jet Engine (Excel .xls, Access .mdb, dBase .dbf, Lotus.wk?, Paradox .db, and text files .txt .csv etc).  To provide even more flexibility, there are also a few different ways in Enterprise Guide to output data to… Read More »

New Features to be Included in SAS Enterprise Guide 4.3

By | April 20, 2010

I was one of the unfortunate ones who was unable to attend the SAS Global Forum in Seattle last week.  Thanks to discussion forums, blogs, and Twitter, I was able to keep up with a lot that was going on.  I was particularly interested in some of the new features that will be available in… Read More »