In DI Studio 4.3, SAS offers a code importer utility that can assist with moving legacy SAS code into an enterprise DI environment. The importer uses PROC SCAPROC to analyze and translate the code into DI Studio components. There is also a neat utility to bring in code comments and
Tag: business intelligence
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
I've written about this topic before, but find that more people are interested in how this works. Hoping to provide more detail below. Let me know if I missed anything! When using the 'GEO' dimension type in SAS OLAP Cubes, users will not see anything new unless the OLAP cube
In SAS 9.2, OLAP Member Level Security became that much easier to implement. From SAS Management Console, an administrator can navigate directly into the OLAP Cube Dimension, add a user, grant explicit 'Read' access and click a button to get a snazzy interface to add read or deny security. The
New in 4.3, Web Report Studio users can directly report on data from OLAP cubes and data tables without the previously required information map. However, by default advanced users can only access OLAP cubes and information maps. Allowing direct access to data tables requires a change to user roles (defined
Dear Web Report Studio Users, Recently, the SAS Web Report Studio (WRS) design team has been re-evaluating the mapping features and functions offered to our customers in WRS. In order to ensure that we are meeting our customer’s mapping needs, we would like to invite you to participate in a
There are times when I'm looking for the right color to highlight an item or otherwise make output beautiful. As a result, I am always struggling to find good colors to use in my output. SAS Support to the rescue. They have created a program that displays the 256 colors
As Chris Hemedinger has written in several of his blog posts, SAS Enterprise Guide 4.3 has many more formatting options. I particularily enjoyed the 'CTRL-i' option to reformat SAS code with indents and carriage returns to make my programs even more readable. The 'CTRL-e' and 'CTRL-SHIFT-e' keyboard shortcuts are also
Integrating Stored Processes into Information Maps can improve process performance as well as provide extra flexibility and complete query generation control. In order to showcase how powerful this combination is, I am presenting this topic during a SAS Talks webinar session this Thursday, December 16th. The scope of the example will
Another Guest Post from Tricia Aanderud, SAS Programmer Extraordinaire! Here's a hint from the SAS Support site that shows you how to see all the installed templates. If you don't have SAS EG, this code allows you to quickly see the different styles. Also - it can serve as a