Apr 23, 2013

My first Data viz with Tableau software


This is the My first Data viz with Tableau Public free software...
This viz shows the Number of SAS certified professionals who have volunteered to be part of the Public Registry of SAS Certified Professionals as of Dec 2011...

From the data, we see that USA, India and Australia have a lot of SAS certified people across the globe....

This product is amazingly easy to use and I see a bright future to this product...
I hope to see SAS Visual Analytics catch up with this tool as early as possible.


Concatenate Strings the Smarter way with CAT / CATX / CATT functions...

Here are the Definitions of these functions…
CAT() – Concatenates character strings without removing leading or trailing blanks
CATX() – Concatenates character strings, removes leading and trailing blanks, and inserts separators
CATT() – Concatenates character strings and removes trailing blanks
CATS() – Concatenates character strings and removes leading and trailing blanks, no seperators
The results of the CAT, CATS, CATT, and CATX functions are usually equivalent to those that are produced by certain combinations of the concatenation operator (||) and the TRIM and LEFT functions. However, using the CAT, CATS, CATT, and CATX functions is faster than using TRIM and LEFT, and you can use them with the OF syntax for variable lists in calling environments that support variable lists…
Read more in the SAS Documentation below with examples….