Category: SAS

NOTE: Enterprise Guide 5.1 – Now Shipping!

If you haven’t already picked-up the news from elsewhere, I should tell you that Enterprise Guide 5.1 (EG 5.1) started shipping earlier this month. For SAS 9.2 and 9.3 only* at this point in time, EG 5.1 looks like it adds some decent new functionality…

Rails and Recent d3.js Examples

A lot of my free time has been spent running and developing a running log using rails.  I want greater control of monitoring / visualizing each training cycle than the sites out there will let me have (no API’s..).   Thus, I’ll just build my own! This whole thing was spurred by my dabbling in […]

What Can I Do With a Stored Process?

Often I refer to SAS Stored Processes as the workhorse of the SAS BI tools … you can use these little devils everywhere sometimes as Band-Aid, sometimes as the star, and sometimes as a background player. In a past post, I showed you how to use a stored process to add dashboard dials to Web Report Studio and Linking to a Stored Process from Web Report Studio. Add-In for MS Office – View Reports or Data Use the stored process to deliver a report or maybe just a dataset (using Proc Print) to the Add-In for Microsoft Office (AMO). In the past, I set up several stored processes that only contained a PROC PRINT to display a data set. Then I added a prompt for Product, which allowed the user to query product inquiries based on the product of interest. Here’s how you access the stored process from AMO 4.3. This works similarly in prior versions of AMO. Open MS Excel (or Word/PowerPoint). On the SAS ribbon, click the Reports icon. Navigate to the stored processes storage location and click the stored process name. < Optional> This stored process has two prompts: Visitor Type and ODS Style. Your stored process […]

Transcoding Problem: Option (correctencoding=wlatin1)

Have you ever tried to convert the default encoding to Wlatin1 (Windows SAS Session Encoding)?

Let me tell you the story behind writing this post….

Today I was asked to send SAS datasets to one of the client. I transferred the SAS datasets to th…

What is an insight team all about?

How to capture succinctly the uniqueness of an insight team? How to ‘elevator ride’ describe what are the key benefits of having such a team? In my mind, it is first important to make a clear distinction between Business Intelligence (BI) which is …

Celebrate your own free copy of my book "Building Business Intelligence Using SAS"

Well, we can’t really afford to give everyone a free copy of the Building Business Intelligence Using SAS: Content Development Examples. But copies will be presented to two randomly selected participants of today’s AllAnalytics.com eChat! Then you can …

Love Our Readers!

As I have told you all week – Angela and I will be participating in e-chat at AllAnalytics.com today at 2 PM. The agenda is wide open!  It would be great to chat with you – I have certainly appreciated the emails! Here is some of the feedback and photos (click to see larger version) we have received – thanks! Our Readers are the Best! We have really been overwhelmed by the readers of the blogs who have reached out to say they could not wait to get the book.  One person gave his son a copy so he could get started early! Join E-Chat Today … Discussing SAS BI Tools, Book Publishing …  Do you have a burning question about the SAS BI toolset? Maybe you are considering a purchase and you want some advise? Maybe you are just getting started and have an issue that is stumping you?  It’s going to be a fun e-chat!  I know the readers are active and curious – certainly keep us on our toes! SAS Press guided the process and worked with us every step of the way. If you are curious about the steps involved in the process, then ask some questions! […]

Test A-IRB approach for credit rating

Basel II or Basel III framework would allow qualified financial institutions to apply their own rating systems for credit risks, such as advanced internal ratings-based approach (A-IRB). The equations of required capital play a big role…