Since September, Angela and I have been actively posting on this blog about the SAS Business Intelligence toolset. It has been a lot of fun and thanks to all of your encouragement and kind comments. I’ll share some stats with you data geeks t…
Best Practices: To Write or Not to Write PROC OLAP… That is the Question
There are 2 ways to develop OLAP cubes in the SAS EBI platform: using SAS OLAP Cube Studio or by writing the PROC OLAP statement by hand and submitting the SAS program. There are pros and cons for both that I will go through in this post. Personall…
SAS Macro to Make Tiny URLs
Someone on SAS-L wanted a piece of SAS code to convert a long url to a short one. Well, here you go:filename in “x:\temp\in”;filename out “x:\temp\out.txt”;%macro MakeTiny(longUrl=); data _null_; file in lrecl=1028; put “url=&longUrl” ; ru…
NOTE: Decoding the _TYPE_ Variable (Golden Oldies)
Our mini-series of hints and tips from past decades continues with 1999…
Appearing in the same issue of The Missing Semicolon (TMS) was i) an advertisement for Year 2000 Support (do you remember “Y2K”?), and ii) an article entitled “Decoding the _TY…
SAS Prompts: When do you use a Variable Prompt?
If you have spent anytime building SAS prompts for a stored process, then you might have noticed the prompts near the bottom of the list and wondered how anyone would use those or even need them. In a previous post, I showed you how to use the data l…
Four ways to add row number in SQL Server
It is easy to sort any data in SQL Server, while it is not a trivial job to add a new variable of row number to an existent table. Here I come with four ways to realize the purpose.
/********** 0. Input data source *********************/
use…