ecently I stumbled upon a SUGI-Paper SAS 1-Liners by Stephen Hunt. I liked the way Stephen developed the 1-liner for STUDY DAY calculation.
Direct link:
One of the most common calculation used across all types of programming is d…
Too Big to Be Accurate(1): Which is the Most Powerful Calculator in the World?
Calculate the factorial of 171 (171!)? Just TRY! It is equal to 171*170*169*….2*1.
1. Google calculator
As Google fanatics, I first try to search the answer via Google:
Whoops, nothing interested returned! Type “170!” and get the output:
Why kinda things happened in this calculator? 171! is just equal to 171*170!.
2. Excel
Switch to Excel spreadsheet. Function fact(*) […]
How to install a loopback adapter on Windows 2003
A loopback adapter can be very useful for testing networking features on a server that doesn’t have a network adapter already installed, and Microsoft provides this feature in Windows Server 2003. To install the Microsoft Loopback Adapter, follow these steps: Go to Start | Control Panel | Add Hardware. In the introductory dialog box, click […]
A two-step transpose approach to reshape data
New in SAS 9.2, the TRANSPOSE procedure accepts multiple IDs in its ID statement. More than one IDs would automatically concatenate together as the new variable names. Previously, Proc Transpose usually only allows one ID. As the result, the concatena…
Scatterplots and enhancements
When you have two numeric variables and are interested in the relationship between them, the basic statistical graph is the scatterplot. These can be good, but there are ways to enhance them and there are also alternatives which can be better in so…
Which one is your BI Architetcure
Got an email with this classic cartoon attached.
Its sooooooo true!
(Makes me wonder when Google and Apple will attempt to provide enterprise BI tools, or then again do they already?)