If your SMC or other metadata-based SAS tools seem to take a long time to load up when connecting to the metadata server you may benefit from running a reorg. The %OMABAKUP macro includes a reorg parameter which reduces the amount of fragmentation in how the datasets making up SAS

Waiting on a sas program to complete and troubleshooted the activex graph control errors that you can get when SAS sends you a email with a activex gchart. I went to Outlook and selected Tools -> Options, and changed the Security Zone to Internet (see below).

So you want to add a URL or an email mailto: in that little footnote of your PROC REPORT so people can pester you with more questions? 'Contact Us' But instead of 'Contact Us' the entire string appears: <a href="mailto:bi-weblog@earthlink.net">Contact Us<a/> The Magic?? Add the <div;> </div> tags around the

Ran into some space problems a while back, not like NASA's though. The Work Directory for temporary files just wasn't big enough to handle all the sorting and other processing of the data. Had to do a few things to fix it - and none included buying memory. 1. Review

Attended a DI Studio Overview class today. Just a couple of tidbits for others looking to pick this product up. Using the Propagate tool from the Process Window only propagates items between working tables/processes in the process. Variables that need to be propagated into the target tables need to be

So what do you do when you create metadata that cannot be currently managed via the SAS Management Console? Take for instance the Theme Deployments for the Portal. The standard is alright, but what company wanted their measures all to be printed with the 'SAS Portal' words on the top

Upgrading your EBI SP4 to DI Studio 3.4 creates the capability of packaging up areas of Metadata (such as the tables in a library) into a "spk" file. Allowing you to then import those items into another repository. This is the FIRST time a GUI driven system has been available

According to the installation instructions, you will need to also upgrade the Metadata.If DI Studio is upgraded on a Client machine that also has SAS Management Console(SMC), simply Start SMC, log on as sasadm and Click Tools -> Update Metadata for SAS Data Integration Studio. HOWEVER, most BI Customer don't

From SAS Tech Support ... change the StartServletContainer.bat (located in sasconfigfolder/Lev1/web) setting for variable "CATALINA_OPTS=", make sure that the inserted line has no carriage returns. If you will have 10 or fewer concurrent users and are using a Sun-based JDK whose revision level is 1.4.2 or later, use these settings:

Of course, you will need to stop Tomcat and SAS Services windows before performing these steps. Therefore it’s best to do after hours. ============================================================= FIRST: Running Remotely Deployed Services as a Windows Service SAS 9.1.3 and higher provides the capability to run the remote SAS Services application as a Windows

For BI Installations, a SAS Service Configuration Utility is available to manage your sas services in a window's environment. Go to Start->Programs->SAS->SAS 9.1 Utilities->SAS Service Configuration Utility. You can install, remove, and set options on the Windows Services. (Thanks goes to Bryan for pointing neat utility out.)

SAS Management Console Plug-in BI Manager "The "Stored Process Manager" has been replaced by the "BI Manager" in the SAS Management Console when running SAS 9.1.3 SP4 and later. The "BI Manager" contains all of the functionality (and more) that was present in the "Stored Process Manager." So, the "Stored

Here are a few major points with the new SP4 install: Make sure you are logged in with the SAME user account that initially installed the system. A quick check in the "Start -> Program File -> SAS -> <bi config folder> ->" location can show you. If you haven't

UltraEdit is not the tool of choice for developing Information Delivery Portal (IDP) Custom Portlets. One of my colleagues found this out after spending many hours with .par compile problems. Turns out that UltraEdit was inserting funky characters and hexidecimal code. Of course, SAS is smooth - but it isn't

Are there best practices for SAS programs? How can you make them efficient? Does it really matter if a program takes .3 seconds or .10 seconds to run? Some code that I have seen in the last two days points to the fact that efficiencies in SAS code (or Java

Found this freeware while at a Customer Site this week. In the first couple days of use, this appears to be an excellent mechanism to connect to remove web servers to move files. http://www.smartftp.com/download/

From SAS Portal, after you log in you can click Search on the top right, type in the OLAP Cube name, choose 'Information Map' and click 'Search'. There might be multiple OLAP cubes available - but pay attention to the paths. Those located in the following file structure are preferred.

(Refer back to my post on "Setting up the SASTheme_winter in SAS Portal" to get the initial files loaded in the servlet container.) I have found that by modifying the following stylesheets and HTML files, I can get the new theme banner to meet the web design requirements. themesSASThemes.xml themestheme_namestylesPortal.css

This is the basics to adding another background/color scheme to the Information Delivery Portal preferences. SAS provides a SASTheme_Winter.war file in the {sas root}WebPortal2.0.1 folder. (according to the SAS Web Infrastructure Kit, this is available in Service Pack 2 & beyond). 1. For SASTheme_Winter, copy the .war file to Tomcat's

Alright, I might be a bit impatient. I tried to bring up http://localhost:8080/Portal a bit too soon. After installing SAS Enterprise BI Products, the extraction of those SAS .war files apparently takes more time for Tomcat than I thought. You can watch the progress in Windows Explorer /webapps. Just don't

So I was downloading the SAS EBI product to my laptop this weekend and saw a couple of items that I should point out to everyone. For those die-hard SAS users (like myself), using the SAS Setup Disk in the first section for SAS Foundation seems like the natural choice.

Wanna save your organization a quick buck? Drop SAS Access to PC File Formats if your only using to export in batch mode! Attended a local SAS Users Group Meeting at the SAS Campus a few weeks ago and heard Vince DelGobbo speak on using the MSOffice2K tagset to move

Today, I needed to figure out how to create a simple measure for OLAP and have it available to the users. Fortunately, EG has a great Create New Measure GUI for this! It creates the MDX code on the fly! Okay, bear with me. There are several steps to this,

Here is a code snippet I came up with today to save output with various _odsoptions AND allow the users to choose what type of output they need: RTF, PDF, or HTML. (Note that this will default to PDF if the user doesn't pick anything. Also there is a report

Running SAS Tasks on one column of data in Excel currently generates an error message. Highlight the column - by using CTRL-SHIFT-END - and then run the SAS Task..

Earlier in the year, I attempted to convert to a SAS Stored Process a SAS IntrNet program that used statements such as: data _null_; set datatable; put 'html code here' variable item; run; However, it doesn't work when simply removing the SAS IntrNet headers (such as options, and ods html

Well, I had a few users this week who wanted to access a print out of one record in the database. Fortunetly, they all know the primary key - so the query was really simple. However, to make it extremely easy for users, I didn't want to link to another

Running a stored process (or STP) is a SWEET thing! All of my users are using the limited number I have made available, and I'm sure many new STPs will be written as soon as the users realize how easily they can be created. When first writing an STP for