SAS Learning Post

Data Visualization

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

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

English

Advanced Analytics | Data Visualization

Angela HallOctober 22, 2009 2

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

English

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

English

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

English

Advanced Analytics | Data Visualization

Angela HallOctober 12, 2009 3

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

English

Advanced Analytics | Data Visualization

Angela HallOctober 9, 2009 2

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

English

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

English

Advanced Analytics | Data Visualization

Angela HallOctober 6, 2009 3

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:\SAS\EBIserver\Lev1\AppData\SASBIDashboard4.2) 1. SAS Management Console: The Group "BI Dashboard Administrators" by default is

English

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

English

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

English

Blogs

Blogs

Data Visualization