Blogs

Blogs

Data Visualization

Get the right information, with visual impact, to the people who need it

Advanced Analytics | Data Visualization

Angela HallFebruary 21, 2011 0

Super Important Tip on Upgrading from 4.2 to 4.2 Add-in to MS Office

When upgrading from an existing 4.2 client install of SAS Add-in to MS Office, you are not prompted to enable the Outlook portion of the Add-in. As SAS points out in the KB Post http://support.sas.com/kb/40/272.html, there is a 'Switcher Utility' available in the client install. When running this, I would

Read More

Advanced Analytics | Data Visualization

Angela HallNovember 10, 2009 0

Using Multiple Selection Prompts in SAS Stored Process Code

It is definitely easier to force single selections for prompts used in SAS Stored Processes, however it isn't very usable when the majority of users need to select multiple values. For example, let us say we create a prompt for region (called 'region_prompt') and then use that in the query

Read More

Advanced Analytics | Data Visualization

Angela HallNovember 9, 2009 0

Mapping ESRI Style

The SAS Business Intelligence suite includes the ability to map data via the ESRI Map Service within various web clients (and even Enterprise Guide). Steps: Create an ESRI Map via ArcMap Publish to ArcGIS Server via ArcCatalog Define a New Map Service in SAS Management Console Set a cube dimension as

Read More

Advanced Analytics | Data Visualization

Angela HallNovember 3, 2009 0

Favorite Things about SAS 9.2 Add-in to MS Office

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.

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 27, 2009 0

Analyzing Local Excel Data via SAS Addin to MS Office

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

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 22, 2009 0

Information Map Studio 4.2 - Something to love!

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

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 20, 2009 0

DistinctCount() vs NUNIQUE in OLAP 9.2

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

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 16, 2009 0

SAS 9.2 OLAP Server has some sweet new functionality!

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

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 12, 2009 0

Shared Prompts in SAS BI 9.2 ~ Modifying via EG 4.2

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

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 9, 2009 0

Metadata Backup Utility via SAS 9.2 Management Console

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

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 8, 2009 0

Configuration Manager Plugin for SAS Management Console 9.2

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

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 6, 2009 0

Open up File Level Security for the BI Dashboard Configuration

(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

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 5, 2009 0

Automatic Updates of the SAS Data Libraries (and Tables) Metadata

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

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 2, 2009 0

Migration Utility for EG 4.2 and Add in to MS Office (Part 2 of 2)

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

Read More

Analytics | Data Visualization

Mike NemecekDecember 19, 2008 0

Visualize Whirled Peas?

Saw an interesting Tweet (a post on Twitter) from investor and writer Paul Kedrosky today: "geeks only: five best data visualization projects of the year http://is.gd/cwIk" The link takes you to the FlowingData blog (created by a PhD statistics student in NY), and a post on some amazing examples of

Read More

Advanced Analytics | Data Visualization

Angela HallAugust 1, 2008 0

Free SAS Training Material

Did you know that there is a wealth of SAS Training Material for free? I have this bookmarked for reference material and continued education. Free Tutorials: UPDATED URL (2009Aug03) http://support.sas.com/training/elearn/tutorials/ SAS Papers Online: http://support.sas.com/rnd/papers/ Users Group Proceedings: http://support.sas.com/events/sasglobalforum/previous/online.html

Read More

Advanced Analytics | Data Visualization

Angela HallMarch 10, 2008 0

LSF Users Guide

I’ve never found a great user guide, not to say that one doesn’t exist. You should be able to schedule any type of executable/job like a batch file from using the Platform LSF client tools (packaged with the server tools). You can also use command line executables like bsub and

Read More

Advanced Analytics | Data Visualization

Angela HallMarch 10, 2008 0

Grabbing the Data Creation Date

The data table creation date is sometimes necessary, say in the footnote of your stored process. Included below is a sample to retrieve this date from the file system. /*Open the dataset*/ %let dsid=%sysfunc(open(sashelp.shoes)); data _null_; /*grab the CRDTE function*/ ddate=%sysfunc(attrn(&dsid;,CRDTE )); /*Format in DDMONYY*/ call symput('ddate', put(ddate, dtdate9.)); run;

Read More

Advanced Analytics | Data Visualization

Angela HallAugust 16, 2007 0

METALIB Update

I have emailed this simple code up & down the east coast. My memory isnt as good as it use to be, so I also have a copy nearby to implement when onsite. This updates the metadata within the specified library (and delete tables/info if it no longer exists in

Read More

Advanced Analytics | Data Visualization

Angela HallJuly 5, 2007 0

Creating a Distinct Count Value in SAS Information Map Studio

Cross tabulations in SAS Web Report Studio don't work with just category/qualitative data. A measure is required. So how to count the number of records that exist in the group? Using the SASHELP.SHOES data table, we would like to count the number of subsidaries that exist within a region, or

Read More

Advanced Analytics | Data Visualization

Angela HallOctober 6, 2006 0

So How Do You Know What is Installed?

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'

Read More

Advanced Analytics | Data Visualization

Angela HallAugust 29, 2005 0

Refreshing OLAP Cubes

Even as stated in current SAS OLAP training sessions, refreshing OLAP Cubes doesn't work as documented. Problems arise when specifying special options for formats (like reducing from $300. to less than the maximum $256.) since these are not stored in the saved PROC OLAP code. Also, if you run the

Read More

Previous 1 … 57 58 59