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
Author
A few of the SAS AMO users in my facility (including me) have run into problems around SAS's interation with the normal.dot file. SAS Add-in to Microsoft Office uses the normal.dot as a performance improvement mechanism. SAS stores toolbar and menu information into normal.dot to keep from loading every time
Last week was incredible! The amount of activity from training, supporting and related system administration kept me very busy. The next few posts are my backlog of findings & tidbits. My boss was running into a problem with using a SAS Task from the SAS Add-in to Microsoft Office Excel
Enterprise Guide has a wonderful OLAP Viewer if you don't/can't use the web stuff. I went to the SAS Course 'Creating and Exploiting OLAP Using the SAS System' which has in the Course Notes some great steps on using EG for OLAP Viewing. Basically, the 'Tasks by Category' menu has
BISUG September News Article highlights the new SAS BI-ogsource! Providing a high-level summary of what the Blog's purpose and vision are, it also provides more information about the Blog creator Angela Hall and her employer Tekelec. BISUG is a great resource for anyone looking to use SAS BI products with
When developing the business intelligence measures, you have to be entirely cognizant of the behaviors you could promote. For instance, in measuring and setting business objectives for number of defects per line of code, developers could write more lines of code to reduce the calculated result or they could document
I have been attending a quality conference this week & found a gentleman who wrote 20,000 lines of VB code to allow users to generate graphs through an Excel GUI interface. After the presentation on his Visual Basic analytic system, I approached him to obtain the detail of his 8
Two users yesterday claimed that during the SAS Add-In to Microsoft Office (AMO) installation, an error message appeared stating that Microsoft Office Products were still running on their machine. When looking at the task bar AND the Task Manager Applications window, only the Installshield was up. Workaround - choose the
I was presented a business problem today. Seemed simple enough, however the users didn't know how they wanted to present the data. Whether it was by customer, region, order type, product, quarter, and there were four multiple measures available to analyze. I tried to program all of these options into
Well, the drill-through to detail was giving me a nasty error today. Go figure. Turns out the Library must be preassigned in SAS Management Console (SMC). Right click on the Library Name in SMC, choose Properties. On the options tab, click 'Advanced Options'. Then check the box next to 'Library