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
So you have installed the SAS System, and you can check what is licensed with the proc setinit command, but what if something hiccuped in the install. Or your supporting (I mean validating) someone else's install and you need to quickly see what is available? Included below is some 'found'
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.)
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
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
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
