Category Archives: Business Intelligence

Reconfigure the SAS Environment Manager Agent to Point to a Different Host

By | May 20, 2017

In the configuration phase of a SAS Enterprise Business Intelligence (EBI) Platform deployment, the Deployment Wizard prompts the installer for the host name of the Environment Manager Server. This value is used by the Environment Manager Agent as the recipient of all of the data that it collects. The Environment Manager Server resides on the… Read More »

Redirect Web Traffic from HTTP to HTTPS after Reconfiguring the SAS Middle Tier for TLS

By | April 28, 2017

We had a new project which required the manual configuration of the SAS middle tier to utilize TLS (Transport Layer Security , a successor protocol to SSL). These environments were SAS Enterprise Business Intelligence Server 9.4M4 deployments. With each new maintenance release, SAS has simplified the automatic and manual configuration of encryption services. SAS Documentation… Read More »

SAS Environment Manager Server Does Not Start on AIX

By | September 9, 2016

I began installing SAS Enterprise Business Intelligence (EBI) 9.4 Maintenance Release 3 software on AIX 7.1 LPARs this summer. These were development environments which were single-machine deployments. The installation and configuration phases were straightforward, and when completed, the deployment was up and running and validated perfectly. I then shut down all of the SAS services… Read More »

Make the SAS Add-In for Microsoft Office Available in Office 2016

By | February 6, 2016

I recently wiped the disk on my primary PC and installed fresh copies of Microsoft Windows 10 Professional, Microsoft Office 2016, and the SAS Add-In for Microsoft Office 7.11 (using the standalone installer). I then fired up Microsoft Excel and noticed that the SAS menu item was not available: The missing menu didn’t alarm me … Read More »

Errors When Using Page X of Y in SAS ODS pdf Statements

By | March 13, 2015

I ran across a familiar error this week, so I figured I might as well finally document it on this blog. My organization primarily uses Lexmark printers, and print drivers are included in the standard PC image. Apparently the drivers installed on the standard image are not considered “valid printer drivers” by SAS, because we… Read More »

Fix for a [SanitizingRequestFilter] error in the SAS Information Delivery Portal

By | September 24, 2014

I recently deployed the SAS Enterprise Business Intelligence Server on a brand-new AIX LPAR.  During my validation of the platform, I created a new stored process portlet and added it to my home page.  My test portlet then displayed the following error: Error 500: javax.servlet.ServletException: Filter [SanitizingRequestFilter]: could not be initialized. Here’s how it looked in… Read More »

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 »