Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.
Please note, that the most recent (released October 2009) SAS Maintenance Release for 9.2 requires a manual step in Windows to restart Remote Services the first time after completing the installation. (Figured I missed something bad when we got nasty errors after redeploying our SAS web applications.) "you must restart
Have you seen the new SAS Add-in to MS Office? There are new features worth pointing out & hopefully this will help convince you that now is the time to switch! In SAS Management Console, three built in security roles have been estabilished to accurately assign functionality per user or group.
In the new SAS Enterprise Guide 4.2 Project, I have found that before making modifications to a reopened project, run the process flow once (or through to that particular point) so the necessary work data table is available. Certain tasks, if opened when the work table doesn't currently exist, will create
I was reviewing some functionality capabilities for a project and came across this scenario. We have two prompts that are cascading (one drives the list available in the second) such as city selection to street selection. I could then share the first one, but not the second. Turns out you
What if you would like everyone to be able to run SAS Stored Processes without experiencing the authentication (log-in) screen? 1. You need to change the /SASStoredProcess/Params.config and a web.xml file for SAS 9.1.3. Change the following line _username=$servlet.user.name TO: _username=<Your Shared Account Name> AND THEN ADD the following line:
While working on a SAS OLAP and ESRI project, I was asked about geocoding addresses. Fortunately, Jeff Phillips, one of the SAS presenters at SESUG09 gave a talk about PROC GEOCODE. In SAS 9.2, street addresses can be given x/y coordinates via the geocode procedure using the 5 or 9
With local data highlighted in Microsoft Excel, you can then "Copy to SAS Server" to run SAS analytical tasks. The menu bar ('SAS' -> 'Active Data' -> 'Copy to SAS Server') is also the image below: SAS provides a knowledge base entry at: http://support.sas.com/kb/32/009.html to show how this can be done with a
VP of Platform R&D; at SAS (also known as @hornpolish to SAS Twitterers) presented the Keynote at the SAS SouthEast SAS Users Conference #sesug09 on Sunday Evening, topic = How to Get and Keep SAS Users Happy. The main tint of the presentation was how to keep the computer happy.
(SESUG2009 Paper Preview) As I mentioned so many years ago (check my 2005 post out "The great analogy of SAS BI Products"), SAS offers a wide range of products for various users to get what they need and do what they must do. Due to this, I relate the various
Bulk editing of multiple data elements An example of this is when you have 10 items that are numerical and therefore are set to allow measures, but should be classified as categorical (such as serial numbers and ids), you can select all of these values, now you can in one
For OLAP Cube Developers to gain access to SAS 9.2, two items: 1. Authorizing Access to SAS OLAP Servers from SAS http://support.sas.com/documentation/cdl/en/biasag/61237/HTML/default/a003311504.htm "Users of SAS OLAP Cube Studio need readMetadata and writeMetadata permissions. To read and update the authorizations for SAS OLAP Servers, follow these steps: 1.Open SAS Management Console.
I was struggling with a calculated member that completes a distinctcount of members in a dimension, the performance was simply unacceptable. After attempting several other measures such as count(), processing changes on the source data, etc, I sent out a msg on Twitter asking for advice. Once again, why aren't
Just a quick tip on the shared prompts in SAS Information Map Studio: When attempting to select a previously created prompt in Information Map Studio, SAS will only display shared prompts that can be used for the type of variable you are filtering/prompting. For example, if you have a date value
Included are a few of my favorite things about the new OLAP Server (for SAS 9.2 EBI Installations). Export/Import via SAS spk file The .spk files are packages that contain everything needed to export from Development and import into Production. This is an IDEAL way to reduce dev-test-prod interactions on the
If you are heavy Add-in to MS Office users and are looking to upgrade to SAS 9.2, now is the time! The new maintenance release of SAS provides a much needed fix for Add-in to MS Office. Found that in the last release (TS2M0), Add in users were unable to
Let me just say, I am loving SAS 9.2 and it's functionality for cascading prompts. I created a dynamic list prompt (the icing to that cake by the way) pointing to a sas dataset that has two variables: County and City. In Prompt #1, I created a County Selection pointing
Starting on September 1st, covering every working day, I began a thirty day challenge (twitter #30dchallenge) to accomplish a couple of goals: 1. Continue to increase my skills/knowledge of the new SAS 9.2 System Topics included both versions (SAS 9.1.3 and SAS 9.2), multiple components (SAS Enterprise Guide, SAS Management
After mentioning the requirements in SAS Management Console to create and edit Shared Prompts (https://blogs.sas.com/content/bi/2009/09/24/creating-a-shared-prompt-for-multiple-imaps-and-stps-9-2/), I then came across functionality in SAS Enterprise Guide 4.2. In the 'Server List', there is a small blue circle with a 1-2-3 and when you mouse over you will see 'Prompt Manager'. When adding
A user who is a member of the "SAS Administrators" group and has been granted the role "Management Console: Advanced" can create a Metadata Backup job via SAS 9.2 Management Console. Right Click on 'Backup and Restore' Task under 'Metadata Utilities'. Then select the Backup task created and choose either
Included are several of the key elements of the new Configuration Manager Plugin that I heart. 1. Modifying the Web Connection Information One of the MAIN items I love about the new version is the ability to modify the configuration of the Web Applications WITHOUT redeploying all the war files. You
There are a couple of options with getting SAS Stored Processes to access Metadata Libraries. 1. Pre-Assignment of Libraries or Connecting as a Single (and therefore Shared) SAS User Account The pre-assignment of libraries means that when the Object Spawner is initiated, the libraries are made available to the end
(SAS 9.2) To get the SAS BI Dashboard to work appropriately, the users who have Role level access to modify and create Dashboards MUST also have read/execute/write access to the BIDashboard configuration folder (example of this location: C:SASEBIserverLev1AppDataSASBIDashboard4.2) 1. SAS Management Console: The Group "BI Dashboard Administrators" by default is
The SAS 9.2 XML engine is very very very slick. I created an xml map to generate a dataset from xml generated during a metadata getobjects job to then run call execute statements for a proc metalib update. "Wait, you did what??!@#?&" you ask? Here are my simple steps. This
Would you like to make the Migration Utility easier to use for your users? There is a MappingInformation.xml file which can assist by completing the maps from old to new items (libraries, file references, information map locations, stored processes, etc) on pg 5 of the MigrationWizard.exe. In order to implement
When you open a 4.1 EG Project in 4.2, Enterprise Guide converts the project on it's own. However, if you have had modifications in the SAS 9.2 Metadata (such as with servers (such as moving from SASMain to SASApp), libraries (SASUSER to WORK), information map folders, or stored process file locations how can
We recently ran into a situation where a customer, with metadata and compute servers on Linux and mid-tier on windows, was trying to leverage the out-of-the-box Pluggable Authentication Module (PAM) support of SAS 9.1.3. PAM allows SAS customers to keep their user management simple by granting users on a Linux
A couple of changes to the interface tripped me up this month. Included are some quick notes. 1. My Favorite Feature is the MDX Editor Since I create Stored Process Queries off of OLAP cubes, I start with the MDX Editor. (Writing MDX from scratch is very painful. Trust me.)
There is a Paradigm Shift waiting for SAS Administrators in the new SAS Management Console environment. The new 'Folders' tab ... But honestly, the changes have some STRONG benefits! We just have to change our process for defining and managing the metadata. In prior versions, SAS was a singular list
In SAS Management Console, administrators have the ability to include multiple user authentication models (ie user name/pwd combinations) for a single Metadata user account in the 'Accounts' tab. Administrators would then organize these by the Authentication Domain definition in SAS Management Console. The 'DefaultAuth' is the initial account used (unless
Are you still debating on the move to the SAS 9.2 environment? Still? Here are some things I REALLY like in the new product. Good work SAS! Allows you to pick which Metadata Server to connect to on initiation. This is of EXTREME value to those who used multiple environments for development
