Category: SAS

Statistical Notes (3): Confidence Intervals for Binomial Proportion Using SAS

A guy notices a bunch of targets scattered over a barn wall, and in the center of each, in the "bulls-eye," is a bullet hole. "Wow," he says to the farmer, "that’s pretty good shooting. How’d you do it?" "Oh," says the farmer, "it was easy. I painted the targets after I shot the holes." […]

Save time by creating SAS Favorites

In this SAS Add-In for Microsoft Office Tip, instructor Rob McAfee teaches how to create and manage SAS Favorites.  Creating and using SAS Favorites allows you to save time by quickly navigating to the reports and analysis that you use the most. SAS F…

Statistical Notes (2): Equivalence Testing and TOST (Two One-Sided Test)

Programmers Need to Learn Statistics Or I will Kill Them All –Zed A. Shaw In an equivalence testing example against lognormal data,  a TOST (Two One-Sided Test)  option used in SAS TTEST procedure: proc ttest data=auc dist=lognormal tost(0.8, 1.25);    paired TestAUC*RefAUC; run; And the output: Since the 90% (who not 95%? see below) limit of […]

Statistical Notes (1): Geometric Mean and Geometric Mean Ratio

Programmers Need to Learn Statistics Or I will Kill Them All –Zed A. Shaw Just read since SAS 9.2, the TTEST procedure also natively supports Equivalence Test by simply adding a TOST option (Two one-sided tests). In a example, TTEST procedure reports a geometric mean as 0.9412, which is the geometric mean of a ratio, […]

Hobnob with your fellow wizards

The countdown to Analytics 2012 is on! In less than two months, hundreds of analytics professionals will converge on Las Vegas to learn, network and even have some fun. If you haven’t registered, this blog post might give you some incentive to do so…

Defining a custom color palette for BI Dashboard bar charts

Out of the box, the simple bar graph uses the same color for each bar. A frequent request from users is to define a standard color palette for the dashboard indicators so distinct bars are the same color in each indicator or from refresh to refresh. Wi…

BI Dashboard: Tips for Learning to Use the Tool

When you start to learn how to work with the BI Dashboard tool – the blank slate can be the scariest single element you face.  What goes where? How can I make it look better?  Here’s some suggestions I have used. Review Dashboard Sources Use Google Images to find examples of what other designers have created.  When you can see an overview of dashboards as thumbnail images, the better ones are more apparent.  Study the colors and graphics used.  Note what really makes the data communicate its message versus what looks like a cool concept for the designer, such as putting a steering wheel on the dashboard!  From the Google homepage, type dashboard or dashboard design or dashboard examples and select Images from the bar, as shown below.   You can then click on the more interesting ones to see a close up.  Also notice how the data is visualized – was the bar graph or the gauge more effective.  Can you understand within a few moments what the dashboard is measuring?   Recreate What You See For Fun! Once you find some dashboards you admire, recreate the information using the BI Dashboard.  By using data that is not meaningful […]